5 Replies Latest reply on Sep 17, 2007 5:09 AM by Kevin Conner

    Cannot change transaction isolation level in the middle of a

    Daniel Bevenius Master

      Hi,

      we are getting this message when there are several messages in the message store with the same classification:

      2007-09-14 10:08:05,376 DEBUG [org.jboss.internal.soa.esb.persistence.format.db.DBMessageStoreImpl] Deadlocks may occur under normal processing
      2007-09-14 10:08:05,376 DEBUG [org.jboss.internal.soa.esb.persistence.format.db.DBMessageStoreImpl] Cannot change transaction isolation level in the middle of a transaction.
      org.postgresql.util.PSQLException: Cannot change transaction isolation level in the middle of a transaction.
       at org.postgresql.jdbc2.AbstractJdbc2Connection.setTransactionIsolation(AbstractJdbc2Connection.java:733)
       at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.setJdbcTransactionIsolation(BaseWrapperManagedConnection.java:534)
       at org.jboss.resource.adapter.jdbc.WrappedConnection.setTransactionIsolation(WrappedConnection.java:390)
       at org.jboss.internal.soa.esb.persistence.format.db.DBMessageStoreImpl.redeliver(DBMessageStoreImpl.java:318)
       at org.jboss.soa.esb.actions.MessageRedeliverer.process(MessageRedeliverer.java:74)
       at org.jboss.soa.esb.listeners.message.ActionProcessingPipeline.process(ActionProcessingPipeline.java:265)
       at org.jboss.soa.esb.listeners.ScheduleListener.onSchedule(ScheduleListener.java:108)
       at org.jboss.soa.esb.schedule.ScheduleProvider$ESBScheduledJob.execute(ScheduleProvider.java:212)
       at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      


      As you can probably see the database we are using is postgres.
      Has anyone seen this before?

      Thanks,

      Daniel