SdmAlerta is loaded in Flex but it comes loaded when saving and when updating. There's no SQL fired. All I can post is this:
When saving/inserting:
Code:
16:59:56,030 DEBUG org.hibernate.persister.entity.AbstractEntityPersister,http-8083-Processor21:2209 - Inserting entity: [xx.xxxxx.xxxxxx.model.SdmAlerta#241]
16:59:56,030 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor21:366 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
16:59:56,030 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor21:401 - insert into SDM_ALERTA (ALACTIVO, ALCONSULTA, ALFECHCREA, ALNOMBRE, ALOBSERVAC, PK_ALERTA) values (?, ?, ?, ?, ?, ?)
16:59:56,030 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor21:484 - preparing statement
16:59:56,030 DEBUG org.hibernate.persister.entity.AbstractEntityPersister,http-8083-Processor21:1997 - Dehydrating entity: [xx.xxxxx.xxxxxx.model.SdmAlerta#241]
16:59:56,030 DEBUG org.hibernate.type.NullableType,http-8083-Processor21:133 - binding '1' to parameter: 1
16:59:56,030 DEBUG org.hibernate.type.NullableType,http-8083-Processor21:133 - binding '02 marzo 2009' to parameter: 3
16:59:56,030 DEBUG org.hibernate.type.NullableType,http-8083-Processor21:133 - binding 'Hibernate forum' to parameter: 4
16:59:56,030 DEBUG org.hibernate.type.NullableType,http-8083-Processor21:133 - binding 'Hibernate forum' to parameter: 5
16:59:56,030 DEBUG org.hibernate.type.NullableType,http-8083-Processor21:133 - binding '241' to parameter: 6
16:59:56,030 DEBUG org.hibernate.jdbc.BatchingBatcher,http-8083-Processor21:44 - Executing batch size: 1
16:59:56,077 DEBUG org.hibernate.jdbc.Expectations$BasicExpectation,http-8083-Processor21:53 - success of batch update unknown: 0
16:59:56,077 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor21:374 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
16:59:56,077 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor21:533 - closing statement
16:59:56,077 DEBUG org.hibernate.persister.collection.AbstractCollectionPersister,http-8083-Processor21:1090 - Inserting collection: [xx.xxxxx.xxxxxx.model.SdmAlerta.sdxUsuarios#241]
16:59:56,077 DEBUG org.hibernate.persister.collection.AbstractCollectionPersister,http-8083-Processor21:1178 - collection was empty
16:59:56,077 DEBUG org.hibernate.persister.collection.AbstractCollectionPersister,http-8083-Processor21:1090 - Inserting collection: [xx.xxxxx.xxxxxx.model.SdmAlerta.sdxTipoperfs#241]
16:59:56,077 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor21:366 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
16:59:56,077 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor21:401 - insert into SDM_ALPRPERF (PK_ALERTA, PK_TIPOPERF) values (?, ?)
16:59:56,077 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor21:484 - preparing statement
16:59:56,077 DEBUG org.hibernate.type.NullableType,http-8083-Processor21:133 - binding '241' to parameter: 1
16:59:56,077 DEBUG org.hibernate.engine.IdentifierValue,http-8083-Processor21:104 - id unsaved-value: null
16:59:56,077 DEBUG org.hibernate.type.NullableType,http-8083-Processor21:133 - binding '1' to parameter: 2
16:59:56,077 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor21:226 - reusing prepared statement
16:59:56,077 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor21:401 - insert into SDM_ALPRPERF (PK_ALERTA, PK_TIPOPERF) values (?, ?)
16:59:56,077 DEBUG org.hibernate.type.NullableType,http-8083-Processor21:133 - binding '241' to parameter: 1
16:59:56,077 DEBUG org.hibernate.engine.IdentifierValue,http-8083-Processor21:104 - id unsaved-value: null
16:59:56,077 DEBUG org.hibernate.type.NullableType,http-8083-Processor21:133 - binding '43' to parameter: 2
16:59:56,077 DEBUG org.hibernate.persister.collection.AbstractCollectionPersister,http-8083-Processor21:1172 - done inserting collection: 2 rows inserted
When updating/mergingCode:
17:05:20,195 DEBUG org.hibernate.event.def.DefaultFlushEntityEventListener,http-8083-Processor22:236 - Updating entity: [xx.xxxxx.xxxxxx.model.SdmAlerta#241]
17:05:20,210 DEBUG org.hibernate.engine.Collections,http-8083-Processor22:176 - Collection found: [xx.xxxxx.xxxxxx.model.SdmAlerta.sdxUsuarios#241], was: [xx.xxxxx.xxxxxx.model.SdmAlerta.sdxUsuarios#241] (initialized)
17:05:20,210 DEBUG org.hibernate.engine.Collections,http-8083-Processor22:176 - Collection found: [xx.xxxxx.xxxxxx.model.SdmAlerta.sdxTipoperfs#241], was: [xx.xxxxx.xxxxxx.model.SdmAlerta.sdxTipoperfs#241] (initialized)
17:05:20,210 DEBUG org.hibernate.event.def.AbstractFlushingEventListener,http-8083-Processor22:210 - Processing unreferenced collections
17:05:20,210 DEBUG org.hibernate.event.def.AbstractFlushingEventListener,http-8083-Processor22:224 - Scheduling collection removes/(re)creates/updates
17:05:20,226 DEBUG org.hibernate.event.def.AbstractFlushingEventListener,http-8083-Processor22:85 - Flushed: 0 insertions, 1 updates, 0 deletions to 6 objects
17:05:20,226 DEBUG org.hibernate.event.def.AbstractFlushingEventListener,http-8083-Processor22:91 - Flushed: 0 (re)creations, 0 updates, 0 removals to 2 collections
17:05:20,226 DEBUG org.hibernate.pretty.Printer,http-8083-Processor22:83 - listing entities:
17:05:20,226 DEBUG org.hibernate.pretty.Printer,http-8083-Processor22:90 - xx.xxxxx.xxxxxx.model.SdxTipoperf{tidesc=Grabador, tipactivo=1, pkTipoperf=1, ticodigo=GR, tifechcrea=10 diciembre 2008}
17:05:20,226 DEBUG org.hibernate.pretty.Printer,http-8083-Processor22:90 - xx.xxxxx.xxxxxx.model.SdxTipoperf{tidesc=Comisión, tipactivo=1, pkTipoperf=43, ticodigo=CM, tifechcrea=24 febrero 2009}
17:05:20,226 DEBUG org.hibernate.pretty.Printer,http-8083-Processor22:90 - xx.xxxxx.xxxxxx.model.SdxTipoperf{tidesc=Valorador, tipactivo=1, pkTipoperf=62, ticodigo=VA, tifechcrea=26 febrero 2009}
17:05:20,226 DEBUG org.hibernate.pretty.Printer,http-8083-Processor22:90 - xx.xxxxx.xxxxxx.model.SdxTipoperf{tidesc=Administrativo, tipactivo=1, pkTipoperf=61, ticodigo=AD, tifechcrea=26 febrero 2009}
17:05:20,226 DEBUG org.hibernate.pretty.Printer,http-8083-Processor22:90 - xx.xxxxx.xxxxxx.model.SdxTipoperf{tidesc=Consulta comisión, tipactivo=1, pkTipoperf=44, ticodigo=CC, tifechcrea=24 febrero 2009}
17:05:20,226 DEBUG org.hibernate.pretty.Printer,http-8083-Processor22:90 - xx.xxxxx.xxxxxx.model.SdmAlerta{alconsulta=null, alfechcrea=02 marzo 2009, alobservac=Hibernate forum (updating), sdxTipoperfs=[xx.xxxxx.xxxxxx.model.SdxTipoperf#62, xx.xxxxx.xxxxxx.model.SdxTipoperf#61, xx.xxxxx.xxxxxx.model.SdxTipoperf#43, xx.xxxxx.xxxxxx.model.SdxTipoperf#44, xx.xxxxx.xxxxxx.model.SdxTipoperf#1], pkAlerta=241, alactivo=1, sdxUsuarios=[], alnombre=Hibernate forum}
17:05:20,226 DEBUG org.hibernate.event.def.AbstractFlushingEventListener,http-8083-Processor22:290 - executing flush
17:05:20,226 DEBUG org.hibernate.jdbc.ConnectionManager,http-8083-Processor22:469 - registering flush begin
17:05:20,226 DEBUG org.hibernate.persister.entity.AbstractEntityPersister,http-8083-Processor22:2344 - Updating entity: [xx.xxxxx.xxxxxx.model.SdmAlerta#241]
17:05:20,226 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor22:366 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
17:05:20,226 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor22:401 - update SDM_ALERTA set ALACTIVO=?, ALCONSULTA=?, ALFECHCREA=?, ALNOMBRE=?, ALOBSERVAC=? where PK_ALERTA=?
17:05:20,226 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor22:484 - preparing statement
17:05:20,226 DEBUG org.hibernate.persister.entity.AbstractEntityPersister,http-8083-Processor22:1997 - Dehydrating entity: [xx.xxxxx.xxxxxx.model.SdmAlerta#241]
17:05:20,226 DEBUG org.hibernate.type.NullableType,http-8083-Processor22:133 - binding '1' to parameter: 1
17:05:20,226 DEBUG org.hibernate.type.NullableType,http-8083-Processor22:133 - binding '02 marzo 2009' to parameter: 3
17:05:20,226 DEBUG org.hibernate.type.NullableType,http-8083-Processor22:133 - binding 'Hibernate forum' to parameter: 4
17:05:20,226 DEBUG org.hibernate.type.NullableType,http-8083-Processor22:133 - binding 'Hibernate forum (updating)' to parameter: 5
17:05:20,226 DEBUG org.hibernate.type.NullableType,http-8083-Processor22:133 - binding '241' to parameter: 6
17:05:20,226 DEBUG org.hibernate.jdbc.BatchingBatcher,http-8083-Processor22:44 - Executing batch size: 1
17:05:20,226 DEBUG org.hibernate.jdbc.Expectations$BasicExpectation,http-8083-Processor22:53 - success of batch update unknown: 0
17:05:20,226 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor22:374 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
17:05:20,226 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor22:533 - closing statement
17:05:20,226 DEBUG org.hibernate.jdbc.ConnectionManager,http-8083-Processor22:478 - registering flush end
17:05:20,226 DEBUG org.hibernate.event.def.AbstractFlushingEventListener,http-8083-Processor22:321 - post flush
17:05:20,226 DEBUG org.hibernate.jdbc.JDBCContext,http-8083-Processor22:205 - before transaction completion
17:05:20,241 DEBUG org.hibernate.impl.SessionImpl,http-8083-Processor22:393 - before transaction completion
17:05:20,241 DEBUG org.hibernate.transaction.JDBCTransaction,http-8083-Processor22:193 - re-enabling autocommit
17:05:20,241 DEBUG org.hibernate.transaction.JDBCTransaction,http-8083-Processor22:116 - committed JDBC Connection
17:05:20,241 DEBUG org.hibernate.jdbc.JDBCContext,http-8083-Processor22:219 - after transaction completion
17:05:20,241 DEBUG org.hibernate.jdbc.ConnectionManager,http-8083-Processor22:302 - transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
17:05:20,241 DEBUG org.hibernate.impl.SessionImpl,http-8083-Processor22:422 - after transaction completion
17:05:20,257 DEBUG org.hibernate.impl.SessionImpl,http-8083-Processor22:374 - disconnecting session
17:05:20,257 DEBUG org.hibernate.jdbc.ConnectionManager,http-8083-Processor22:380 - performing cleanup
17:05:20,257 DEBUG org.hibernate.jdbc.ConnectionManager,http-8083-Processor22:441 - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
17:05:20,257 DEBUG org.hibernate.jdbc.JDBCContext,http-8083-Processor22:219 - after transaction completion
17:05:20,257 DEBUG org.hibernate.jdbc.ConnectionManager,http-8083-Processor22:302 - transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
17:05:20,257 DEBUG org.hibernate.impl.SessionImpl,http-8083-Processor22:422 - after transaction completion
17:05:20,257 DEBUG org.hibernate.event.def.AbstractFlushingEventListener,http-8083-Processor22:58 - flushing session
17:05:20,257 DEBUG org.hibernate.event.def.AbstractFlushingEventListener,http-8083-Processor22:111 - processing flush-time cascades
17:05:20,257 DEBUG org.hibernate.event.def.AbstractFlushingEventListener,http-8083-Processor22:154 - dirty checking collections
17:05:20,257 DEBUG org.hibernate.event.def.AbstractFlushingEventListener,http-8083-Processor22:171 - Flushing entities and processing referenced collections
17:05:20,257 DEBUG org.hibernate.engine.Collections,http-8083-Processor22:176 - Collection found: [xx.xxxxx.xxxxxx.model.SdmAlerta.sdxUsuarios#241], was: [xx.xxxxx.xxxxxx.model.SdmAlerta.sdxUsuarios#241] (initialized)
17:05:20,257 DEBUG org.hibernate.engine.Collections,http-8083-Processor22:176 - Collection found: [xx.xxxxx.xxxxxx.model.SdmAlerta.sdxTipoperfs#241], was: [xx.xxxxx.xxxxxx.model.SdmAlerta.sdxTipoperfs#241] (initialized)
17:05:20,257 DEBUG org.hibernate.event.def.AbstractFlushingEventListener,http-8083-Processor22:210 - Processing unreferenced collections
17:05:20,257 DEBUG org.hibernate.event.def.AbstractFlushingEventListener,http-8083-Processor22:224 - Scheduling collection removes/(re)creates/updates
17:05:20,257 DEBUG org.hibernate.event.def.AbstractFlushingEventListener,http-8083-Processor22:85 - Flushed: 0 insertions, 0 updates, 0 deletions to 6 objects
17:05:20,257 DEBUG org.hibernate.event.def.AbstractFlushingEventListener,http-8083-Processor22:91 - Flushed: 0 (re)creations, 0 updates, 0 removals to 2 collections
17:05:20,257 DEBUG org.hibernate.pretty.Printer,http-8083-Processor22:83 - listing entities:
17:05:20,257 DEBUG org.hibernate.pretty.Printer,http-8083-Processor22:90 - xx.xxxxx.xxxxxx.model.SdxTipoperf{tidesc=Grabador, tipactivo=1, pkTipoperf=1, ticodigo=GR, tifechcrea=10 diciembre 2008}
17:05:20,257 DEBUG org.hibernate.pretty.Printer,http-8083-Processor22:90 - xx.xxxxx.xxxxxx.model.SdxTipoperf{tidesc=Comisión, tipactivo=1, pkTipoperf=43, ticodigo=CM, tifechcrea=24 febrero 2009}
17:05:20,257 DEBUG org.hibernate.pretty.Printer,http-8083-Processor22:90 - xx.xxxxx.xxxxxx.model.SdxTipoperf{tidesc=Valorador, tipactivo=1, pkTipoperf=62, ticodigo=VA, tifechcrea=26 febrero 2009}
17:05:20,257 DEBUG org.hibernate.pretty.Printer,http-8083-Processor22:90 - xx.xxxxx.xxxxxx.model.SdxTipoperf{tidesc=Administrativo, tipactivo=1, pkTipoperf=61, ticodigo=AD, tifechcrea=26 febrero 2009}
17:05:20,257 DEBUG org.hibernate.pretty.Printer,http-8083-Processor22:90 - xx.xxxxx.xxxxxx.model.SdxTipoperf{tidesc=Consulta comisión, tipactivo=1, pkTipoperf=44, ticodigo=CC, tifechcrea=24 febrero 2009}
17:05:20,257 DEBUG org.hibernate.pretty.Printer,http-8083-Processor22:90 - xx.xxxxx.xxxxxx.model.SdmAlerta{alconsulta=null, alfechcrea=02 marzo 2009, alobservac=Hibernate forum (updating), sdxTipoperfs=[xx.xxxxx.xxxxxx.model.SdxTipoperf#62, xx.xxxxx.xxxxxx.model.SdxTipoperf#61, xx.xxxxx.xxxxxx.model.SdxTipoperf#43, xx.xxxxx.xxxxxx.model.SdxTipoperf#44, xx.xxxxx.xxxxxx.model.SdxTipoperf#1], pkAlerta=241, alactivo=1, sdxUsuarios=[], alnombre=Hibernate forum}
17:05:20,257 DEBUG org.hibernate.event.def.AbstractFlushingEventListener,http-8083-Processor22:290 - executing flush
17:05:20,257 DEBUG org.hibernate.jdbc.ConnectionManager,http-8083-Processor22:469 - registering flush begin
17:05:20,257 DEBUG org.hibernate.jdbc.ConnectionManager,http-8083-Processor22:478 - registering flush end
17:05:20,257 DEBUG org.hibernate.event.def.AbstractFlushingEventListener,http-8083-Processor22:321 - post flush
17:05:20,257 DEBUG org.hibernate.impl.SessionImpl,http-8083-Processor22:273 - closing session
17:05:20,257 DEBUG org.hibernate.jdbc.ConnectionManager,http-8083-Processor22:375 - connection already null in cleanup : no action
17:05:20,351 DEBUG org.hibernate.impl.SessionImpl,http-8083-Processor22:220 - opened session at timestamp: 12360099203
17:05:20,351 DEBUG org.hibernate.impl.SessionImpl,http-8083-Processor22:273 - closing session
17:05:20,351 DEBUG org.hibernate.jdbc.ConnectionManager,http-8083-Processor22:375 - connection already null in cleanup : no action
17:05:20,351 DEBUG org.hibernate.impl.SessionImpl,http-8083-Processor22:220 - opened session at timestamp: 12360099203
17:05:20,351 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor22:366 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
17:05:20,351 DEBUG org.hibernate.jdbc.ConnectionManager,http-8083-Processor22:421 - opening JDBC connection
17:05:20,351 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor22:401 - select this_.PK_ALERTA as PK1_35_1_, this_.ALACTIVO as ALACTIVO35_1_, this_.ALCONSULTA as ALCONSULTA35_1_, this_.ALFECHCREA as ALFECHCREA35_1_, this_.ALNOMBRE as ALNOMBRE35_1_, this_.ALOBSERVAC as ALOBSERVAC35_1_, sdxtipoper2_.PK_ALERTA as PK1_3_, sdxtipoper3_.PK_TIPOPERF as PK2_3_, sdxtipoper3_.PK_TIPOPERF as PK1_29_0_, sdxtipoper3_.TICODIGO as TICODIGO29_0_, sdxtipoper3_.TIDESC as TIDESC29_0_, sdxtipoper3_.TIFECHCREA as TIFECHCREA29_0_, sdxtipoper3_.TIPACTIVO as TIPACTIVO29_0_ from SDM_ALERTA this_, SDM_ALPRPERF sdxtipoper2_, SDX_TIPOPERF sdxtipoper3_ where this_.PK_ALERTA=sdxtipoper2_.PK_ALERTA(+) and sdxtipoper2_.PK_TIPOPERF=sdxtipoper3_.PK_TIPOPERF(+) and (1=1)
17:05:20,351 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor22:484 - preparing statement
17:05:20,351 DEBUG org.hibernate.jdbc.AbstractBatcher,http-8083-Processor22:382 - about to open ResultSet (open ResultSets: 0, globally: 0)
Code:
@Override
public AbstractEntity save(AbstractEntity ae) {
SdmAlerta sdmAlerta = (SdmAlerta)ae;
return this.getSession().save(sdmAlerta);
}
@Override
public AbstractEntity update(AbstractEntity ae) {
SdmAlerta sdmAlerta = (SdmAlerta)ae;
return this.getSession().merge(sdmAlerta);
}