-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 3 posts ] 
  Previous topic | Next topic 
Author Message
abaldoni
 Post subject: Lazy loading not working
PostPosted: Sun Feb 01, 2004 9:36 am 
Newbie

Joined: Sun Feb 01, 2004 9:26 am
Posts: 3
Location: ITALY
I'm working with a legacy database and i'm trying to map the following:

Code:
MainClass
  Primary key MainPK
  Set of SubClass

SubClass
  Primary key SubPK
  Foreign key MainPK
  Set of SubSubClass

SubSubClass
  Primary key SubSubPK
  Foreign key SubPK
  Foreign key MainPK


All sets are one-to-many associations.

When i load a MainClass object, the
Code:
Set of SubClass
is lazily loaded. Then I access the
Code:
Set of SubSubClass
: I can see Hibernate issuing the SQL code needed to lazily load the
Code:
Set of SubSubClass
but when I access it it is empty.

The SQL issued is like this:
Code:
select prop1, prop2 ... from MainClass
select prop1_1, prop1_2 ... from SubClass
select prop1_1, prop1_2 ... from SubClass
...
select prop2_1, prop2_2 ... from SubSubClass order by SubSubPK
select prop2_1, prop2_2 ... from SubSubClass where MainPK = ? and SubPK = ? and SubSubPK = ?
select prop2_1, prop2_2 ... from SubSubClass order by  where MainPK = ? and SubPK = ? and SubSubPK = ?
...


Disabling the lazy loading doesn't work.

Any suggestion is appreciated.
Top
 Profile  
 
michael
 Post subject:
PostPosted: Sun Feb 01, 2004 9:42 am 
Hibernate Team
Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany
Check the generated SQL and execute it manually, and check if there are really records loaded. I suspect your mapping does not fit to the way the data is stored in the db.
Top
 Profile  
 
abaldoni
 Post subject:
PostPosted: Sun Feb 01, 2004 10:48 am 
Newbie

Joined: Sun Feb 01, 2004 9:26 am
Posts: 3
Location: ITALY
Here is the log of Hibernate. The null values returned are ok since i'm using a test row with only the keys valued.

Code:
15:40:31,963 DEBUG SessionImpl:1460 - find:
        from Punto p where p.id = 'U998'
   
15:40:31,963 DEBUG QueryParameters:108 - named parameters: {}
15:40:31,993 DEBUG QueryTranslator:147 - compiling query
15:40:32,023 DEBUG SessionImpl:2193 - flushing session
15:40:32,023 DEBUG SessionImpl:2321 - Flushing entities and processing referenced collections
15:40:32,023 DEBUG SessionImpl:2664 - Processing unreferenced collections
15:40:32,023 DEBUG SessionImpl:2678 - Scheduling collection removes/(re)creates/updates
15:40:32,023 DEBUG SessionImpl:2217 - Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
15:40:32,023 DEBUG SessionImpl:2222 - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
15:40:32,023 DEBUG SessionImpl:1745 - Dont need to execute flush
15:40:32,023 DEBUG QueryTranslator:199 - HQL:
        from it.hln.cura.DataTypes.Punto p where p.id = 'U998'
   
15:40:32,023 DEBUG QueryTranslator:200 - SQL: select punto0_.idpunto as idpunto, punto0_.clContatore as clContat2_, punto0_.dsBancaCAB as dsBancaCAB, punto0_.cnCoorGeoLatp as cnCoorGe4_, punto0_.dsNoteAutoProduz as dsNoteAu5_, punto0_.dsNoteTurniLavoro as dsNoteTu6_, punto0_.dsIndirizzo as dsIndiri7_, punto0_.dsComune as dsComune, punto0_.dsLocalita as dsLocalita, punto0_.dsCAP as dsCAP, punto0_.dsProvincia as dsProvi11_, punto0_.cnap as cnap, punto0_.dsContratto as dsContr13_, punto0_.dsTelefonoRef as dsTelef14_, punto0_.cliea as cliea, punto0_.cnCoorGeoLatg as cnCoorG16_, punto0_.cnvu as cnvu, punto0_.cnwMaxDisp as cnwMaxDisp, punto0_.cnvp as cnvp, punto0_.clBilanciamento as clBilan20_, punto0_.dsBanca as dsBanca, punto0_.dsNoteImpElettrico as dsNoteI22_, punto0_.cnCoorGeoLons as cnCoorG23_, punto0_.cnCoorGeoLonp as cnCoorG24_, punto0_.clPunto as clPunto, punto0_.dsReferente as dsRefer26_, punto0_.dsIVADichInt as dsIVADi27_, punto0_.dsPagamento as dsPagam28_, punto0_.cnCoorGeoLong as cnCoorG29_, punto0_.cnIVAPerc as cnIVAPerc, punto0_.cntep as cntep, punto0_.dsnUtenteENEL as dsnUten32_, punto0_.clOpzione as clOpzione, punto0_.dsBancaCC as dsBancaCC, punto0_.cnb as cnb, punto0_.cna as cna, punto0_.dtIn as dtIn, punto0_.dsTelefono as dsTelefono, punto0_.cnCoorpGbn as cnCoorpGbn, punto0_.dsTariffa as dsTariffa, punto0_.dsNome as dsNome, punto0_.dsEMail as dsEMail, punto0_.dsNoteContratto as dsNoteC43_, punto0_.dsnLocazioneENEL as dsnLoca44_, punto0_.dtOut as dtOut, punto0_.cnOGKWH as cnOGKWH, punto0_.cngrp as cngrp, punto0_.cnCoorpGbe as cnCoorpGbe, punto0_.cnIEAADDKWH as cnIEAAD49_, punto0_.dsPIVA as dsPIVA, punto0_.dsNoteGRTN as dsNoteGRTN, punto0_.dsNoteFatture as dsNoteF52_, punto0_.dsFax as dsFax, punto0_.dsBancaABI as dsBancaABI, punto0_.dsIndirizzoForn as dsIndir55_, punto0_.dsComuneForn as dsComun56_, punto0_.dsLocalitaForn as dsLocal57_, punto0_.dsProvinciaForn as dsProvi58_, punto0_.clContratto_ as clContr59_, punto0_.cntp as cntp, punto0_.dsPassword as dsPassword, punto0_.dsNoteCicloProd as dsNoteC62_, punto0_.cnzp as cnzp, punto0_.dsNomeAbbr as dsNomeAbbr, punto0_.idPuntoGRTN as idPunto65_, punto0_.dsNoteAzienda as dsNoteA66_, punto0_.dsUtilizzazione as dsUtili67_, punto0_.cnCoorGeoLats as cnCoorG68_ from Punti punto0_ where (punto0_.idpunto='U998' )
15:40:32,033 DEBUG BatcherImpl:192 - about to open: 0 open PreparedStatements, 0 open ResultSets
15:40:32,033 DEBUG SQL:223 - select punto0_.idpunto as idpunto, punto0_.clContatore as clContat2_, punto0_.dsBancaCAB as dsBancaCAB, punto0_.cnCoorGeoLatp as cnCoorGe4_, punto0_.dsNoteAutoProduz as dsNoteAu5_, punto0_.dsNoteTurniLavoro as dsNoteTu6_, punto0_.dsIndirizzo as dsIndiri7_, punto0_.dsComune as dsComune, punto0_.dsLocalita as dsLocalita, punto0_.dsCAP as dsCAP, punto0_.dsProvincia as dsProvi11_, punto0_.cnap as cnap, punto0_.dsContratto as dsContr13_, punto0_.dsTelefonoRef as dsTelef14_, punto0_.cliea as cliea, punto0_.cnCoorGeoLatg as cnCoorG16_, punto0_.cnvu as cnvu, punto0_.cnwMaxDisp as cnwMaxDisp, punto0_.cnvp as cnvp, punto0_.clBilanciamento as clBilan20_, punto0_.dsBanca as dsBanca, punto0_.dsNoteImpElettrico as dsNoteI22_, punto0_.cnCoorGeoLons as cnCoorG23_, punto0_.cnCoorGeoLonp as cnCoorG24_, punto0_.clPunto as clPunto, punto0_.dsReferente as dsRefer26_, punto0_.dsIVADichInt as dsIVADi27_, punto0_.dsPagamento as dsPagam28_, punto0_.cnCoorGeoLong as cnCoorG29_, punto0_.cnIVAPerc as cnIVAPerc, punto0_.cntep as cntep, punto0_.dsnUtenteENEL as dsnUten32_, punto0_.clOpzione as clOpzione, punto0_.dsBancaCC as dsBancaCC, punto0_.cnb as cnb, punto0_.cna as cna, punto0_.dtIn as dtIn, punto0_.dsTelefono as dsTelefono, punto0_.cnCoorpGbn as cnCoorpGbn, punto0_.dsTariffa as dsTariffa, punto0_.dsNome as dsNome, punto0_.dsEMail as dsEMail, punto0_.dsNoteContratto as dsNoteC43_, punto0_.dsnLocazioneENEL as dsnLoca44_, punto0_.dtOut as dtOut, punto0_.cnOGKWH as cnOGKWH, punto0_.cngrp as cngrp, punto0_.cnCoorpGbe as cnCoorpGbe, punto0_.cnIEAADDKWH as cnIEAAD49_, punto0_.dsPIVA as dsPIVA, punto0_.dsNoteGRTN as dsNoteGRTN, punto0_.dsNoteFatture as dsNoteF52_, punto0_.dsFax as dsFax, punto0_.dsBancaABI as dsBancaABI, punto0_.dsIndirizzoForn as dsIndir55_, punto0_.dsComuneForn as dsComun56_, punto0_.dsLocalitaForn as dsLocal57_, punto0_.dsProvinciaForn as dsProvi58_, punto0_.clContratto_ as clContr59_, punto0_.cntp as cntp, punto0_.dsPassword as dsPassword, punto0_.dsNoteCicloProd as dsNoteC62_, punto0_.cnzp as cnzp, punto0_.dsNomeAbbr as dsNomeAbbr, punto0_.idPuntoGRTN as idPunto65_, punto0_.dsNoteAzienda as dsNoteA66_, punto0_.dsUtilizzazione as dsUtili67_, punto0_.cnCoorGeoLats as cnCoorG68_ from Punti punto0_ where (punto0_.idpunto='U998' )
Hibernate: select punto0_.idpunto as idpunto, punto0_.clContatore as clContat2_, punto0_.dsBancaCAB as dsBancaCAB, punto0_.cnCoorGeoLatp as cnCoorGe4_, punto0_.dsNoteAutoProduz as dsNoteAu5_, punto0_.dsNoteTurniLavoro as dsNoteTu6_, punto0_.dsIndirizzo as dsIndiri7_, punto0_.dsComune as dsComune, punto0_.dsLocalita as dsLocalita, punto0_.dsCAP as dsCAP, punto0_.dsProvincia as dsProvi11_, punto0_.cnap as cnap, punto0_.dsContratto as dsContr13_, punto0_.dsTelefonoRef as dsTelef14_, punto0_.cliea as cliea, punto0_.cnCoorGeoLatg as cnCoorG16_, punto0_.cnvu as cnvu, punto0_.cnwMaxDisp as cnwMaxDisp, punto0_.cnvp as cnvp, punto0_.clBilanciamento as clBilan20_, punto0_.dsBanca as dsBanca, punto0_.dsNoteImpElettrico as dsNoteI22_, punto0_.cnCoorGeoLons as cnCoorG23_, punto0_.cnCoorGeoLonp as cnCoorG24_, punto0_.clPunto as clPunto, punto0_.dsReferente as dsRefer26_, punto0_.dsIVADichInt as dsIVADi27_, punto0_.dsPagamento as dsPagam28_, punto0_.cnCoorGeoLong as cnCoorG29_, punto0_.cnIVAPerc as cnIVAPerc, punto0_.cntep as cntep, punto0_.dsnUtenteENEL as dsnUten32_, punto0_.clOpzione as clOpzione, punto0_.dsBancaCC as dsBancaCC, punto0_.cnb as cnb, punto0_.cna as cna, punto0_.dtIn as dtIn, punto0_.dsTelefono as dsTelefono, punto0_.cnCoorpGbn as cnCoorpGbn, punto0_.dsTariffa as dsTariffa, punto0_.dsNome as dsNome, punto0_.dsEMail as dsEMail, punto0_.dsNoteContratto as dsNoteC43_, punto0_.dsnLocazioneENEL as dsnLoca44_, punto0_.dtOut as dtOut, punto0_.cnOGKWH as cnOGKWH, punto0_.cngrp as cngrp, punto0_.cnCoorpGbe as cnCoorpGbe, punto0_.cnIEAADDKWH as cnIEAAD49_, punto0_.dsPIVA as dsPIVA, punto0_.dsNoteGRTN as dsNoteGRTN, punto0_.dsNoteFatture as dsNoteF52_, punto0_.dsFax as dsFax, punto0_.dsBancaABI as dsBancaABI, punto0_.dsIndirizzoForn as dsIndir55_, punto0_.dsComuneForn as dsComun56_, punto0_.dsLocalitaForn as dsLocal57_, punto0_.dsProvinciaForn as dsProvi58_, punto0_.clContratto_ as clContr59_, punto0_.cntp as cntp, punto0_.dsPassword as dsPassword, punto0_.dsNoteCicloProd as dsNoteC62_, punto0_.cnzp as cnzp, punto0_.dsNomeAbbr as dsNomeAbbr, punto0_.idPuntoGRTN as idPunto65_, punto0_.dsNoteAzienda as dsNoteA66_, punto0_.dsUtilizzazione as dsUtili67_, punto0_.cnCoorGeoLats as cnCoorG68_ from Punti punto0_ where (punto0_.idpunto='U998' )
15:40:32,033 DEBUG BatcherImpl:227 - preparing statement
15:40:32,123 DEBUG Loader:196 - processing result set
15:40:32,123 DEBUG StringType:68 - returning 'U998' as column: idpunto
15:40:32,123 DEBUG Loader:404 - result row: U998
15:40:32,123 DEBUG Loader:535 - Initializing object from ResultSet: U998
15:40:32,123 DEBUG Loader:604 - Hydrating entity: it.hln.cura.DataTypes.Punto#U998
15:40:32,123 DEBUG StringType:64 - returning null as column: clContat2_
15:40:32,123 DEBUG StringType:64 - returning null as column: dsBancaCAB
15:40:32,123 DEBUG LongType:64 - returning null as column: cnCoorGe4_
15:40:32,133 DEBUG StringType:64 - returning null as column: dsNoteAu5_
15:40:32,133 DEBUG StringType:64 - returning null as column: dsNoteTu6_
15:40:32,133 DEBUG StringType:64 - returning null as column: dsIndiri7_
15:40:32,133 DEBUG StringType:64 - returning null as column: dsComune
15:40:32,133 DEBUG StringType:64 - returning null as column: dsLocalita
15:40:32,133 DEBUG StringType:64 - returning null as column: dsCAP
15:40:32,133 DEBUG StringType:64 - returning null as column: dsProvi11_
15:40:32,133 DEBUG LongType:64 - returning null as column: cnap
15:40:32,133 DEBUG StringType:64 - returning null as column: dsContr13_
15:40:32,133 DEBUG StringType:64 - returning null as column: dsTelef14_
15:40:32,143 DEBUG BooleanType:64 - returning null as column: cliea
15:40:32,143 DEBUG LongType:64 - returning null as column: cnCoorG16_
15:40:32,143 DEBUG LongType:64 - returning null as column: cnvu
15:40:32,143 DEBUG LongType:64 - returning null as column: cnwMaxDisp
15:40:32,143 DEBUG LongType:64 - returning null as column: cnvp
15:40:32,143 DEBUG StringType:64 - returning null as column: clBilan20_
15:40:32,143 DEBUG StringType:64 - returning null as column: dsBanca
15:40:32,143 DEBUG StringType:64 - returning null as column: dsNoteI22_
15:40:32,143 DEBUG DoubleType:64 - returning null as column: cnCoorG23_
15:40:32,143 DEBUG LongType:64 - returning null as column: cnCoorG24_
15:40:32,143 DEBUG StringType:64 - returning null as column: clPunto
15:40:32,143 DEBUG StringType:64 - returning null as column: dsRefer26_
15:40:32,143 DEBUG StringType:64 - returning null as column: dsIVADi27_
15:40:32,143 DEBUG StringType:64 - returning null as column: dsPagam28_
15:40:32,153 DEBUG LongType:64 - returning null as column: cnCoorG29_
15:40:32,153 DEBUG DoubleType:64 - returning null as column: cnIVAPerc
15:40:32,153 DEBUG LongType:64 - returning null as column: cntep
15:40:32,153 DEBUG StringType:64 - returning null as column: dsnUten32_
15:40:32,153 DEBUG StringType:64 - returning null as column: clOpzione
15:40:32,153 DEBUG StringType:64 - returning null as column: dsBancaCC
15:40:32,153 DEBUG DoubleType:64 - returning null as column: cnb
15:40:32,153 DEBUG DoubleType:64 - returning null as column: cna
15:40:32,153 DEBUG TimestampType:64 - returning null as column: dtIn
15:40:32,153 DEBUG StringType:64 - returning null as column: dsTelefono
15:40:32,163 DEBUG DoubleType:64 - returning null as column: cnCoorpGbn
15:40:32,163 DEBUG StringType:64 - returning null as column: dsTariffa
15:40:32,163 DEBUG StringType:64 - returning null as column: dsNome
15:40:32,163 DEBUG StringType:64 - returning null as column: dsEMail
15:40:32,163 DEBUG StringType:64 - returning null as column: dsNoteC43_
15:40:32,163 DEBUG StringType:64 - returning null as column: dsnLoca44_
15:40:32,163 DEBUG TimestampType:64 - returning null as column: dtOut
15:40:32,163 DEBUG DoubleType:64 - returning null as column: cnOGKWH
15:40:32,163 DEBUG LongType:64 - returning null as column: cngrp
15:40:32,163 DEBUG DoubleType:64 - returning null as column: cnCoorpGbe
15:40:32,163 DEBUG DoubleType:64 - returning null as column: cnIEAAD49_
15:40:32,163 DEBUG StringType:64 - returning null as column: dsPIVA
15:40:32,163 DEBUG StringType:64 - returning null as column: dsNoteGRTN
15:40:32,183 DEBUG StringType:64 - returning null as column: dsNoteF52_
15:40:32,183 DEBUG StringType:64 - returning null as column: dsFax
15:40:32,183 DEBUG StringType:64 - returning null as column: dsBancaABI
15:40:32,183 DEBUG StringType:64 - returning null as column: dsIndir55_
15:40:32,183 DEBUG StringType:64 - returning null as column: dsComun56_
15:40:32,183 DEBUG StringType:64 - returning null as column: dsLocal57_
15:40:32,183 DEBUG StringType:64 - returning null as column: dsProvi58_
15:40:32,183 DEBUG BooleanType:64 - returning null as column: clContr59_
15:40:32,183 DEBUG LongType:64 - returning null as column: cntp
15:40:32,183 DEBUG StringType:64 - returning null as column: dsPassword
15:40:32,193 DEBUG StringType:64 - returning null as column: dsNoteC62_
15:40:32,193 DEBUG LongType:64 - returning null as column: cnzp
15:40:32,193 DEBUG StringType:64 - returning null as column: dsNomeAbbr
15:40:32,193 DEBUG StringType:64 - returning null as column: idPunto65_
15:40:32,193 DEBUG StringType:64 - returning null as column: dsNoteA66_
15:40:32,193 DEBUG StringType:64 - returning null as column: dsUtili67_
15:40:32,193 DEBUG DoubleType:64 - returning null as column: cnCoorG68_
15:40:32,193 DEBUG Loader:225 - done processing result set (1 rows)
15:40:32,193 DEBUG BatcherImpl:199 - done closing: 0 open PreparedStatements, 0 open ResultSets
15:40:32,193 DEBUG BatcherImpl:240 - closing statement
15:40:32,203 DEBUG Loader:238 - total objects hydrated: 1
15:40:32,203 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.Punto#U998]
15:40:32,203 DEBUG SessionImpl:3746 - collection not cached
15:40:32,213 DEBUG SessionImpl:3746 - collection not cached
15:40:32,213 DEBUG SessionImpl:3746 - collection not cached
15:40:32,213 DEBUG SessionImpl:2145 - calling onLoad()
15:40:32,213 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.Punto#U998]
15:40:32,213 DEBUG SessionImpl:3000 - initializing non-lazy collections
15:40:32,213 DEBUG SessionImpl:3132 - initializing collection [it.hln.cura.DataTypes.Punto.giornateTipo#U998]
15:40:32,213 DEBUG BatcherImpl:192 - about to open: 0 open PreparedStatements, 0 open ResultSets
15:40:32,223 DEBUG SQL:223 - select giornateti0_.idPunto as idPunto__, giornateti0_.idgiornata_t as idgiorna2___, giornateti0_.idPunto as idPunto0_, giornateti0_.idgiornata_t as idgiorna2_0_, giornateti0_.dsGiornata as dsGiornata0_, giornateti0_.dsNote as dsNote0_, giornateti0_.clInUso as clInUso0_ from giornate_t giornateti0_ where giornateti0_.idPunto=? order by giornateti0_.idgiornata_t
Hibernate: select giornateti0_.idPunto as idPunto__, giornateti0_.idgiornata_t as idgiorna2___, giornateti0_.idPunto as idPunto0_, giornateti0_.idgiornata_t as idgiorna2_0_, giornateti0_.dsGiornata as dsGiornata0_, giornateti0_.dsNote as dsNote0_, giornateti0_.clInUso as clInUso0_ from giornate_t giornateti0_ where giornateti0_.idPunto=? order by giornateti0_.idgiornata_t
15:40:32,223 DEBUG BatcherImpl:227 - preparing statement
15:40:32,233 DEBUG StringType:46 - binding 'U998' to parameter: 1
15:40:32,243 DEBUG Loader:326 - result set contains (possibly empty) collection: [it.hln.cura.DataTypes.Punto.giornateTipo#U998]
15:40:32,243 DEBUG SessionImpl:2902 - uninitialized collection: initializing
15:40:32,243 DEBUG Loader:196 - processing result set
15:40:32,243 DEBUG StringType:68 - returning 'U998' as column: idPunto0_
15:40:32,243 DEBUG StringType:68 - returning 'x.-xxXX' as column: idgiorna2_0_
15:40:32,253 DEBUG Loader:404 - result row: it.hln.cura.DataTypes.GiornataTipo@ade540b4
15:40:32,253 DEBUG Loader:535 - Initializing object from ResultSet: it.hln.cura.DataTypes.GiornataTipo@ade540b4
15:40:32,253 DEBUG Loader:604 - Hydrating entity: it.hln.cura.DataTypes.GiornataTipo#it.hln.cura.DataTypes.GiornataTipo@ade540b4
15:40:32,253 DEBUG StringType:68 - returning 'the quick brown fox' as column: dsGiornata0_
15:40:32,253 DEBUG StringType:64 - returning null as column: dsNote0_
15:40:32,253 DEBUG BooleanType:64 - returning null as column: clInUso0_
15:40:32,253 DEBUG StringType:68 - returning 'U998' as column: idPunto__
15:40:32,253 DEBUG Loader:288 - found row of collection: [it.hln.cura.DataTypes.Punto.giornateTipo#U998]
15:40:32,253 DEBUG SessionImpl:2925 - reading row
15:40:32,253 DEBUG StringType:68 - returning 'U998' as column: idPunto__
15:40:32,253 DEBUG StringType:68 - returning 'x.-xxXX' as column: idgiorna2___
15:40:32,263 DEBUG SessionImpl:1913 - loading [it.hln.cura.DataTypes.GiornataTipo#it.hln.cura.DataTypes.GiornataTipo@ade540b4]
15:40:32,263 DEBUG SessionImpl:2010 - attempting to resolve [it.hln.cura.DataTypes.GiornataTipo#it.hln.cura.DataTypes.GiornataTipo@ade540b4]
15:40:32,263 DEBUG SessionImpl:2043 - object not resolved in any cache [it.hln.cura.DataTypes.GiornataTipo#it.hln.cura.DataTypes.GiornataTipo@ade540b4]
15:40:32,263 DEBUG EntityPersister:417 - Materializing entity: [it.hln.cura.DataTypes.GiornataTipo#it.hln.cura.DataTypes.GiornataTipo@ade540b4]
15:40:32,263 DEBUG BatcherImpl:192 - about to open: 1 open PreparedStatements, 1 open ResultSets
15:40:32,263 DEBUG SQL:223 - select giornatati0_.idPunto as idPunto0_, giornatati0_.idgiornata_t as idgiorna2_0_, giornatati0_.dsGiornata as dsGiornata0_, giornatati0_.dsNote as dsNote0_, giornatati0_.clInUso as clInUso0_ from giornate_t giornatati0_ where giornatati0_.idPunto=? and giornatati0_.idgiornata_t=?
Hibernate: select giornatati0_.idPunto as idPunto0_, giornatati0_.idgiornata_t as idgiorna2_0_, giornatati0_.dsGiornata as dsGiornata0_, giornatati0_.dsNote as dsNote0_, giornatati0_.clInUso as clInUso0_ from giornate_t giornatati0_ where giornatati0_.idPunto=? and giornatati0_.idgiornata_t=?
15:40:32,263 DEBUG BatcherImpl:227 - preparing statement
15:40:32,263 DEBUG StringType:46 - binding 'U998' to parameter: 1
15:40:32,263 DEBUG StringType:46 - binding 'x.-xxXX' to parameter: 2
15:40:32,273 DEBUG Loader:196 - processing result set
15:40:32,283 DEBUG Loader:404 - result row: it.hln.cura.DataTypes.GiornataTipo@ade540b4
15:40:32,283 DEBUG Loader:535 - Initializing object from ResultSet: it.hln.cura.DataTypes.GiornataTipo@ade540b4
15:40:32,283 DEBUG Loader:604 - Hydrating entity: it.hln.cura.DataTypes.GiornataTipo#it.hln.cura.DataTypes.GiornataTipo@ade540b4
15:40:32,283 DEBUG StringType:68 - returning 'the quick brown fox' as column: dsGiornata0_
15:40:32,283 DEBUG StringType:64 - returning null as column: dsNote0_
15:40:32,293 DEBUG BooleanType:64 - returning null as column: clInUso0_
15:40:32,293 DEBUG Loader:225 - done processing result set (1 rows)
15:40:32,293 DEBUG BatcherImpl:199 - done closing: 1 open PreparedStatements, 1 open ResultSets
15:40:32,293 DEBUG BatcherImpl:240 - closing statement
15:40:32,293 DEBUG Loader:238 - total objects hydrated: 1
15:40:32,293 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.GiornataTipo#it.hln.cura.DataTypes.GiornataTipo@ade540b4]
15:40:32,303 DEBUG SessionImpl:3746 - collection not cached
15:40:32,303 DEBUG SessionImpl:2145 - calling onLoad()
15:40:32,303 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.GiornataTipo#it.hln.cura.DataTypes.GiornataTipo@ade540b4]
15:40:32,303 DEBUG Loader:225 - done processing result set (1 rows)
15:40:32,303 DEBUG BatcherImpl:199 - done closing: 0 open PreparedStatements, 0 open ResultSets
15:40:32,303 DEBUG BatcherImpl:240 - closing statement
15:40:32,303 DEBUG Loader:238 - total objects hydrated: 1
15:40:32,303 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.GiornataTipo#it.hln.cura.DataTypes.GiornataTipo@ade540b4]
15:40:32,303 DEBUG SessionImpl:3746 - collection not cached
15:40:32,303 DEBUG SessionImpl:2145 - calling onLoad()
15:40:32,313 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.GiornataTipo#it.hln.cura.DataTypes.GiornataTipo@ade540b4]
15:40:32,313 DEBUG SessionImpl:2961 - 1 collections were found in result set
15:40:32,313 DEBUG SessionImpl:2979 - collection fully initialized: [it.hln.cura.DataTypes.Punto.giornateTipo#U998]
15:40:32,313 DEBUG SessionImpl:2982 - 1 collections initialized
15:40:32,313 DEBUG SessionImpl:3000 - initializing non-lazy collections
x.-xxXX
15:40:32,313 DEBUG SessionImpl:3132 - initializing collection [it.hln.cura.DataTypes.GiornataTipo.dettaglio#it.hln.cura.DataTypes.GiornataTipo@ade540b4]
15:40:32,313 DEBUG BatcherImpl:192 - about to open: 0 open PreparedStatements, 0 open ResultSets
15:40:32,313 DEBUG SQL:223 - select dettaglio0_.idPunto as idPunto__, dettaglio0_.idgiornata_t as idgiorna2___, dettaglio0_.hg as hg__, dettaglio0_.idPunto as idPunto0_, dettaglio0_.idgiornata_t as idgiorna2_0_, dettaglio0_.hg as hg0_, dettaglio0_.e as e0_, dettaglio0_.w as w0_, dettaglio0_.k as k0_, dettaglio0_.dsNote as dsNote0_, dettaglio0_.w * dettaglio0_.k as f15_0_ from giornate_t_dett dettaglio0_ where dettaglio0_.idPunto=? and dettaglio0_.idgiornata_t=? order by dettaglio0_.hg
Hibernate: select dettaglio0_.idPunto as idPunto__, dettaglio0_.idgiornata_t as idgiorna2___, dettaglio0_.hg as hg__, dettaglio0_.idPunto as idPunto0_, dettaglio0_.idgiornata_t as idgiorna2_0_, dettaglio0_.hg as hg0_, dettaglio0_.e as e0_, dettaglio0_.w as w0_, dettaglio0_.k as k0_, dettaglio0_.dsNote as dsNote0_, dettaglio0_.w * dettaglio0_.k as f15_0_ from giornate_t_dett dettaglio0_ where dettaglio0_.idPunto=? and dettaglio0_.idgiornata_t=? order by dettaglio0_.hg
15:40:32,313 DEBUG BatcherImpl:227 - preparing statement
15:40:32,313 DEBUG StringType:46 - binding 'U998' to parameter: 1
15:40:32,323 DEBUG StringType:46 - binding 'x.-xxXX' to parameter: 2
15:40:32,323 DEBUG Loader:326 - result set contains (possibly empty) collection: [it.hln.cura.DataTypes.GiornataTipo.dettaglio#it.hln.cura.DataTypes.GiornataTipo@ade540b4]
15:40:32,323 DEBUG SessionImpl:2902 - uninitialized collection: initializing
15:40:32,333 DEBUG Loader:196 - processing result set
15:40:32,333 DEBUG StringType:68 - returning 'U998' as column: idPunto0_
15:40:32,333 DEBUG StringType:68 - returning 'x.-xxXX' as column: idgiorna2_0_
15:40:32,484 DEBUG IntegerType:68 - returning '1' as column: hg0_
15:40:32,484 DEBUG Loader:404 - result row: it.hln.cura.DataTypes.FasciaOraria@1
15:40:32,484 DEBUG Loader:535 - Initializing object from ResultSet: it.hln.cura.DataTypes.FasciaOraria@1
15:40:32,484 DEBUG Loader:604 - Hydrating entity: it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@1
15:40:32,484 DEBUG DoubleType:64 - returning null as column: e0_
15:40:32,484 DEBUG DoubleType:64 - returning null as column: w0_
15:40:32,484 DEBUG DoubleType:64 - returning null as column: k0_
15:40:32,484 DEBUG StringType:64 - returning null as column: dsNote0_
15:40:32,484 DEBUG DoubleType:64 - returning null as column: f15_0_
15:40:32,484 DEBUG StringType:68 - returning 'U998' as column: idPunto__
15:40:32,484 DEBUG StringType:68 - returning 'x.-xxXX' as column: idgiorna2___
15:40:32,484 DEBUG Loader:288 - found row of collection: [it.hln.cura.DataTypes.GiornataTipo.dettaglio#it.hln.cura.DataTypes.GiornataTipo@ade540b4]
15:40:32,484 DEBUG SessionImpl:2914 - new collection: instantiating
15:40:32,494 DEBUG StringType:68 - returning 'U998' as column: idPunto__
15:40:32,494 DEBUG StringType:68 - returning 'x.-xxXX' as column: idgiorna2___
15:40:32,494 DEBUG IntegerType:68 - returning '1' as column: hg__
15:40:32,494 DEBUG SessionImpl:1913 - loading [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@1]
15:40:32,494 DEBUG SessionImpl:2010 - attempting to resolve [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@1]
15:40:32,494 DEBUG SessionImpl:2043 - object not resolved in any cache [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@1]
15:40:32,494 DEBUG EntityPersister:417 - Materializing entity: [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@1]
15:40:32,494 DEBUG BatcherImpl:192 - about to open: 1 open PreparedStatements, 1 open ResultSets
15:40:32,494 DEBUG SQL:223 - select fasciaorar0_.idPunto as idPunto0_, fasciaorar0_.idgiornata_t as idgiorna2_0_, fasciaorar0_.hg as hg0_, fasciaorar0_.e as e0_, fasciaorar0_.w as w0_, fasciaorar0_.k as k0_, fasciaorar0_.dsNote as dsNote0_, fasciaorar0_.w * fasciaorar0_.k as f15_0_ from giornate_t_dett fasciaorar0_ where fasciaorar0_.idPunto=? and fasciaorar0_.idgiornata_t=? and fasciaorar0_.hg=?
Hibernate: select fasciaorar0_.idPunto as idPunto0_, fasciaorar0_.idgiornata_t as idgiorna2_0_, fasciaorar0_.hg as hg0_, fasciaorar0_.e as e0_, fasciaorar0_.w as w0_, fasciaorar0_.k as k0_, fasciaorar0_.dsNote as dsNote0_, fasciaorar0_.w * fasciaorar0_.k as f15_0_ from giornate_t_dett fasciaorar0_ where fasciaorar0_.idPunto=? and fasciaorar0_.idgiornata_t=? and fasciaorar0_.hg=?
15:40:32,494 DEBUG BatcherImpl:227 - preparing statement
15:40:32,494 DEBUG StringType:46 - binding 'U998' to parameter: 1
15:40:32,504 DEBUG StringType:46 - binding 'x.-xxXX' to parameter: 2
15:40:32,504 DEBUG IntegerType:46 - binding '1' to parameter: 3
15:40:32,504 DEBUG Loader:196 - processing result set
15:40:32,514 DEBUG Loader:404 - result row: it.hln.cura.DataTypes.FasciaOraria@1
15:40:32,514 DEBUG Loader:535 - Initializing object from ResultSet: it.hln.cura.DataTypes.FasciaOraria@1
15:40:32,514 DEBUG Loader:604 - Hydrating entity: it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@1
15:40:32,514 DEBUG DoubleType:64 - returning null as column: e0_
15:40:32,514 DEBUG DoubleType:64 - returning null as column: w0_
15:40:32,514 DEBUG DoubleType:64 - returning null as column: k0_
15:40:32,514 DEBUG StringType:64 - returning null as column: dsNote0_
15:40:32,514 DEBUG DoubleType:64 - returning null as column: f15_0_
15:40:32,514 DEBUG Loader:225 - done processing result set (1 rows)
15:40:32,514 DEBUG BatcherImpl:199 - done closing: 1 open PreparedStatements, 1 open ResultSets
15:40:32,524 DEBUG BatcherImpl:240 - closing statement
15:40:32,524 DEBUG Loader:238 - total objects hydrated: 1
15:40:32,524 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@1]
15:40:32,524 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@1]
...
23 more materialization with hg in [2..24]
...
15:40:33,685 DEBUG Loader:225 - done processing result set (24 rows)
15:40:33,685 DEBUG BatcherImpl:199 - done closing: 0 open PreparedStatements, 0 open ResultSets
15:40:33,685 DEBUG BatcherImpl:240 - closing statement
15:40:33,685 DEBUG Loader:238 - total objects hydrated: 24
15:40:33,695 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@1]
15:40:33,695 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@1]
15:40:33,695 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@2]
15:40:33,695 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@2]
15:40:33,695 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@3]
15:40:33,695 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@3]
15:40:33,695 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@4]
15:40:33,695 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@4]
15:40:33,705 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@5]
15:40:33,705 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@5]
15:40:33,705 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@6]
15:40:33,705 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@6]
15:40:33,705 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@7]
15:40:33,705 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@7]
15:40:33,705 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@8]
15:40:33,705 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@8]
15:40:33,705 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@9]
15:40:33,705 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@9]
15:40:33,705 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@a]
15:40:33,705 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@a]
15:40:33,705 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@b]
15:40:33,705 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@b]
15:40:33,705 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@c]
15:40:33,715 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@c]
15:40:33,715 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@d]
15:40:33,715 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@d]
15:40:33,715 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@e]
15:40:33,715 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@e]
15:40:33,715 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@f]
15:40:33,715 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@f]
15:40:33,715 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@10]
15:40:33,715 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@10]
15:40:33,715 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@11]
15:40:33,715 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@11]
15:40:33,715 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@12]
15:40:33,715 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@12]
15:40:33,715 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@13]
15:40:33,715 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@13]
15:40:33,725 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@14]
15:40:33,725 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@14]
15:40:33,725 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@15]
15:40:33,725 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@15]
15:40:33,725 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@16]
15:40:33,725 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@16]
15:40:33,725 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@17]
15:40:33,725 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@17]
15:40:33,725 DEBUG SessionImpl:2129 - resolving associations for [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@18]
15:40:33,745 DEBUG SessionImpl:2153 - done materializing entity [it.hln.cura.DataTypes.FasciaOraria#it.hln.cura.DataTypes.FasciaOraria@18]
15:40:33,745 DEBUG SessionImpl:2961 - 25 collections were found in result set
15:40:33,745 DEBUG SessionImpl:2979 - collection fully initialized: [it.hln.cura.DataTypes.GiornataTipo.dettaglio#it.hln.cura.DataTypes.GiornataTipo@ade540b4]
...
25 times the _same_ row
...
15:40:33,765 DEBUG SessionImpl:2982 - 25 collections initialized
15:40:33,765 DEBUG SessionImpl:3000 - initializing non-lazy collections
set.size=0
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 3 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.