• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

oracle connection pool

 
Ranch Hand
Posts: 91
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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?
 
author
Posts: 621
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Wanderer
Posts: 18671
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm transferring this to our new iPlanet forum...
 
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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


 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi All,
Where can I find Oracle Connection Pooling driver which is suitable to work with Commons DBCP package of Apache?
TIA
Sanjay
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic