I am using ActiveMQ 4.1.1 also tried with 4.0.1 as ra , Database i am using is Oracle 10 g as my Datasource is JNDI which i have define in nu-ds.xml as with JNDI NAme nuBridgesDB.
James.Strachan wrote: > > which version of ActiveMQ are you using & which database are you > connecting to? > > On 5/2/07, Arabinda <[EMAIL PROTECTED]> wrote: >> >> I got error with Persistence in datasource as JNDI. >> I have the broker-configuration as >> >> <persistenceAdapter> >> <!-- <journaledJDBC journalLogFiles="5" >> dataDirectory="activemq-data"/> --> >> <!-- To use a different datasource, use th following syntax : --> >> <!-- >> <journaledJDBC journalLogFiles="5" dataDirectory="../data" >> dataSource="#postgres-ds"/>--> >> >> <jdbcPersistenceAdapter dataSource="#oracle-ds"/> >> >> </persistenceAdapter> >> >> <bean id="oracle-ds" >> class="org.springframework.jndi.JndiObjectFactoryBean"> >> <property name="jndiName" value="java:nuBridgesDB"> >> </property> >> </bean> >> >> I got the ERROR like : >> >> 07:03:33,982 WARN [LocalManagedConnectionFactory] Error resetting >> transaction isolation >> java.sql.SQLException: READ_COMMITTED and SERIALIZABLE are the only valid >> transaction levels >> at >> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) >> at >> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) >> at >> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) >> at >> oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnec >> tion.java:1608) >> at >> org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.cleanup(BaseWra >> pperManagedConnection.java:208) >> at >> org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnCon >> nection(InternalManagedConnectionPool.java:277) >> >> >> When i have comment the Persitence part , my application runs smoothly. >> >> I am using jboss as APServer. >> >> Please reply , as i am waiting eagerly . >> >> Thanks, >> Arabinda >> >> >> -- >> View this message in context: >> http://www.nabble.com/Issues-with-Persistence-tf3680309s2354.html#a10285094 >> Sent from the ActiveMQ - Dev mailing list archive at Nabble.com. >> >> > > > -- > James > ------- > http://macstrac.blogspot.com/ > > -- View this message in context: http://www.nabble.com/Issues-with-Persistence-tf3680309s2354.html#a10286859 Sent from the ActiveMQ - Dev mailing list archive at Nabble.com.
