Hi Sanjay,
Please find my responses to some of your questions below.
a> First, how to configure servicemix to persist any data so that JMS
broker which is ActiveMQ can persist data in to oracle DB?
Ashwin --> The conf directory of your servicemix installation contains a
file called servicemix.xml that instantiates the Servicemix container. This
container by default is designed to use a SEDA flow amd not ActiveMQ by
default. In order to persist servicemix message exchanges to Oracle using
the ActiveMQ broker, you need to set the flow to JMS flow for the Servicemix
container. Obviously, you still need to update the activemq broker settings
in the file called activemq.xml to now use the Oracle DS. The combination of
the two should help you achieve the desired effect.
b> Second, AFAIK,servicemix doesn't has
org.apache.commons.dbcp.BasicDataSource class in its classpath. Do I have to
copy commons-dbcp jar file in to smx' lib directory?
Ashwin --> Yes the jar is nt part of the servicemix distribution. You
will need to drop it into the lib directory so that it is on the classpath
when the servicemix container is instantiated.
c> Also what about oracle.jdbc.driver.OracleDriver class? Here too Do I
have to copy any orcale related jar file to smx lib directory?
Ashwin --> Yes
d> Next is url property of oracle db. what is the last filed in url
property here: mydbname? Does it a db name or table name or anything else?
Ashwin --> It has to be the OracleConnectionFactory URL as set here "
jdbc:oracle:thin:@192.168.1.4:1521" where 192.168.1.4 is the Oracle database
machine address and 1521 is the JDBC port.
Hope this helps.
Cheers,
Ashwin...
---
Ashwin Karpe, Principal Consultant, PS - Opensource Center of Competence
Progress Software Corp
972-304-9084 (Office)
972-971-1700 (Mobile)
----
Blog: http://opensourceknowledge.blogspot.com/
=====================================================================
Sanjay Jain wrote:
>
> Hi All,
>
> I am trying to configure HA on servicemix using oracle DB. I already gone
> through this page
>
> http://servicemix.apache.org/clustering.html
>
> and I am going with JDBC Master-Slave where I am using oracle as db for
> persisting the data.
>
> This is what I got from the above mentioned page:
>
> <amq:persistenceAdapter>
> <amq:jdbcPersistenceAdapter dataSource="#oracle-ds" />
> </amq: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:@192.168.1.4:1521:" />
> <property name="username" value="smix_node1_ha" />
> <property name="password" value="smix_node1_ha" />
> <property name="poolPreparedStatements" value="true" />
> </bean>
>
> Here I do have couple of doubts. First, how to configure servicemix to
> persist any data so that JMS broker which is ActiveMQ can persist data in
> to oracle DB?
>
> Second, AFAIK,servicemix doesn't has
> org.apache.commons.dbcp.BasicDataSource class in its classpath. Do I have
> to copy commons-dbcp jar file in to smx' lib directory?
>
> Also what about oracle.jdbc.driver.OracleDriver class? Here too Do I have
> to copy any orcale related jar file to smx lib directory?
>
> Next is url property of oracle db. what is the last filed in url property
> here: mydbname? Does it a db name or table name or anything else?
>
> I highly appreciate for any help.
>
> Thanks a lot in advance.
> Sanjay
>
>
--
View this message in context:
http://www.nabble.com/how-to-configure-servicemix-with-HA-using-oracle-db-tp20422737p20446964.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.
