Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Using OracleOCIConnectionPool in WebLogic 6.1  RSS feed

 
Bob Runstein
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I need to configure an OracleOCIConnectionPool so that I can use the OracleOCIConnectionPool.getProxyConnection method to have the connection act on behalf of a user other than the one used to open the connections in the pool. I also need these connections to support container managed EJB transactions, so the pool needs to be registered with WebLogic so the EJB container can access the connections.
I can create the pool in the WebLogic console and configure a datasource for it, but the datasource returns only the connection, not the OracleOCIConnectionPool which is required to set a different user context for the connection.
I can create the pool in code, but then how do I register it with WebLogic so I can use container managed transactions?
 
Chris Mathews
Ranch Hand
Posts: 2712
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't think this is possible in WebLogic. In order to participate in a CMT or a distributed transaction WebLogic requires the source to be a TxDatasource. Unfortunately a TxDatasource can only be backed by a WebLogic ConnectionPool. You can use the Oracle JDBC Driver, but I don't think you can take advantage of Oracle's OracleOCIConnectionPool.
Again, I don't think it is possible but I am not 100% sure. Contact BEA Support and see what kind of information they give you. Be sure to post back when you get the answer.
[ February 13, 2003: Message edited by: Chris Mathews ]
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!