Is the Oracle Thin driver implementing these 2 interfaces currently?
Murali Mohan
Ranch Hand
Posts: 47
posted 13 years ago
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 ]
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
Ranch Hand
Posts: 54
posted 13 years ago
Hi Murali,
That's a lot of questions in just a few lines. Let's get at them one by one!
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.
Just said it: you might want to get a nice connection pool from somewhere.
Oh no, not again. Whatever you like: code a pool or download one!
Yes, it does. You know what: they're also in the OCI driver.
Good riddance,
Rudy.
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.
