CODEWITHSUNDEEP
databaseoracle-databaseconnectionwebsphere
grog
grog

Reputation: 458

WebSphere 6.1 use OracleConnection object while still demanding connection management to the WAS

We're working with a WebSphere 6.1 application server and an Oracle 10g database.

We were asked to demand the DB connection management to the WAS but we must also use an OracleConnection object to properly work with our DB.

In detail, we get the com.ibm.ws.rsadapter.jdbc.wsjdbcconnection incompatible with oracle.jdbc.oracleconnection error if we stick with WebSphere's connection object.

Googling around suggested that we use the getNativeConnection method like so:

WSJdbcConnection conn = (WSJdbcConnection) ds.getConnection();
con = (OracleConnection) WSJdbcUtil.getNativeConnection((WSJdbcConnection) conn);

But then the connection would no longer be managed by WebSphere.

Is there any way to work with an Oracle connection object while still having WebSphere manage the DB connections?

Thank you,

best regards

EDIT: I was even asked not to use the WSCallHelper class

Upvotes: 0

Views: 677

Answers (1)

Andreas Veithen
Andreas Veithen

Reputation: 9154

Maybe the WSCallHelper API is what you are looking for.

Upvotes: 1

Related Questions