File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Other Java Products and Servers and the fly likes oracle connection pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "oracle connection pool" Watch "oracle connection pool" New topic
Author

oracle connection pool

Kavita Ghia
Ranch Hand

Joined: Oct 10, 2000
Posts: 91
Hello friends,
I am writing a class which needs frequent connections to the database(oracle8i). i am currently using the bea weblogic server and its connection pool. right now i open separate connections for each instance i dont think thats the right way, so i tried opening a connection in a static initializer which will be there for all the instances, is there any other way by which i can have some common place for managing these connections so that all the instances use the same connection and minimize the time taken.
Thanks,
Kavita
Frank Carver
Sheriff

Joined: Jan 07, 1999
Posts: 6920
If you are really using Weblogic's connection pool, the you don't need to do anything else. When you think you are opening a new connection, you are actually getting one from the pool, so feel free to get one whenever needed, as long as you remember to return it when you have finished. Can you show us a bit of your database access code so we can see if you are really using the pool?


Read about me at frankcarver.me ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
Sean MacLean
author
Ranch Hand

Joined: Nov 07, 2000
Posts: 621
I just went through this on a project. You really have to look at the documentation carefully (we got caught!). We we're using iPlanet with JDBC and realized late in the project that the 'built-in' pooling was actually a collection of Java Connection objects all pointing to the same physical connection. Ultimately, we implemtented Oracle's connection pooling sceme, which you can find here.
http://oradoc.photo.net/ora816/java.816/a81354/connpoc2.htm
Sean
Jim Yingst
Wanderer
Sheriff

Joined: Jan 30, 2000
Posts: 18671
I'm transferring this to our new iPlanet forum...


"I'm not back." - Bill Harding, Twister
Adam Adams
Ranch Hand

Joined: Nov 28, 2001
Posts: 60
sorry to reply to you with a question but if you can take a look at my question and help me out i really appreciate it here we go:
i am trying to run the jdbc/oracle/simpleselect examples.
i folowed all the instruction from: setting the enviornment and build the examples and after i run it i get this error: even thought i have my path sets to in my startup scripts to:
set PATH=.\bin;.\bin\oci817_8;c:\oracle\ora81\bin;%PATH%
here is the error:
C:\bea\wlserver6.1\samples\examples\jdbc\oracle>java examples.jdbc.oracle.simple select
Starting Loading jDriver/Oracle .....
Exception in thread "main" java.sql.SQLException: System.loadLibrary(weblogicoci37) threw java.lang.UnsatisfiedLinkError: no weblogicoci37 in java.library.path at weblogic.jdbc.oci.Driver.loadLibraryIfNeeded(Driver.java:226)
at weblogic.jdbc.oci.Driver.connect(Driver.java:76)
at examples.jdbc.oracle.simpleselect.main(simpleselect.java:113)
Originally posted by Kavita Ghia:
Hello friends,
I am writing a class which needs frequent connections to the database(oracle8i). i am currently using the bea weblogic server and its connection pool. right now i open separate connections for each instance i dont think thats the right way, so i tried opening a connection in a static initializer which will be there for all the instances, is there any other way by which i can have some common place for managing these connections so that all the instances use the same connection and minimize the time taken.
Thanks,
Kavita

Sanjay Lalwani
Greenhorn

Joined: Nov 29, 2003
Posts: 3
Hi All,
Where can I find Oracle Connection Pooling driver which is suitable to work with Commons DBCP package of Apache?
TIA
Sanjay
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: oracle connection pool