I gorgot to attach my activemq-broker.xml in my last post. Here it is.
gnanda wrote: > > Hi All, > I am trying to configure activemq with databse persistence as oracle. > I have setup following in my activemq-broker.xml file > > <persistenceAdapter> > <jdbcPersistenceAdapter dataSource="#oracle-ds"/> > </persistenceAdapter> > > <bean id="oracle-ds" class="org.apache.commons.dbcp.BasicDataSource" > destroy-method="close"> > > <property name="driverClassName" > value="oracle.jdbc.driver.OracleDriver"/> > <property name="url" > value="jdbc:oracle:thin:@rdsynergy003.north.pf.com:1521:synergy"/> > <property name="username" value="bus"/> > <property name="password" value="bus"/> > <property name="poolPreparedStatements" value="true"/> > > </bean> > Hi granda! I downloaded your configuration file, which had both the persistence adapter and the datasource commented out and I noticed 2 things: When I removed the comments the oracle-ds bean was declared inside the broker element, which is wrong. You can move that bean outside the broker element and it will work fine: <broker xmlns="http://activemq.apache.org/schema/core"; ...> <!-- Don't declare spring beans inside this --> ... </broker> <!-- Here is the place it should go --> <bean id="oracle-ds" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/> <property name="url" value="jdbc:oracle:thin:@rdsynergy003.north.pf.com:1521:synergy"/> <property name="username" value="bus"/> <property name="password" value="bus"/> <property name="poolPreparedStatements" value="true"/> </bean> One other minor issue is that in your xsiSchemaLocation you are refering to http://activemq.apache.org/schema/core/activemq-core.xsd which does not exists. This doesn't have to do with your problem but it would be good to fix it so that you can validate your configuration and catch errors like the one above before you deploy. I hope that helps. ----- Ioannis Canellos http://iocanel.blogspot.com/ http://iocanel.blogspot.com/ -- View this message in context: http://old.nabble.com/smx-4.2%2C-activemq-with-oracle-persistency-tp28672822p28677771.html Sent from the ServiceMix - User mailing list archive at Nabble.com.
