Dear Users,

what goes wrong?

I have a one to many relation beetween three objects with hibernate 2.1

Hibernate: select this."class" as y1_0_ from EXPERIMENT_CLASS this where 1=1
Hibernate: select samples0_."sample_id" as y1___, samples0_."class" as y8___, samples0_."sample_id" as y1_0_, samples0_."data" as y2_0_, samples0_."time" as y3_0_, samples0_."sample_name" as y4_0_, samples0_."allowNewBin" as y5_0_, samples0_."saturated" as y6_0_, samples0_."quality_control" as y7_0_, samples0_."class" as y8_0_ from "gwSAMPLES" samples0_ where samples0_."class"=?
Hibernate: select spectra0_."spectra_id" as y1___, spectra0_."sample_id" as y5___, spectra0_."spectra_id" as y1_3_, spectra0_."apex_sn" as y2_3_, spectra0_."purity" as y3_3_, spectra0_."retention_index" as y4_3_, spectra0_."sample_id" as y5_3_, spectra0_."simialrity" as y6_3_, spectra0_."uniquemass" as y7_3_, spectra0_."bin_id" as y8_3_, spectra0_."apex" as y9_3_, spectra0_."spectra" as y10_3_, bin1_."bin_id" as y1_0_, bin1_."apex_sn" as y2_0_, bin1_."purity" as y3_0_, bin1_."retention_index" as y4_0_, bin1_."sample_id" as y5_0_, bin1_."spectra_id" as y6_0_, bin1_."uniquemass" as y7_0_, bin1_."apex" as y8_0_, bin1_."spectra" as y9_0_, bin1_."export" as y10_0_, bin1_."generatequantmass" as y11_0_, bin1_."minus" as y12_0_, bin1_."new" as y13_0_, bin1_."plus" as y14_0_, bin1_.quantmass` as quantmass`0_, bin1_."standard" as y16_0_, sample2_."sample_id" as y1_1_, sample2_."data" as y2_1_, sample2_."time" as y3_1_, sample2_."sample_name" as y4_1_, sample2_."allowNewBin" as y5_1_, sample2_."saturated" as y6_1_, sample2_."quality_control" as y7_1_, sample2_."class" as y8_1_, experiment3_."class" as y1_2_ from "SPECTRA" spectra0_, "gwBIN" bin1_, "gwSAMPLES" sample2_, EXPERIMENT_CLASS experiment3_ where spectra0_."sample_id"=? and spectra0_."bin_id"=bin1_."bin_id"(+) and bin1_."sample_id"=sample2_."sample_id"(+) and sample2_."class"=experiment3_."class"(+)
ERROR [main] (JDBCExceptionReporter.java:46) - [-5015] (at 783): Missing keyword:FROM
ERROR [main] (JDBCExceptionReporter.java:46) - [-5015] (at 783): Missing keyword:FROM
ERROR [main] (JDBCException.java:38) - could not initialize collection: [de.mpg.mpimp.golm.binbase.bellerophon.model.impl.hibernate.experiment.sample.Sample.spectra#921]
com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5015] (at 783): Missing keyword:FROM

Does anybody understand this stacktrace?

So thats a sniplet from the xml file with the "n" entinitys

<many-to-one
name="bin"
class="de.mpg.mpimp.golm.binbase.bellerophon.model.impl.hibernate.experiment.sample.bin.Bin"
cascade="none"
outer-join="auto"
update="true"
insert="true"
column="`bin_id`"
/>



And this with the one entinity

<set
name="anotatedSpectra"
lazy="true"
inverse="false"
cascade="none"
sort="unsorted"
>

<key
column="`bin_id`"
/>

<one-to-many
class="de.mpg.mpimp.golm.binbase.bellerophon.model.impl.hibernate.experiment.sample.spectra.Spectra"
/>
</set>


Sorry I'm an absolute newbie to hibernate :)


what goes wrong and how can I deal with this

where is your query? are you using hql, criteria, sql?

hi its my fault i use xdoclet to generate this object and i forgott i quote...

It's a blame I was looking hour in my code to fix this and it was so simple...