You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@servicemix.apache.org by Andrea Zoppello <zo...@tiscali.it> on 2009/02/27 13:51:17 UTC
Configuring Oracle XADatasource on servicemix.xml???
Hi,
I need to define two XA datasource in servicemix, and use these with
geronimo transaction manager.
After downloading a ( snapshot build of commons-dbcp ) I've try to
define the datasource in file jndi.xml as follow:
<entry key="java:comp/env/jdbc/metadb">
<bean id="metadb-ds"
class="org.apache.commons.dbcp.managed.BasicManagedDataSource"
destroy-method="close">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
<property name="url" value="jdbc:oracle:thin:@sibilla:1521:repo"/>
<!-- <property name="url"
value="jdbc:oracle:thin:@//sibilla:1521/repo"/> -->
<property name="username" value="spagic"/>
<property name="password" value="spagic"/>
<property name="defaultCatalog" value="spagic"/>
<property name="transactionManager" ref="transactionManager"/>
<property name="XADataSource"
value="oracle.jdbc.xa.client.OracleXADataSource"/>
</bean>
</entry>
but it's not working i'va always the following exception:
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (╚ stato specifi
cato un URL Oracle non valido: OracleDataSource.makeURL)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1228)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:884)
at
org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionP
rovider.java:69)
at
org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedCon
nectionProviderConnectionHelper.java:27)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:127)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:314)
at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)
at
Any idea???
Re: Configuring Oracle XADatasource on servicemix.xml???
Posted by Andrea Zoppello <zo...@tiscali.it>.
Hi,
Thank you for your reply, it seems to be a commons-dbcp problem when
used with Oracle,
see here:
https://issues.apache.org/jira/browse/DBCP-279
BTW i've tried to download a snapshot build from dbcp build system, but
it's not working, the last thing to try is to get a newer version of
oracle driver ( now i'm using ojdbc14.jar ), and i'll give a try to ojdbc5.
Jean-Baptiste Onofré ha scritto:
> Hi,
>
> Your JDBC URL seems correct.
>
> Try to don't use the XADataSource property, use directly the driverClassName property in place like this :
>
> <property name="driverClassName" value="oracle.jdbc.xa.client.OracleXADataSource"/>
>
> As the issue looks like around the JDBC URL, I think it will not help.
>
> Could you send the complete log stack trace ?
>
> Thanks
> Regards
>
> On Friday 27 February 2009 - 13:51, Andrea Zoppello wrote:
>
>> Hi,
>>
>> I need to define two XA datasource in servicemix, and use these with
>> geronimo transaction manager.
>>
>> After downloading a ( snapshot build of commons-dbcp ) I've try to
>> define the datasource in file jndi.xml as follow:
>> <entry key="java:comp/env/jdbc/metadb">
>> <bean id="metadb-ds"
>> class="org.apache.commons.dbcp.managed.BasicManagedDataSource"
>> destroy-method="close">
>> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
>> <property name="url" value="jdbc:oracle:thin:@sibilla:1521:repo"/>
>> <!-- <property name="url"
>> value="jdbc:oracle:thin:@//sibilla:1521/repo"/> -->
>> <property name="username" value="spagic"/>
>> <property name="password" value="spagic"/>
>> <property name="defaultCatalog" value="spagic"/>
>> <property name="transactionManager" ref="transactionManager"/>
>> <property name="XADataSource"
>> value="oracle.jdbc.xa.client.OracleXADataSource"/>
>>
>> </bean>
>> </entry>
>>
>> but it's not working i'va always the following exception:
>>
>> org.apache.commons.dbcp.SQLNestedException: Cannot create
>> PoolableConnectionFactory (??? stato specifi
>> cato un URL Oracle non valido: OracleDataSource.makeURL)
>> at
>> org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1228)
>> at
>> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:884)
>> at
>> org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionP
>> rovider.java:69)
>> at
>> org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedCon
>> nectionProviderConnectionHelper.java:27)
>> at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:127)
>> at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:314)
>> at
>> org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)
>> at
>>
>> Any idea???
>>
>
>
Re: Configuring Oracle XADatasource on servicemix.xml???
Posted by Jean-Baptiste Onofré <jb...@nanthrax.net>.
Hi,
Your JDBC URL seems correct.
Try to don't use the XADataSource property, use directly the driverClassName property in place like this :
<property name="driverClassName" value="oracle.jdbc.xa.client.OracleXADataSource"/>
As the issue looks like around the JDBC URL, I think it will not help.
Could you send the complete log stack trace ?
Thanks
Regards
On Friday 27 February 2009 - 13:51, Andrea Zoppello wrote:
> Hi,
>
> I need to define two XA datasource in servicemix, and use these with
> geronimo transaction manager.
>
> After downloading a ( snapshot build of commons-dbcp ) I've try to
> define the datasource in file jndi.xml as follow:
> <entry key="java:comp/env/jdbc/metadb">
> <bean id="metadb-ds"
> class="org.apache.commons.dbcp.managed.BasicManagedDataSource"
> destroy-method="close">
> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
> <property name="url" value="jdbc:oracle:thin:@sibilla:1521:repo"/>
> <!-- <property name="url"
> value="jdbc:oracle:thin:@//sibilla:1521/repo"/> -->
> <property name="username" value="spagic"/>
> <property name="password" value="spagic"/>
> <property name="defaultCatalog" value="spagic"/>
> <property name="transactionManager" ref="transactionManager"/>
> <property name="XADataSource"
> value="oracle.jdbc.xa.client.OracleXADataSource"/>
>
> </bean>
> </entry>
>
> but it's not working i'va always the following exception:
>
> org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (??? stato specifi
> cato un URL Oracle non valido: OracleDataSource.makeURL)
> at
> org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1228)
> at
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:884)
> at
> org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionP
> rovider.java:69)
> at
> org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedCon
> nectionProviderConnectionHelper.java:27)
> at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:127)
> at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:314)
> at
> org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)
> at
>
> Any idea???
--
Jean-Baptiste Onofré
---------------------------------
HomePage
http://www.nanthrax.net
---------------------------------
Contacts
jbonofre@apache.org
jb@nanthrax.net
---------------------------------
OpenSource
BuildProcess/AutoDeploy
http://buildprocess.sourceforge.net
Apache ServiceMix
http://servicemix.apache.org
-----------------------------------
PGP : 17D4F086