-
1. Re: Anyone using Oracle 9i OCI driver for Connection Pooling
davidjencks Dec 17, 2001 11:21 PM (in response to terry_ray)Not knowing anything about what Oracle is up to...
Basically you get a choice of using a Driver implementation or an XADataSource implementation. You can't use a DataSource or ConnectionPoolDataSource implementation.
If there's a Driver, the examples in the manual should be very close to what you need. If there is a XADataSource, I think you will be the first to make it work. You need to use the jboss-xa.rar as the resource adapter and the JCA:service=ConnectionManagerFactoryLoader,name=MinervaXACMFactory
ConnectionManagerFactory.
You may well also need to use Oracle xid, this is set in the transaction manager mbean in conf/default/jboss-service.xml
If you get into trouble, ask, and if you succeed please contribute your config to the manual.
If all Oracle gives you is a ConnectionPoolDataSource I'm not sure how to proceed... -
2. Re: Anyone using Oracle 9i OCI driver for Connection Pooling
terry_ray Dec 18, 2001 11:49 AM (in response to terry_ray)Thanks for the feedback David. Yes, Oracle does provide an XADataSource implementation with the OCI driver. But, I'm not sure even this would work the way I want it to. Basically, I'm trying to use the authentication proxy/lightweight session feature that is provided with the OCI driver so I can set up a connection pool using a generic login and then proxy the actual user to the database. Oracle supports this with their OracleOCIConnectionPool class which extends the OracleDataSource class. You can get a proxy connection (passing in the real user) from an instance of the OracleOCIConnectionPool class. However, I don't think this is going to plug into JBoss since I can't find any way to specify that these classes are used for the pooling. But, thanks anyway for the help.