• 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
  • Tim Cooke
  • paul wheaton
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

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.
 
I've got no option but to sell you all for scientific experiments. Or a tiny ad:
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
reply
    Bookmark Topic Watch Topic
  • New Topic