Hibernate version: 3.2cr1
Full stack trace of any exception that occurs: ERROR: syntax error at or near "select" at character 283
Name and version of the database you are using: Postgresql 8.1.4
The generated SQL (show_sql=true):
Code:
select
this_.id as id13_3_,
this_1_.DESC_ID as DESC2_13_3_,
this_.token as token16_3_,
descriptio2_.DESC_ID as DESC1_2_0_,
value3_.lookup_id as lookup1_5_,
lookupvalu4_.id as lookupva2_5_,
select
a9.valkey
from
LOOKUP_VAL as a9
where
a9.id=value3_.lookupvalue_id as formula0_5_
Hello,
i've got a problem. The following automatically generated Query
Code:
select
this_.id as id13_3_,
this_1_.DESC_ID as DESC2_13_3_,
this_.token as token16_3_,
descriptio2_.DESC_ID as DESC1_2_0_,
value3_.lookup_id as lookup1_5_,
lookupvalu4_.id as lookupva2_5_,
select
a9.valkey
from
LOOKUP_VAL as a9
where
a9.id=value3_.lookupvalue_id as formula0_5_
couldn't be executed correctly because of missing of '('-brackets. If i put the brackets manually:
Code:
select
this_.id as id13_3_,
this_1_.DESC_ID as DESC2_13_3_,
this_.token as token16_3_,
descriptio2_.DESC_ID as DESC1_2_0_,
value3_.lookup_id as lookup1_5_,
lookupvalu4_.id as lookupva2_5_,
( select
a9.valkey
from
LOOKUP_VAL as a9
where
a9.id=value3_.lookupvalue_id
) as formula0_5_
postgres executes the query properly .
Please help with a hint or patch.
Thanks and sorry for my english ;-)
Login
FAQ
Search