Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Is the Oracle Thin driver implementing these 2 interfaces currently?

 
Murali Mohan
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic