Ah it looks like your JBoss managed DataSource is not letting ActiveMQ use the DataSource as it wishes.
So either use a regular DataSource for ActiveMQ - or run the broker outside of JBoss. (The ActiveMQ broker is not meant to use the JBoss transaction interceptors or share transaction contexts with EJBs etc - its usually a stand alone service). On 5/2/07, James Strachan <[EMAIL PROTECTED]> 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/
-- James ------- http://macstrac.blogspot.com/
