Hi Everyone!
I don't know whether this is correct place for
sending the weblogic problems.
anyway i would really appreciate any help with this
problem
I am trying to connect to Oracle database
using connection pool in weblogic.
I am successful able to connect using sqlplus.
The server name is Test.
The pool name I used is TestPool.
The error I am getting is
"Wed Nov 10 13:31:54 PST 1999:<I> <JDBC Pool> Creating
connection pool TestPool with:
{refreshMinutes=10, poolName=TestPool,
loginDelaySecs=1, testTable=dual, maxCapacity=10,
props=user=scott;password=tiger;server=Test,
allowShrinking=true, driver=weblogic.jdbc.oci.Driver,
aclName=weblogic.jdbc.connectionPool.TestPool,
capacityIncrement=2, initialCapacity=4,
url=jdbc:weblogic:oracle, shrinkPeriodMins=15}
Wed Nov 10 13:31:55 PST 1999:<I> <JDBC Pool> Sleeping
in createResource()
Wed Nov 10 13:31:56 PST 1999:<E> <JDBC Pool> Failed to
create connection pool "TestPool"
Wed Nov 10 13:31:56 PST 1999:<E> <JDBC Pool>
weblogic.common.ResourceException:
weblogic.common.ResourceException:
Could not create pool connection. The DBMS driver
exception was:
java.sql.SQLException: - (scott/********@Test)
at
weblogic.db.oci.OciConnection.getLDAException(OciConnection.java:100)
at
weblogic.jdbcbase.oci.Driver.connect(Driver.java:156)
at
java.sql.DriverManager.getConnection(DriverManager.java:457)
at
java.sql.DriverManager.getConnection(DriverManager.java:106)
This is example bean in weblogic i.e BeanManaged.
I am able to connect successfully using demopool to
cloudscape.
I perhaps think it is some driver problem
or resource problem
But not quite sure how to fix it.
any help would be appreciated.
WEBLOGIC.PROPERTIES FILE
weblogic.jdbc.connectionPool.Testpool=\
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=Test
weblogic.allow.reserve.weblogic.jdbc.connectionPool.TestPool=
\guest,joe,jill
Regards
Parag.
PS : CC me at [EMAIL PROTECTED]
=====
__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
