I tried to build up a master-detail ui according to the example shown in video Quick Start, Part 3.
I followed step by step but with my entities based on an Orcale DB.
When running the application I get the following SQL error:
with the text: "IllegalArgumentException: You have attempted to set a value of type class java.lang.String for parameter ds_herDs with expected type of class com.company.testoracle.entity.Her from query string _
_ select e from testoracle$Anp e where e.herKurz = :ds_herDs order by e.name
_ ."_
I do not understand the construct “where e.herKurz = :ds_herDs_”
also the clause “where e.herKurz = :ds_herDs_kurz”, found in the manual leads to the same error.
So, how to solve this problem?
Thanks, Thomas
done, but now got the error: JPQLException: _ Exception Description: Problem compiling [
_ select e from testoracle$Anp e where e.herKurz.id = :ds_herDs order by e.name
_ ]. _ [37, 49] The state field path ‘e.herKurz.id’ cannot be resolved to a valid type.
Hi Kirill, now it works, thanks for your input. This notation ist a little bit strange for me, but anyway…
I now implemented my database tables in Studio and generated the depending UIs.
This works quite good but in some references/associations between fields in another table allication works in the following way:
I don’t get a dropdown menu although defined in my data model
the returned values of the table into the source filed are cryptic or references not the matching fields.
in the screens above you can see this behaviour:
In column “Podukt Typ” there should appear the key to this table (e.g. SMGw HW) instead of this cryptic string
In column “Hersteller” there should appear the short description (e.g. PPC) instead of the company’s name
This forces, of course, an error when trying to deiting this row.
In this screenshot you can see the missing dropdown for “Podukt Typ” and “Hersteller”
Hi Kirill,
maybe I’m too stupid with my last tries. So, I started from the scratch re-building the small application from the video creating “customer” and “order” entity and UI exactly step by step with the result see below:
This is not what I expected and I don’t find the handle to solve this problem…