Re: Oracle JDBC thin connection pooling

["David Morris" <David.Morris@xxxxxxxxxxxxx>]

Roman,

I like Proxool. You use it just like you were not doing connection
pooling and it proxies a pool in for you. You can register your pool
using JNDI or you can create a static method to return connections. I
generally use the second route because it is simpler and works just
fine. If you want to see an example there is one here:

http://cvs.sourceforge.net/viewcvs.py/iseries-toolkit/span/src/org/iseriestoolkit/database/

That package has an AbstractConnectionManager that provides the pooling
support and is extended for various JDBC drivers. I don't have an Oracle
implementation but the MySQLConnectionManager is close.

David Morris

>>> Roman.Prigozhin@xxxxxxxxxxxxxxx 4/20/2004 11:45:20 AM >>>
Hi All,
        I'm implementing number of java applications running on as400
and
connecting to Oracle database.
The only free driver I found for as400 is oracle thin driver. 
My question is :
        How to implement connection pooling ? 
        Is it possible to do it with "thin" driver.
        What are my options. 

Also I would like to share pool between separate applications. Should I
use
WebSphere ?

Thanks,
Roman Prigozhin