On Thursday, June 24, 2004, at 02:03 PM, Hamilton Verissimo de Oliveira (Engenharia - SPO) wrote:
-----Mensagem original----- De: David Jencks [mailto:[EMAIL PROTECTED]
I'm not sure what adapter you are using, or if Oracle actually supplies
an adapter themselves (there appear to be some adapter classes in the
10g jar).
As adapter you do you mean "JCA-JDBC"? I'm using OpenEJB implementation.
You might consider using the tranql Oracle adapter and using Oracle internal datasource pooling instead of Geronimo pooling. We haven't actually tried this significantly yet, so if you try it please let us know how it works.
I might try it, but I'd like to know how transactions will be enlisted if I
rely on Oracle Pool implementation.
We still use the Geronimo connection manager implementation, and it still enlists/delists transactions as usual. However, instead of pooling in Geronimo, whenever a connection is requested we get it from the OracleDataSource (backed by the Oracle pooling) and when a ManagedConnection is returned we destroy it, returning it to the OracleDataSource and presumably the Oracle pool. I think the geronimo-ra.xml in the oracle adapter is not actually set up to enable Oracle datasource pooling, and we haven't really tested how well this works.
thanks david jencks
<snip/>
Thanks, David!
Cheers, hammett
