I get the following error in development but works in local server. Any ideas?
[org.springframework.orm.hibernate3.LocalSessionFactoryBean] (Timer-1) Building new Hibernate SessionFactory
2010-10-11 09:09:57,198 INFO [org.hibernate.connection.ConnectionProviderFactory] (Timer-1) Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
2010-10-11 09:09:57,201 WARN [org.hibernate.util.JDBCExceptionReporter] (Timer-1) SQL Error: 0, SQLState: null
2010-10-11 09:09:57,202 ERROR [org.hibernate.util.JDBCExceptionReporter] (Timer-1) Transaction is not active: tx=TransactionImple < ac, BasicAction: a1d1b9e:b200:4cb30479:1b9 status: ActionStatus.ABORTED >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a1d1b9e:b200:4cb30479:1b9 status: ActionStatus.ABORTED >)
A transaction can get aborted if you're exitting an ejb method through an exception. If you catch this exception outside the ejb-call, and proceed by calling another ejb that also tries to access the db, you'll get this, because eventhough you caught the exception, you caught it outside the ejb, therefore the transaction is aborted.