It's not a secret anymore!*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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?
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Oracle thin driver - ConnectionPoolDataSource
 
Similar Threads
oracle/jdbc/ttc7/TTC7Protocol Class Format Error
MDB calls EJB requires new transaction
JDBC Driver
Create ConnectionPoolDataSource and PooledConnection in Weblogic 6.1
Configuring JDBC Connectionpool in Weblogic7.0 with Oracle thin driver