I can't configuring Pool Conection in WebLogic Server 7.0
Carlos Gómez
I'm configuring a pool connection in WebLogic Server 7.0 but I can't.
The DBMS is Oracle 8.1.6 and the parameters of this are:
server=gratil.hi.inet
port=1521
sid=bdtest
user=system
password=manager
The driver that I'm using is OCI Driver. In the weblogic console I'm configuring
the parameters of the pool. These parameters are:
Name: DBPoolGeiser
URL: jdbc:weblogic:pool:bdtest
Driver Classname: weblogic.jdbc.pool.Driver
Properties:
user=system
When I start the Weblogic I obtain this trace:
<15-oct-02 8:34:13 BST> <Error> <JDBC> <001060> <Cannot startup connection pool
"DBPoolGeiser" java.sql.SQLException: No suitable driver>
<15-oct-02 8:34:13 BST> <Error> <JDBC> <001059> <Error during Data Source creation:
weblogic.common.ResourceException: DataSource(examples-dataSource-demoPool) can't
be created with non-existent Pool (connection or multi) (DBPoolGeiser)
at weblogic.jdbc.common.internal.JdbcInfo.validateConnectionPool(JdbcInfo.java:127)
at weblogic.jdbc.common.internal.JdbcInfo.startDataSource(JdbcInfo.java:260)
at weblogic.jdbc.common.internal.JDBCService.addDeploymentx(JDBCService.java:293)
at weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.java:270)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:375)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:303)
at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:256)
at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:207)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:732)
at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:714)
at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:417)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:926)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:470)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:198)
at $Proxy35.updateDeployments(Unknown Source)
at weblogic.management.configuration.ServerMBean_CachingStub.updateDeployments(ServerMBean_CachingStub.java:4060)
at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(SlaveDeployer.java:2259)
at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:373)
at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:235)
at weblogic.t3.srvr.ServerLifeCycleList.resume(ServerLifeCycleList.java:61)
at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:806)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:295)
at weblogic.Server.main(Server.java:32)
Somebody can help me.
Thank you.
Mitesh Patel
You must do java utils.dbping oracle scott tiger dbname
to check if your environment is set properly or not.
You need following properties for creating connection pool in config.xml
<JDBCConnectionPool
DriverName="weblogic.jdbc.oci.Driver"
InitialCapacity="4"
MaxCapacity="4"
Name="OraclePool-2"
Properties="user=scott;password=tiger;server=patrick"
RefreshMinutes="5"
TestConnectionsOnRelease="true"
TestTableName="emp"
URL="jdbc:weblogic:oracle"/>
Let me know if that works.
Thanks,
Mitesh
Akilah McIntyre
2)Make sure you add your JDBC drivers to the beginning of CLASSPATH in either setDomainenv.cmd or setEnv.cmd
3)What really helped was BEA support and playing with BEA's JDBC example that shows how to create and deploy and use a data source.