activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Franz Garsombke <fgarsom...@yahoo.com>
Subject Error resetting JDBC transaction isolation on Active MQ 4.1.0/JBoss 4.0.4.GA/Oracle 10g
Date Fri, 06 Apr 2007 17:01:24 GMT

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.


Mime
View raw message