Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle thin driver - ConnectionPoolDataSource

 
kiran mahavir
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 161
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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. )
 
Vivek Viswanathan
Ranch Hand
Posts: 350
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Monty Ireland
Ranch Hand
Posts: 161
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 124
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 161
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Great example ... Thank-you...
------------------
Multi-Platform Database Developer ( on E.S.T. )
 
Sunil Singh
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
When I try compiling the sample code it gives me an error like
cannot access class javax.naming.referenceable
Any idea?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic