File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Oracle thin driver - ConnectionPoolDataSource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle thin driver - ConnectionPoolDataSource" Watch "Oracle thin driver - ConnectionPoolDataSource" New topic

Oracle thin driver - ConnectionPoolDataSource

kiran mahavir
Ranch Hand

Joined: Jan 09, 2001
Posts: 35
Hello javaranch,
Would you please let me know whether oracle thin driver which comes with Oracle 8.0 implement ConnectionPoolDataSource.
Expecting your reply at the earliest.
Thanx in advance
Monty Ireland
Ranch Hand

Joined: Oct 03, 2000
Posts: 161
I do not n-know the answer to your question.
But, if you review the DataBaseMetaData class...
I think you might find the answer to your question.
By using the class to query the attributes of your database driver.

Multi-Platform Database Developer ( on E.S.T. )

Multi Platform Database Developer & DBA on E.S.T.
Vivek Viswanathan
Ranch Hand

Joined: Mar 03, 2001
Posts: 350
Yes I guess it does
As a matter of fact I am trying to implement Connection Poolling using, Oracle Thin Driver. I have got some tips for Connection Pooling from JDBC 2.0 Spec.
Do u have any idea on this ???
vivek Viswanathan

Vivek Viswanathan SCJP 1.2, SCJP 1.6,SCJD,SCEA,SCWCD,IBM-484,IBM-486,IBM-141,Ms.NET C# 70-316,SCMAD, LPIC-I
Monty Ireland
Ranch Hand

Joined: Oct 03, 2000
Posts: 161
Try the following:
Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("jdbc/AcmeDB");
Connection con = ds.getConnection("...");
If con becomes a valid ref, i would think that connection pooling
is a valid service....
If it does not work... fear not... i think some JINI entrys myst be made some where...
I am new ti EJB... let me know how thing turn out...

[This message has been edited by Monty Ireland (edited April 05, 2001).]
Bhupinder Dhillon
Ranch Hand

Joined: Oct 12, 2000
Posts: 124
Oracle website has a sample code listed here... you will have to register in order to access this resource (it's free).
Monty Ireland
Ranch Hand

Joined: Oct 03, 2000
Posts: 161
Great example ... Thank-you...
Multi-Platform Database Developer ( on E.S.T. )
Sunil Singh

Joined: Aug 03, 2001
Posts: 1
When I try compiling the sample code it gives me an error like
cannot access class javax.naming.referenceable
Any idea?
I agree. Here's the link:
subject: Oracle thin driver - ConnectionPoolDataSource
It's not a secret anymore!