• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Is the Oracle Thin driver implementing these 2 interfaces currently?

 
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
F is for finger. Can you stick your finger in your nose? Doesn't that feel nice? Now try this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic