You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@activemq.apache.org by Franz Garsombke <fg...@yahoo.com> on 2007/04/06 19:01:24 UTC
Error resetting JDBC transaction isolation on Active MQ 4.1.0/JBoss
4.0.4.GA/Oracle 10g
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.