Configuring oracle.jdbc.pool.OracleDataSource in JBOSS.

[Bennet Xavier]

Hi ,

I need to configure for oracle.jdbc.pool.OracleDataSource in Jboss.

I am using oracle.xdb.XMLType in the servlet and it expects the OracleDatasource while converting string to XMLType.

But the server retrives org.jboss.resource.adapter.jdbc.WrapperDataSource.

we can conver this to OracleDatasource by getting the underlying Datasource, but again that depends on one more jar.

is there any configuration to get OracleDatasource in JBOSS.

Thanks In Advance,
Bennet Xavier.

[Jaikiran Pai]

Bennet Xavier wrote:Hi ,
I am using oracle.xdb.XMLType in the servlet and it expects the OracleDatasource while converting string to XMLType.

....

we can conver this to OracleDatasource by getting the underlying Datasource, but again that depends on one more jar.

If you want to use a API on some class (OracleDataSource in this case) then you would definitely require that class (or the jar containing that class) to be available in the classpath. What's the problem with adding that jar to the classpath?

[Bennet Xavier]

Hi,

thanks for reply.

its not about adding the jar file to the class path. i already have the oracle driver jar file in lib directory.

the problem here is, jboss creates org.jboss.resource.adapter.jdbc.WrapperDataSource, but i need to create OracleDatasource.

so that getting connection and handling XMLType will be possible, which will be independent of servers.

Thanks,
Bennet.