My purpose of doing persistence of message in database to store durable message. Can you suggest how can i do it without using persistence adaptor if you said ActiveMQ broker is not meant to use the JBoss transaction interceptors ....
My Idea can i configure it in activemq-ds.xml to create table and store durable message in oracle database . previusly when i used JbossMQ , i have created it in JMS/jdbc-state2.xml... Thanks, Arabinda James.Strachan wrote: > > 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/ > > -- View this message in context: http://www.nabble.com/Issues-with-Persistence-tf3680309s2354.html#a10292127 Sent from the ActiveMQ - Dev mailing list archive at Nabble.com.
