This content has been marked as final.
Show 1 reply
-
1. Re: How to - JMS Binding Components with Oracle persistence
davestanley Aug 11, 2009 10:41 AM (in response to balamsoft)Hi Angel,
Do you want to 1) use Oracle under the covers for the broker/jms message persistence or 2) do you want to persist your business data to Oracle?
Assuming 1) i.e. you want to use Oracle as the persistent store for the underlying jms broker then you configure the persistence layer for the broker using /conf/activemq.xml
You would disable the default file based persistence adapter and enable the pooled jdbc persistence adapter. I've pasted a sample oracle datasource below, which you need to reference:
<!-- Oracle DataSource Sample Setup --> <bean id="oracle-ds" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property> <property name="url" value="jdbc:oracle:thin:@localhost:1521:AMQDB"></property> <property name="username" value="scott"></property> <property name="password" value="tiger"></property> <property name="maxActive" value="200"></property> <property name="poolPreparedStatements" value="true"></property> </bean>
Hope this helps
/Dave