I am trying to use a JBoss JNDI datasource with my ActiveMQ broker config file. I am receiving this error:
[exec] 2007-04-06 10:36:24,272 WARN Error resetting transaction isolation [exec] java.sql.SQLException: READ_COMMITTED and SERIALIZABLE are the only valid transaction levels I was able to successfully use a org.apache.commons.dbcp.BasicDataSource but wanted to switch over to a JBoss JNDI datasource. broker-config.xml: <bean id="jmsDS" class="org.springframework.jndi.JndiObjectFactoryBean"> <property name="jndiName" value="java:/OracleDS1"> </property> </bean> JBoss Datasource: <datasources> <local-tx-datasource> <jndi-name>OracleDS1</jndi-name> <connection-url>jdbc:oracle:thin:${jdbc.service.name}</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <user-name>${jdbc.username}</user-name> <password>${jdbc.password}</password> <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool --> <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name> <!-- Checks the Oracle error codes and messages for fatal errors --> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> <check-valid-connection-sql>select one from DUAL;</check-valid-connection-sql> <min-pool-size>0</min-pool-size> <!-- sql to call when connection is created <new-connection-sql>some arbitrary sql</new-connection-sql> --> <!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql> --> <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> <metadata> <type-mapping>Oracle9i</type-mapping> </metadata> </local-tx-datasource> </datasources> Error in Log File: [exec] 2007-04-06 10:36:24,168 INFO ActiveMQ 4.1.0-incubator JMS Message Broker (localhost) is starting [exec] 2007-04-06 10:36:24,171 INFO For help or more information please see: http://incubator.apache.org/activemq/ [exec] 2007-04-06 10:36:24,269 INFO Database driver recognized: [oracle_jdbc_driver] [exec] 2007-04-06 10:36:24,272 WARN Error resetting transaction isolation [exec] java.sql.SQLException: READ_COMMITTED and SERIALIZABLE are the only valid transaction levels [exec] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [exec] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) [exec] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) [exec] at oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:1608) [exec] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.cleanup(BaseWrapperManagedConnection.java:189) [exec] at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnConnection(InternalManagedConnectionPool.java:297) [exec] at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.returnConnection(JBossManagedConnectionPool.java:499) [exec] at org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedConnection(BaseConnectionManager2.java:346) [exec] at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionClosed(TxConnectionManager.java:623) [exec] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.closeHandle(BaseWrapperManagedConnection.java:266) [exec] at org.jboss.resource.adapter.jdbc.WrappedConnection.close(WrappedConnection.java:129) [exec] at org.apache.activemq.store.jdbc.TransactionContext.close(TransactionContext.java:132) [exec] at org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.createAdapter(JDBCPersistenceAdapter.java:321) [exec] at org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getAdapter(JDBCPersistenceAdapter.java:251) [exec] at org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.start(JDBCPersistenceAdapter.java:152) [exec] at org.apache.activemq.store.journal.JournalPersistenceAdapter.start(JournalPersistenceAdapter.java:223) [exec] at org.apache.activemq.broker.BrokerService.createRegionBroker(BrokerService.java:1251) [exec] at org.apache.activemq.broker.BrokerService.createBroker(BrokerService.java:1209) [exec] at org.apache.activemq.broker.BrokerService.getBroker(BrokerService.java:508) [exec] at org.apache.activemq.broker.BrokerService.start(BrokerService.java:394) [exec] at org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrokerService.java:47) [exec] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1143) [exec] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1110) [exec] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:431) [exec] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:254) [exec] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:144) [exec] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:251) [exec] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:163) [exec] at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:284) [exec] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352) [exec] at org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:88) [exec] at org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:76) [exec] at org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:72) [exec] at org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:68) [exec] at org.apache.activemq.xbean.BrokerFactoryBean.afterPropertiesSet(BrokerFactoryBean.java:84) [exec] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1143) Thanks in advance. Franz Garsombke -- View this message in context: http://www.nabble.com/Error-resetting-JDBC-transaction-isolation-on-Active-MQ-4.1.0-JBoss-4.0.4.GA-Oracle-10g-tf3537760s2354.html#a9875151 Sent from the ActiveMQ - User mailing list archive at Nabble.com.