What version you using? On Oct 25, 2007 6:28 AM, navneek <[EMAIL PROTECTED]> wrote: > > Hi, > > Im using the following configuration for persisting messages into oracle > database. Ultimately When I start activemq the tables (activemq_acks, > activemq_lock, activemq_msgs) are created but it is not holding any message > in table named 'activemq_msgs'. When I post messages into Broker, msg > staying in broker only... but msg are not going into dadabase > table(activemq_msgs).Table data remains empty.. Please let me know if im > missing anymore configuration. I want to populate this table with the > messages im posting in broker. > > My configuration: > -------------------------------------- > <broker xmlns="http://activemq.org/config/1.0" brokerName="localhost" > persistent="true"> > <persistenceAdapter> > <jdbcPersistenceAdapter dataSource="#oracle-ds" > useDatabaseLock="true"/> > </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:@mydb:1521:orclcore"/> > <property name="username" value="scott"/> > <property name="password" value="testpw"/> > <property name="poolPreparedStatements" value="true"/> > </bean> > > -- > View this message in context: > http://www.nabble.com/Messages-are-not-getting-persisted-in-database-table.%28jdbcPersistenceAdapter%3E-tf4690259s2354.html#a13404857 > Sent from the ActiveMQ - User mailing list archive at Nabble.com. > >
-- Regards, Hiram Blog: http://hiramchirino.com Open Source SOA http://open.iona.com
