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_
Hallo,
habe folgendes Problem. Es wurde eine Abfrage generiert:
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_
Diese kann nicht ausgeführt werden, da ihr die Klammer fehlen. Wenn ich die Klammer manuell setze:
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_
kann Postgres die Abfrage ausführen.
Bitte um Hilfe/Korrektur.
Danke
Login
FAQ
Search