aspose file tools*
The moose likes JDBC 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
Bookmark "Oracle thin driver - ConnectionPoolDataSource" Watch "Oracle thin driver - ConnectionPoolDataSource" New topic
Author

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
kiran
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...

monty
[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).

http://technet.oracle.com/doc/oracle8i_816/java.816/a81354/samapp9.htm#1012209
Monty Ireland
Ranch Hand

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

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?
 
wood burning stoves
 
subject: Oracle thin driver - ConnectionPoolDataSource