Sounds good for the most part.
I would only change to
osgi.jdbc.driver.name=oracle-pool-xa
As you probably want a DataSource that can take part in XA Transactions.
Just do not forget to install the transaction feature.
Christian
On 23.09.2015 15:17, xlogger wrote:
Many Thanks for your help!
I was able to create the Oracle DataSource and reference through osgi
service in Spring XML
Record my steps here just in case it might be helpful for others:
1) Go to the folder where ojdbc6.jar is located then enter the following in
command prompt:
mvn install:install-file -Dfile=ojdbc6.jar -DgroupId=com.oracle
-DartifactId=ojdbc6 -Dversion=11.2.0 -Dpackaging=jar
2) Go to karaf shell and enter:
install -s wrap:mvn:com.oracle/ojdbc6/11.2.0
feature:repo-add pax-jdbc 0.7.0
feature:install jdbc pax-jdbc-config pax-jdbc-pool-dbcp2 pax-jdbc-oracle
transaction
3) Check that 3 DataSourceFactories (OracleDriver, OracleDriver-pool and
OracleDriver-pool-xa) exists:
service:list DataSourceFactory
4) create "org.ops4j.datasource-<ds_name>.cfg" with the following contents
and store in karaf "etc" folder
osgi.jdbc.driver.name=oracle-pool
databaseName=<ds_name>
user=<username>
password=<password>
dataSourceName=<osgi_jndi_servicename_to-be_in_spring>
url=jdbc:oracle:thin:@<oracle_host>:<oracle_port>/<sid>
5) Check the datasource created:
service:list DataSource
6) In Spring XML (Note the osgi namespece and )
In Camel Application's Spring XML (note the hightlighted)
<?xml version= "1.0" encoding ="UTF-8"?>
<beans xmlns= "http://www.springframework.org/schema/beans";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xmlns:camel="http://camel.apache.org/schema/spring";
xmlns:osgi="http://www.springframework.org/schema/osgi";
xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://camel.apache.org/schema/spring
http://camel.apache.org/schema/spring/camel-spring.xsd
http://www.springframework.org/schema/osgi
http://www.springframework.org/schema/osgi/spring-osgi.xsd
">
...
<camelContext xmlns="http://camel.apache.org/schema/spring";>
...
</camelContext >
<osgi:reference id="db001"
interface="javax.sql.DataSource"
filter="(osgi.jndi.service.name=<osgi_jndi_servicename_to-be_in_spring>)"
/>
</beans>
--
View this message in context:
http://karaf.922171.n3.nabble.com/Karaf-4-0-1-create-Pooled-Oracle-datasource-tp4042724p4042733.html
Sent from the Karaf - User mailing list archive at Nabble.com.
--
Christian Schneider
http://www.liquid-reality.de
Open Source Architect
http://www.talend.com
