The Connection Pool in Weblogic Server.
Hi Everbody,
I am using Weblogic with Oracle8i on WindowsNT4.0
I am connecting to Weblogic via Connection Pooling.
In my weblogic.properties file I have the following code:
weblogic.jdbc.connectionPool.oraclePool=\
url=jdbc:weblogic:oracle,\
driver=weblogic.jdbc.oci.Driver,\
loginDelaySecs=1,\
initialCapacity=4,\
maxCapacity=10,\
capacityIncrement=2,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=10,\
testTable=dual,\
props=user=SCOTT;password=tiger;server=Oracle8
[I am able to connect to DB by SQL Plus with given parameters]
But when I write it in My Servlet:
Class.forName("weblogic.jdbc.pool.Driver");
conn = DriverManager.getConnection"jdbc:weblogic:pool:oraclePool");
I am getting the Error and not able to connect to the DB.The error raised
is:
java.SQL.Exception: Poolconnect failed: Connection Pool oraclePool does not
exist.
Can anybodyof you tell me that what might be the problem??? How I can rectify
it????
TIA.
Re: The Connection Pool in Weblogic Server.
"Vikas Arora" <vikas_arora80@rediffmail.com> wrote:
>I am getting the Error and not able to connect to the DB.The error raised
>is:
>java.SQL.Exception: Poolconnect failed: Connection Pool oraclePool
>does not exist.
Hi Vikas,
You should be able to confirm that the connection pool is
being created on startup via the weblogic.log associated with
your app server instance. Look for errors there. Also, you can
take the raw parameters and write a small jdbc app/applet that
connects to the database directly. That can help you to test
your drivers, URI, etc. Other than that, this is a tricky thing
to troubleshoot and you may simply have to go back to the docs
to make sure you're doing everything correctly.
Steve