Connection pool creation falis in weblogic 5.1
843829Jul 16 2002 — edited Jul 18 2002Hi!
I am having this configuration..
Application Server:weblogic 5.1
RDBMS:oracle 8.1.5
DataBase Instance:REDS
Jdk: jdk1.3
platform: win2000
i have created a connection pool by adding this code in
my weblogic property file...
weblogic.jdbc.connectionPool.testPool=\
url=jdbc:oracle:thin:scott/tiger@localhost:1251:REDS,\
driver=oracle.jdbc.driver.OracleDriver,\
loginDelaySecs=1,\
initialCapacity=4,\
maxCapacity=10,\
capacityIncrement=2,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=10,\
testTable=dual,\
props=user=SCOTT;password=tiger,\
allow=everyone
weblogic.jdbc.DataSource.testDataSource=testPool
when i start my weblogic server it throws these errors....
<JDBC Pool> Creating connection pool testPool with:
{refreshMinutes=10, poolName=testPool,
loginDelaySecs=1, testTable=dual, maxCapacity=10, props=user=SCOTT;password=tiger,
allowShrinking=true, driver=oracle.jdbc.driver.OracleDriver, allow=everyone,
aclName=weblogic.jdbc.connectionPool.testPool, capacityIncrement=2, initialCapacity=4,
url=jdbc:oracle:thin:scott/tiger@localhost:1251:REDS, shrinkPeriodMins=15}
Sun Jul 16 10:22:38 GMT+05:30 2000:<I> <JDBC Pool> Sleeping in createResource()
Sun Jul 16 10:22:39 GMT+05:30 2000:<E> <JDBC Pool> Failed to create connection pool "testPool"
weblogic.common.ResourceException: weblogic.common.ResourceException:
Could not create pool
connection. The DBMS driver exception was:
java.sql.SQLException: The Network Adapter could not
establish the connection
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:407)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:152)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:214)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:193)
at java.sql.DriverManager.getConnection(DriverManager.java:457)
at java.sql.DriverManager.getConnection(DriverManager.java:137)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:172)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:109)
at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java,
Compiled Code)
at weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java, Compiled
Code)
at weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:330)
at weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java, Compiled Code)
at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
at weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java, Compiled Code)
at weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:182)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:109)
at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java,
Compiled Code)
at weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java, Compiled
Code)
at weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:330)
at weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java, Compiled Code)
at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
at weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java, Compiled Code)
at weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:125)
at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java,
Compiled Code)
at weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java, Compiled
Code)
at weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:330)
at weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java, Compiled Code)
at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
at weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java, Compiled Code)
at weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
Sun Jul 16 10:22:39 GMT+05:30 2000:<I> <JDBC Init> Creating standard DataSource named
testDataSource for testPool pool
Sun Jul 16 10:22:40 GMT+05:30 2000:<I> <JMS> Beginning startup process
Sun Jul 16 10:22:40 GMT+05:30 2000:<I> <JMS> Init JMS Security
Sun Jul 16 10:22:40 GMT+05:30 2000:<I> <JMS> Initializing from weblogic.properties
Sun Jul 16 10:22:41 GMT+05:30 2000:<I> <JMS> Startup process complete. JMS is active
Sun Jul 16 10:22:41 GMT+05:30 2000:<I> <JMS> Bound SessionPoolManager as
weblogic.jms.SessionPoolManager
Sun Jul 16 10:22:41 GMT+05:30 2000:<I> <JMS> Bound ConnectionConsumerManager as
weblogic.jms.ConnectionConsumerManager
Sun Jul 16 10:22:41 GMT+05:30 2000:<I> <WebLogicServer> Invoking main-style startup RMI Registry
weblogic.rmi.internal.RegistryImpl
Sun Jul 16 10:22:41 GMT+05:30 2000:<I> <RMI> Registry started
Sun Jul 16 10:22:42 GMT+05:30 2000:<I> <EJB> Enterprise JavaBeans initializing
Sun Jul 16 10:22:53 GMT+05:30 2000:<I> <EJB JAR deployment d:/homefiles/account1.jar> EJB home
interface: 'com.account.AccountHome' deployed bound to the JNDI name: 'account.AccountHome'
Sun Jul 16 10:22:53 GMT+05:30 2000:<I> <EJB> 1 EJB jar files loaded, containing 1 EJBs
Sun Jul 16 10:22:53 GMT+05:30 2000:<I> <EJB> 1 deployed, 0 failed to deploy.
Sun Jul 16 10:22:54 GMT+05:30 2000:<I> <ZAC> ZAC ACLs initialized
Sun Jul 16 10:22:54 GMT+05:30 2000:<I> <ZAC> ZAC packages stored in local directory exports
Sun Jul 16 10:22:54 GMT+05:30 2000:<I> <ListenThread> Listening on port: 7001
Sun Jul 16 10:22:54 GMT+05:30 2000:<I> <SSLListenThread> Listening on port: 7002
Sun Jul 16 10:22:55 GMT+05:30 2000:<I> <WebLogicServer> WebLogic Server started
mainly iam getting this Exceptions
weblogic.common.ResourceException: weblogic.common.ResourceException:
Could not create pool
connection.
The DBMS driver exception was:
java.sql.SQLException: The Network Adapter could not establish the
connection
where am i wrong ???
thanks in advance...
..Raja