HIbernate Criteria.list hanging

MyEclipse Archived

Database Tools (DB Explorer, Hibernate, etc.)

This topic has 3 replies, 1 voice, and was last updated 16 years, 5 months ago by davout.

Viewing 4 posts - 1 through 4 (of 4 total)

Author

Posts

December 2, 2008 at 12:37 pm #291524 Reply

davout

Participant

I have a DAO tier implementation that is using Hibernate and the Criteria object to bring back pages of data.

The underlying database is MySQL 5 and the table has 91 records. Each Criteria query is retrieving 12 records/objects in one call.

In the front end GUI the data is displayed in a grid. I click ‘next page’ to retrieve the next block of 12 records. On the fourth time I select ‘next page’ the call to Criteria.list() just hangs. This call should be returning records 48 to 59 in the table.

Any ideas on how to trace this issue?

Here’s a code extract from the DAO class…


   public ServiceEntryBlock searchByTitle(SearchEntryBlockParameters aParams, String aTitleMask) throws PersistenceException {
      
      SearchEntryBlockParameters.validate(aParams);
      
      ServiceEntryBlock aBlock = new ServiceEntryBlock();
      
      Criteria aMain = this.getSession().createCriteria(ServiceEntry.class);
      Criteria aCount = this.getSession().createCriteria(ServiceEntry.class);
      aMain.addOrder(Order.asc(SERVICE_ENTRY_TITLE));
      if (aTitleMask != null) {
         aMain.add(Restrictions.ilike(SERVICE_ENTRY_TITLE,aTitleMask));
         aCount.add(Restrictions.ilike(SERVICE_ENTRY_TITLE,aTitleMask));
      }
      if (aParams.isPublishedAny() == false) {
         boolean aValue = (aParams.isPublishedOnly() == true);
         aMain.add(Restrictions.eq(SERVICE_ENTRY_PUBLISHED,aValue));
         aCount.add(Restrictions.eq(SERVICE_ENTRY_PUBLISHED,aValue));
      }
      aMain.setFirstResult(aParams.getStart());
      aMain.setMaxResults(aParams.getMaxNumber());
      try {
         List<ServiceEntry> aList = aMain.list();  <=== HANGS HERE !
         ServiceEntry[] anArray = toArray(aList); 
         aBlock.setData(anArray);
         if (aParams.isFindTotalNumber() == true) {
            aCount.setProjection(Projections.rowCount());
            aBlock.setTotalNumber( ((Integer)aCount.list().get(0)).intValue());
         }
         else {
            aBlock.setTotalNumber(AppUserBlock.TOTAL_NUMBER_NA);
         }
         
      }
      catch (RuntimeException re) {
         throw new PersistenceException(MODULE_NAME,DB_ERROR,"Persistence error on searchByTitle",re);
      }
      return aBlock;
   }

December 2, 2008 at 12:39 pm #291525 Reply

davout

Participant

Forgot to mention … this is Hibernate r3.2

December 2, 2008 at 1:04 pm #291528 Reply

davout

Participant

Here’s the debug output from the fourth call to aMain.list() …


DEBUG: 18:49:23: org.hibernate.impl.SessionImpl: opened session at timestamp: 12282437636
DEBUG: 18:49:23: org.hibernate.impl.SessionImpl: opened session at timestamp: 12282437636
DEBUG: 18:49:34: org.hibernate.jdbc.AbstractBatcher: about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
DEBUG: 18:49:34: org.hibernate.jdbc.ConnectionManager: opening JDBC connection

Here’s all the log file output …


DEBUG: 18:48:15: org.hibernate.jdbc.AbstractBatcher: closing statement
DEBUG: 18:48:15: org.hibernate.loader.Loader: total objects hydrated: 12
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#4]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#4]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#4]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#4]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#5]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#5]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#5]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#5]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#6]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#6]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#6]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#6]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#7]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#7]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#7]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#7]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#8]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#8]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#8]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#8]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#9]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#9]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#9]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#9]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#10]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#10]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#10]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#10]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#11]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#11]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#11]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#11]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#12]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#12]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#12]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#12]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#13]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#13]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#13]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#13]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#14]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#14]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#14]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#14]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#15]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#15]
DEBUG: 18:48:15: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#15]
DEBUG: 18:48:15: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#15]
DEBUG: 18:48:15: org.hibernate.engine.StatefulPersistenceContext: initializing non-lazy collections
DEBUG: 18:48:15: org.hibernate.jdbc.JDBCContext: after autocommit
DEBUG: 18:48:15: org.hibernate.jdbc.ConnectionManager: transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
DEBUG: 18:48:15: org.hibernate.impl.SessionImpl: after transaction completion
DEBUG: 18:48:15: org.hibernate.jdbc.AbstractBatcher: about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
DEBUG: 18:48:15: org.hibernate.jdbc.ConnectionManager: opening JDBC connection
DEBUG: 18:48:15: org.hibernate.jdbc.AbstractBatcher: select count(*) as y0_ from service_entry this_
DEBUG: 18:48:15: org.hibernate.jdbc.AbstractBatcher: preparing statement
DEBUG: 18:48:15: org.hibernate.jdbc.AbstractBatcher: about to open ResultSet (open ResultSets: 0, globally: 0)
DEBUG: 18:48:15: org.hibernate.loader.Loader: processing result set
DEBUG: 18:48:15: org.hibernate.loader.Loader: result set row: 0
DEBUG: 18:48:15: org.hibernate.loader.Loader: result row: 
DEBUG: 18:48:15: org.hibernate.type.NullableType: returning '91' as column: y0_
DEBUG: 18:48:15: org.hibernate.loader.Loader: done processing result set (1 rows)
DEBUG: 18:48:15: org.hibernate.jdbc.AbstractBatcher: about to close ResultSet (open ResultSets: 1, globally: 1)
DEBUG: 18:48:15: org.hibernate.jdbc.AbstractBatcher: about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
DEBUG: 18:48:15: org.hibernate.jdbc.AbstractBatcher: closing statement
DEBUG: 18:48:15: org.hibernate.engine.StatefulPersistenceContext: initializing non-lazy collections
DEBUG: 18:48:15: org.hibernate.jdbc.JDBCContext: after autocommit
DEBUG: 18:48:15: org.hibernate.jdbc.ConnectionManager: transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
DEBUG: 18:48:15: org.hibernate.impl.SessionImpl: after transaction completion
DEBUG: 18:48:40: org.hibernate.impl.SessionImpl: opened session at timestamp: 12282437209
DEBUG: 18:48:40: org.hibernate.impl.SessionImpl: opened session at timestamp: 12282437209
DEBUG: 18:48:49: org.hibernate.jdbc.AbstractBatcher: about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
DEBUG: 18:48:49: org.hibernate.jdbc.ConnectionManager: opening JDBC connection
DEBUG: 18:48:49: org.hibernate.jdbc.AbstractBatcher: select this_.ServiceEntryIntID as ServiceE1_1_0_, this_.ServiceEntryVersion as ServiceE2_1_0_, this_.ServiceEntryTitle as ServiceE3_1_0_, this_.ServiceEntryAlias as ServiceE4_1_0_, this_.ServiceEntryShortDesc as ServiceE5_1_0_, this_.ServiceEntryLongDesc as ServiceE6_1_0_, this_.ServiceEntryDisabled as ServiceE7_1_0_, this_.ServiceEntryPublished as ServiceE8_1_0_, this_.ServiceEntryPublicOwnership as ServiceE9_1_0_, this_.ServiceEntryCreated as Service10_1_0_ from service_entry this_ order by this_.ServiceEntryTitle asc limit ?, ?
DEBUG: 18:48:49: org.hibernate.jdbc.AbstractBatcher: preparing statement
DEBUG: 18:48:49: org.hibernate.jdbc.AbstractBatcher: about to open ResultSet (open ResultSets: 0, globally: 0)
DEBUG: 18:48:49: org.hibernate.loader.Loader: processing result set
DEBUG: 18:48:49: org.hibernate.loader.Loader: result set row: 0
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '83' as column: ServiceE1_1_0_
DEBUG: 18:48:49: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#83]
DEBUG: 18:48:49: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#83]
DEBUG: 18:48:49: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#83]
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Conference facilities' as column: ServiceE3_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Conference facilities' as column: ServiceE4_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Conference facilities' as column: ServiceE5_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:48:49: org.hibernate.loader.Loader: result set row: 1
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '18' as column: ServiceE1_1_0_
DEBUG: 18:48:49: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#18]
DEBUG: 18:48:49: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#18]
DEBUG: 18:48:49: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#18]
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Courier services' as column: ServiceE3_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Courier services' as column: ServiceE4_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Courier services' as column: ServiceE5_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:48:49: org.hibernate.loader.Loader: result set row: 2
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '16' as column: ServiceE1_1_0_
DEBUG: 18:48:49: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#16]
DEBUG: 18:48:49: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#16]
DEBUG: 18:48:49: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#16]
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Data recovery' as column: ServiceE3_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Data recovery' as column: ServiceE4_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Data recovery' as column: ServiceE5_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:48:49: org.hibernate.loader.Loader: result set row: 3
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '17' as column: ServiceE1_1_0_
DEBUG: 18:48:49: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#17]
DEBUG: 18:48:49: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#17]
DEBUG: 18:48:49: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#17]
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Deliveries' as column: ServiceE3_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Deliveries' as column: ServiceE4_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Deliveries' as column: ServiceE5_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:48:49: org.hibernate.loader.Loader: result set row: 4
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '19' as column: ServiceE1_1_0_
DEBUG: 18:48:49: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#19]
DEBUG: 18:48:49: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#19]
DEBUG: 18:48:49: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#19]
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Design services' as column: ServiceE3_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Design services' as column: ServiceE4_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Design services' as column: ServiceE5_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:48:49: org.hibernate.loader.Loader: result set row: 5
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '20' as column: ServiceE1_1_0_
DEBUG: 18:48:49: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#20]
DEBUG: 18:48:49: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#20]
DEBUG: 18:48:49: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#20]
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Direct mail' as column: ServiceE3_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Direct mail' as column: ServiceE4_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Direct mail' as column: ServiceE5_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:48:49: org.hibernate.loader.Loader: result set row: 6
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '21' as column: ServiceE1_1_0_
DEBUG: 18:48:49: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#21]
DEBUG: 18:48:49: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#21]
DEBUG: 18:48:49: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#21]
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Education services' as column: ServiceE3_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Education services' as column: ServiceE4_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Education services' as column: ServiceE5_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:48:49: org.hibernate.loader.Loader: result set row: 7
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '22' as column: ServiceE1_1_0_
DEBUG: 18:48:49: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#22]
DEBUG: 18:48:49: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#22]
DEBUG: 18:48:49: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#22]
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Electrical repairs' as column: ServiceE3_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Electrical repairs' as column: ServiceE4_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Electrical repairs' as column: ServiceE5_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:48:49: org.hibernate.loader.Loader: result set row: 8
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '88' as column: ServiceE1_1_0_
DEBUG: 18:48:49: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#88]
DEBUG: 18:48:49: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#88]
DEBUG: 18:48:49: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#88]
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Email support' as column: ServiceE3_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Email support' as column: ServiceE4_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Email support' as column: ServiceE5_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:48:49: org.hibernate.loader.Loader: result set row: 9
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '23' as column: ServiceE1_1_0_
DEBUG: 18:48:49: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#23]
DEBUG: 18:48:49: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#23]
DEBUG: 18:48:49: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#23]
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Emergency services' as column: ServiceE3_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Emergency services' as column: ServiceE4_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Emergency services' as column: ServiceE5_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:48:49: org.hibernate.loader.Loader: result set row: 10
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '37' as column: ServiceE1_1_0_
DEBUG: 18:48:49: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#37]
DEBUG: 18:48:49: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#37]
DEBUG: 18:48:49: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#37]
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Equipment hire' as column: ServiceE3_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Equipment hire' as column: ServiceE4_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Equipment hire' as column: ServiceE5_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:48:49: org.hibernate.loader.Loader: result set row: 11
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '24' as column: ServiceE1_1_0_
DEBUG: 18:48:49: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#24]
DEBUG: 18:48:49: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#24]
DEBUG: 18:48:49: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#24]
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Estate agents' as column: ServiceE3_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Estate agents' as column: ServiceE4_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'Estate agents' as column: ServiceE5_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:48:49: org.hibernate.loader.Loader: done processing result set (12 rows)
DEBUG: 18:48:49: org.hibernate.jdbc.AbstractBatcher: about to close ResultSet (open ResultSets: 1, globally: 1)
DEBUG: 18:48:49: org.hibernate.jdbc.AbstractBatcher: about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
DEBUG: 18:48:49: org.hibernate.jdbc.AbstractBatcher: closing statement
DEBUG: 18:48:49: org.hibernate.loader.Loader: total objects hydrated: 12
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#83]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#83]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#83]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#83]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#18]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#18]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#18]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#18]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#16]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#16]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#16]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#16]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#17]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#17]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#17]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#17]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#19]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#19]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#19]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#19]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#20]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#20]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#20]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#20]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#21]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#21]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#21]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#21]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#22]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#22]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#22]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#22]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#88]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#88]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#88]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#88]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#23]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#23]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#23]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#23]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#37]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#37]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#37]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#37]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: resolving associations for [com.eis.service.definition.ServiceEntry#24]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.alternativeTitles#24]
DEBUG: 18:48:49: org.hibernate.engine.loading.LoadContexts: creating collection wrapper:[com.eis.service.definition.ServiceEntry.keywords#24]
DEBUG: 18:48:49: org.hibernate.engine.TwoPhaseLoad: done materializing entity [com.eis.service.definition.ServiceEntry#24]
DEBUG: 18:48:49: org.hibernate.engine.StatefulPersistenceContext: initializing non-lazy collections
DEBUG: 18:48:49: org.hibernate.jdbc.JDBCContext: after autocommit
DEBUG: 18:48:49: org.hibernate.jdbc.ConnectionManager: transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
DEBUG: 18:48:49: org.hibernate.impl.SessionImpl: after transaction completion
DEBUG: 18:48:49: org.hibernate.jdbc.AbstractBatcher: about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
DEBUG: 18:48:49: org.hibernate.jdbc.ConnectionManager: opening JDBC connection
DEBUG: 18:48:49: org.hibernate.jdbc.AbstractBatcher: select count(*) as y0_ from service_entry this_
DEBUG: 18:48:49: org.hibernate.jdbc.AbstractBatcher: preparing statement
DEBUG: 18:48:49: org.hibernate.jdbc.AbstractBatcher: about to open ResultSet (open ResultSets: 0, globally: 0)
DEBUG: 18:48:49: org.hibernate.loader.Loader: processing result set
DEBUG: 18:48:49: org.hibernate.loader.Loader: result set row: 0
DEBUG: 18:48:49: org.hibernate.loader.Loader: result row: 
DEBUG: 18:48:49: org.hibernate.type.NullableType: returning '91' as column: y0_
DEBUG: 18:48:49: org.hibernate.loader.Loader: done processing result set (1 rows)
DEBUG: 18:48:49: org.hibernate.jdbc.AbstractBatcher: about to close ResultSet (open ResultSets: 1, globally: 1)
DEBUG: 18:48:49: org.hibernate.jdbc.AbstractBatcher: about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
DEBUG: 18:48:49: org.hibernate.jdbc.AbstractBatcher: closing statement
DEBUG: 18:48:49: org.hibernate.engine.StatefulPersistenceContext: initializing non-lazy collections
DEBUG: 18:48:49: org.hibernate.jdbc.JDBCContext: after autocommit
DEBUG: 18:48:49: org.hibernate.jdbc.ConnectionManager: transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
DEBUG: 18:48:49: org.hibernate.impl.SessionImpl: after transaction completion
DEBUG: 18:48:56: org.hibernate.impl.SessionImpl: opened session at timestamp: 12282437368
DEBUG: 18:48:56: org.hibernate.impl.SessionImpl: opened session at timestamp: 12282437368
DEBUG: 18:49:12: org.hibernate.jdbc.AbstractBatcher: about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
DEBUG: 18:49:12: org.hibernate.jdbc.ConnectionManager: opening JDBC connection
DEBUG: 18:49:12: org.hibernate.jdbc.AbstractBatcher: select this_.ServiceEntryIntID as ServiceE1_1_0_, this_.ServiceEntryVersion as ServiceE2_1_0_, this_.ServiceEntryTitle as ServiceE3_1_0_, this_.ServiceEntryAlias as ServiceE4_1_0_, this_.ServiceEntryShortDesc as ServiceE5_1_0_, this_.ServiceEntryLongDesc as ServiceE6_1_0_, this_.ServiceEntryDisabled as ServiceE7_1_0_, this_.ServiceEntryPublished as ServiceE8_1_0_, this_.ServiceEntryPublicOwnership as ServiceE9_1_0_, this_.ServiceEntryCreated as Service10_1_0_ from service_entry this_ order by this_.ServiceEntryTitle asc limit ?, ?
DEBUG: 18:49:12: org.hibernate.jdbc.AbstractBatcher: preparing statement
DEBUG: 18:49:12: org.hibernate.jdbc.AbstractBatcher: about to open ResultSet (open ResultSets: 0, globally: 0)
DEBUG: 18:49:12: org.hibernate.loader.Loader: processing result set
DEBUG: 18:49:12: org.hibernate.loader.Loader: result set row: 0
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '1' as column: ServiceE1_1_0_
DEBUG: 18:49:12: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#1]
DEBUG: 18:49:12: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#1]
DEBUG: 18:49:12: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#1]
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Expense claims' as column: ServiceE3_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'expenses' as column: ServiceE4_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Web based system for automated submission, review and approval of expense claims' as column: ServiceE5_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:49:12: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:49:12: org.hibernate.loader.Loader: result set row: 1
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '25' as column: ServiceE1_1_0_
DEBUG: 18:49:12: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#25]
DEBUG: 18:49:12: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#25]
DEBUG: 18:49:12: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#25]
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Facilities management' as column: ServiceE3_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Facilities management' as column: ServiceE4_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Facilities management' as column: ServiceE5_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:49:12: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:49:12: org.hibernate.loader.Loader: result set row: 2
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '26' as column: ServiceE1_1_0_
DEBUG: 18:49:12: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#26]
DEBUG: 18:49:12: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#26]
DEBUG: 18:49:12: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#26]
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Fancy dress' as column: ServiceE3_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Fancy dress' as column: ServiceE4_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Fancy dress' as column: ServiceE5_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:49:12: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:49:12: org.hibernate.loader.Loader: result set row: 3
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '27' as column: ServiceE1_1_0_
DEBUG: 18:49:12: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#27]
DEBUG: 18:49:12: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#27]
DEBUG: 18:49:12: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#27]
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Flights' as column: ServiceE3_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Flights' as column: ServiceE4_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Flights' as column: ServiceE5_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:49:12: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:49:12: org.hibernate.loader.Loader: result set row: 4
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '29' as column: ServiceE1_1_0_
DEBUG: 18:49:12: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#29]
DEBUG: 18:49:12: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#29]
DEBUG: 18:49:12: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#29]
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Freephone facilities' as column: ServiceE3_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Freephone facilities' as column: ServiceE4_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Freephone facilities' as column: ServiceE5_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:49:12: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:49:12: org.hibernate.loader.Loader: result set row: 5
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '30' as column: ServiceE1_1_0_
DEBUG: 18:49:12: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#30]
DEBUG: 18:49:12: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#30]
DEBUG: 18:49:12: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#30]
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Garage services' as column: ServiceE3_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Garage services' as column: ServiceE4_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Garage services' as column: ServiceE5_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:49:12: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:49:12: org.hibernate.loader.Loader: result set row: 6
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '31' as column: ServiceE1_1_0_
DEBUG: 18:49:12: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#31]
DEBUG: 18:49:12: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#31]
DEBUG: 18:49:12: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#31]
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Graphic artists' as column: ServiceE3_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Graphic artists' as column: ServiceE4_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Graphic artists' as column: ServiceE5_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:49:12: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:49:12: org.hibernate.loader.Loader: result set row: 7
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '33' as column: ServiceE1_1_0_
DEBUG: 18:49:12: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#33]
DEBUG: 18:49:12: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#33]
DEBUG: 18:49:12: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#33]
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Guards' as column: ServiceE3_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Guards' as column: ServiceE4_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Guards' as column: ServiceE5_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:49:12: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:49:12: org.hibernate.loader.Loader: result set row: 8
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '32' as column: ServiceE1_1_0_
DEBUG: 18:49:12: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#32]
DEBUG: 18:49:12: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#32]
DEBUG: 18:49:12: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#32]
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Gym services' as column: ServiceE3_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Gym services' as column: ServiceE4_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Gym services' as column: ServiceE5_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: ServiceE6_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'false' as column: ServiceE7_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE8_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'true' as column: ServiceE9_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning null as column: Service10_1_0_
DEBUG: 18:49:12: org.hibernate.engine.TwoPhaseLoad: Version: 0
DEBUG: 18:49:12: org.hibernate.loader.Loader: result set row: 9
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '34' as column: ServiceE1_1_0_
DEBUG: 18:49:12: org.hibernate.loader.Loader: result row: EntityKey[com.eis.service.definition.ServiceEntry#34]
DEBUG: 18:49:12: org.hibernate.loader.Loader: Initializing object from ResultSet: [com.eis.service.definition.ServiceEntry#34]
DEBUG: 18:49:12: org.hibernate.persister.entity.AbstractEntityPersister: Hydrating entity: [com.eis.service.definition.ServiceEntry#34]
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning '0' as column: ServiceE2_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Hampers' as column: ServiceE3_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Hampers' as column: ServiceE4_1_0_
DEBUG: 18:49:12: org.hibernate.type.NullableType: returning 'Hampers' as column: ServiceE5_1_0_
DEBUG: 18:49:12: org.hibernate.t

December 2, 2008 at 2:43 pm #291530 Reply

davout

Participant

Solved it….

I needed to add code to the end of method to free up the sessions employed…. hence…


      finally {
         SessionFactoryUtils.releaseSession(aSession, this.getSessionFactory());
      }
/code]

Author

Posts

Viewing 4 posts - 1 through 4 (of 4 total)