Hey Ashwin,
Thanks for your detailed and crystal clear information. Before moving to
persistence configuration I wanted to confirm I am heading in right
direction.
For servicemix.xml configuration as you said, by default smx uses SEDA flow.
I looked at servicemix.xml and this is what I see:
<sm:broker>
<sm:securedBroker authorizationMap="#authorizationMap">
<sm:flows>
<sm:sedaFlow />
<sm:jmsFlow jmsURL="${activemq.url}" />
<sm:jcaFlow connectionManager="#connectionManager"
jmsURL="${activemq.url}" />
</sm:flows>
</sm:securedBroker>
</sm:broker>
I believe here, I have to comment out/remove <sm:sedaFlow> and <sm:jcaFlow>
elements and just have to keep <sm:jmsFlow>. Please correct me if I am
wrong.
Next is the url property in activemq.xml, I have asked about the mydbname?
what mydbname designates in this sample url? <property name="url"
value="jdbc:oracle:thin:@192.168.1.4:1521:mydbname" />
I do understand that 192.168.1.4 is the oracle server ip address where
oracle is running on 1521 port. But just want to know mydbname is the db
name or table name or something else?
Looking forward to see your answers.
Thanks again,
Sanjay
Ashwin Karpe wrote:
>
> 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-tp20422737p20452882.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.
