Hibernate Community • View topic - Criteria.list() hanging

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Criteria.list() hanging

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

davout_uk

Post subject: Criteria.list() hanging

Posted: Tue Dec 02, 2008 4:16 pm

Regular

Joined: Tue Apr 10, 2007 10:02 am
Posts: 56

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...

Code:

   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;
   }

Here's the log file extract for the fourth call...

Code:

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

Finally.... her's the log file output for all four Criteria calls...
[code]
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

Top

davout_uk

Post subject:

Posted: Tue Dec 02, 2008 4:50 pm

Regular

Joined: Tue Apr 10, 2007 10:02 am
Posts: 56

Solved it...

I needed to add code to the end of method that releases any sessions employed, like...

Code:

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

Top

Page 1 of 1

[ 2 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