Is the Oracle Thin driver implementing these 2 interfaces currently?

[Murali Mohan]

Hi all,
I read some where, JDBC2.0 provides 2 interfaces javax.sql.ConnectionPoolDataSource and javax.sql.PooledConnection. If my driver supports these interfaces can I get connection pooling by using these interfaces? Should I need any other packages? Should I do any coding or can I use these 2 interfaces like remaining interfaces statement,resultset.
Is the Oracle Thin driver implementing these 2 interfaces currently?
Thanks,
Murali
[ March 10, 2004: Message edited by: Murali Mohan ]

[Rudy Dakota]

Hi Murali,
That's a lot of questions in just a few lines. Let's get at them one by one!

If my driver supports these interfaces can I get connection pooling by using these interfaces?

In a way, yes. The only thing is, you still need the pool. The two interfaces provide you with the means to create 'poolable' connections. Nothing more, nothing less. There are pools you can download, or you can roll your own. It's not really difficult. You might even think it's fun.

Should I need any other packages?

Just said it: you might want to get a nice connection pool from somewhere.

Should I do any coding or can I use these 2 interfaces like remaining interfaces statement,resultset.

Oh no, not again. Whatever you like: code a pool or download one!

Is the Oracle Thin driver implementing these 2 interfaces currently?

Yes, it does. You know what: they're also in the OCI driver.
Good riddance,
Rudy.