[Oracle] Fuse 4.3 ?

["Olivier.Roger" <ol...@bsb.com>]

Hello SMX!

I was using Fuse 4.2 with ActiveMQ and an Oracle database without problem.
I recently upgraded Fuse to 4.3 and discovered my procedure to connect
ActiveMQ to Oracle was not correct anymore.

I described the datasource in the activemq-broker.xml file as such:

<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:mydbname"
/> 
  <property name="username" value="smix_node1_ha" /> 
  <property name="password" value="smix_node1_ha" /> 
  <property name="poolPreparedStatements" value="true" /> 
</bean>

and enhanced the feature file to describe the feature as shown below:

    <feature name="activemq-broker" version="4.3.0-fuse-01-00">
        <feature version="5.4.0-fuse-00-00">activemq-blueprint</feature>
        <bundle>blueprint:file:etc/activemq-broker.xml</bundle>
       
<bundle>mvn:com.oracle.jdbc/com.springsource.oracle.jdbc/10.2.0.2</bundle>
       
<bundle>mvn:org.apache.servicemix.bundles/org.apache.servicemix.bundles.commons-dbcp/1.2.2_3</bundle>
    </feature>

In the log I found the following error :

Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
...
at java.lang.ClassLoader.loadClass(Unknown Source)[:1.6.0_18]

The spring bundle exports the oracle.jdbc.driver package that contains the
OracleDriver class.

Is there something that changed recently?
Am I making a mistake ?

Hope you can help me,

Olivier
-- 
View this message in context: http://servicemix.396122.n5.nabble.com/Oracle-Fuse-4-3-tp3207427p3207427.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.

Re: [Oracle] Fuse 4.3 ?

[Adrian Trenaman <tr...@progress.com>]

  Hi Olivier,

If you're using Oracle to create a master-slave lock for a 
high-availability deployment of ServiceMix, then I think you'll need to 
put the Oracle drivers in the lib/ folder, as the JDBC locking stuff is 
separate from the OSGi runtime and so needs to be available on the 
bootstrap classpath.

/Ade

On 12/10/2010 09:01, Olivier.Roger wrote:
> I had not driver in the /lib directory since I wanted to deploy it as a
> dependency bundle of the activmq-broker feature.
>
> It is mandatory to have drivers in the /lib folder?

Re: [Oracle] Fuse 4.3 ?

["Olivier.Roger" <ol...@bsb.com>]

I had not driver in the /lib directory since I wanted to deploy it as a
dependency bundle of the activmq-broker feature.

It is mandatory to have drivers in the /lib folder? 
-- 
View this message in context: http://servicemix.396122.n5.nabble.com/Oracle-Fuse-4-3-tp3207427p3208530.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.

Re: [Oracle] Fuse 4.3 ?

[Ramesh Babu <pr...@podar.net>]

please check these jar files are there or not in ur lib folder 
classes12.jar and ojdbc14.jar
-- 
View this message in context: http://servicemix.396122.n5.nabble.com/Oracle-Fuse-4-3-tp3207427p3208503.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.