weblogic7 db2 V8连接池问题

我在本机上安装WLS7 而在另外的机器上安装了DB2 V8,我在WLS ClassPath里加入DB2驱动程序db2java.zip;在WLS7 pool配置如下:
URL:jdbc:db2://192.168.0.147:6789/abc
Driver:COM.ibm.db2.jdbc.net.DB2Driver
prop:user=XXX
password=XXX
======================================
报错如下:
\jini\lib\sun-util.jar;D:\jj\cdl;D:\jj\cdl\cc;D:\j2me_cldc\bin;D:\midp-2_0-src-w
indows-i686\midp2.0fcs\bin;D:\midp-2_0-src-windows-i686\midp2.0fcs\lib;C:\j2sdk1
.4.0_01\jre\lib;C:\j2sdk1.4.0_01\jre\bin;D:\Apache Group\Tomcat 4.1;D:\Apache Gr
oup\Tomcat 4.1\bin;D:\jj;F:\bea\wlserver6.1\lib\msbase.jar;F:\bea\wlserver6.1\li
b\msutil.jar;F:\bea\wlserver6.1\lib\mssqlserver.jar;F:\bea\wlserver6.1\lib\msuti
l.jar;F:\bea\wlserver6.1\lib\db2java.zip;F:\bea2\weblogic700\server\lib\db2jcc.j
ar;

***********
* To start WebLogic Server, use a username and *
* password assigned to an admin-level user. For *
* server administration, use the WebLogic Server *
* console at http://[hostname]:[port]/console *
***********

F:\bea2\user_projects\mydomain>“F:\bea2\jdk131_03\bin\java“ -hotspot -Xms32m -Xm
x200m -Dweblogic.security.SSL.trustedCAKeyStore=F:\bea2\weblogic700\server\lib\c
acerts -Dweblogic.Name=myserver -Dbea.home=“F:\bea2“ -Dweblogic.management.usern
ame= -Dweblogic.management.password= -Dweblogic.ProductionModeEnabled= -Djava.se
curity.policy=“F:\bea2\weblogic700\server\lib\weblogic.policy“ weblogic.Server
<2003-8-5 上午11时30分43秒> <090065> om user.>
Enter username to boot WebLogic server:system
Enter password to boot WebLogic server:
Starting WebLogic Server...
<2003-8-5 上午11时30分55秒> <140005> n F:\bea2\user_projects\mydomain\.\config.xml>
<2003-8-5 上午11时31分07秒> <090082> using realm myrealm.>
<2003-8-5 上午11时31分07秒> <000327> c Admin Server “myserver“ for domain “mydomain“>
<2003-8-5 上午11时31分37秒> <001060> ool “Pool“ weblogic.common.ResourceException: Cannot load driver class: com.ibm.
db2.jcc.DB2Driver>
<2003-8-5 上午11时31分37秒> <001059> eation: weblogic.common.ResourceException: DataSource(DemoDataSource) can't be c
reated with non-existent Pool (connection or multi) (Pool)
at weblogic.jdbc.common.internal.JdbcInfo.validateConnectionPool(JdbcInf
o.java:127)
at weblogic.jdbc.common.internal.JdbcInfo.startDataSource(JdbcInfo.java:
189)
at weblogic.jdbc.common.internal.JDBCService.addDeploymentx(JDBCService.
java:293)
at weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.j
ava:270)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(Depl
oymentTarget.java:375)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Dep
loymentTarget.java:303)
at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeploy
ments(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(DynamicMB
eanImpl.java:732)
at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl
.java:714)
at weblogic.management.internal.ConfigurationMBeanImpl.invoke(Configurat
ionMBeanImpl.java:417)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
57)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
25)
at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBean
ServerImpl.java:926)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:470)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:198)
at $Proxy36.updateDeployments(Unknown Source)
at weblogic.management.configuration.ServerMBean_CachingStub.updateDeplo
yments(ServerMBean_CachingStub.java:4060)
at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployment
s(SlaveDeployer.java:2259)
at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.j
ava:373)
at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resum
e(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)
>
<2003-8-5 上午11时31分39秒> <010070> : cmpEJB
Exception is :

Unable to deploy EJB: TbZyda from cmpEJB.jar:

weblogic.ejb20.WLDeploymentException: The DataSource with the JNDI name: DemoDat
aSource could not be located. Please ensure that the DataSource has been deploye
d successfully and that the JNDI name in your EJB Deployment descriptor is corre
ct.
at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.setup(RDBMSPersisten
ceManager.java:138)
at weblogic.ejb20.manager.BaseEntityManager.setupPM(BaseEntityManager.ja
va:211)
at weblogic.ejb20.manager.BaseEntityManager.setup(BaseEntityManager.java
:181)
at weblogic.ejb20.manager.DBManager.setup(DBManager.java:162)
at weblogic.ejb20.deployer.ClientDrivenBeanInfoImpl.activate(ClientDrive
nBeanInfoImpl.java:945)
at weblogic.ejb20.deployer.EJBDeployer.activate(EJBDeployer.java:1296)
at weblogic.ejb20.deployer.EJBModule.activate(EJBModule.java:349)
at weblogic.j2ee.J2EEApplicationContainer.activateModule(J2EEApplication
Container.java:1592)
at weblogic.j2ee.J2EEApplicationContainer.activate(J2EEApplicationContai
ner.java:1029)
at weblogic.j2ee.J2EEApplicationContainer.activate(J2EEApplicationContai
ner.java:966)
at weblogic.management.deploy.slave.SlaveDeployer.setActivationStateForA
llApplications(SlaveDeployer.java:619)
at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.j
ava:376)
at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resum
e(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)

Unable to deploy EJB: TbZyda from cmpEJB.jar:

at weblogic.ejb20.deployer.EJBDeployer.activate(EJBDeployer.java:1359)
at weblogic.ejb20.deployer.EJBModule.activate(EJBModule.java:349)
at weblogic.j2ee.J2EEApplicationContainer.activateModule(J2EEApplication
Container.java:1592)
at weblogic.j2ee.J2EEApplicationContainer.activate(J2EEApplicationContai
ner.java:1029)
at weblogic.j2ee.J2EEApplicationContainer.activate(J2EEApplicationContai
ner.java:966)
at weblogic.management.deploy.slave.SlaveDeployer.setActivationStateForA
llApplications(SlaveDeployer.java:619)
at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.j
ava:376)
at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resum
e(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)
>
<2003-8-5 上午11时31分40秒> <149231> unable to set the activation state to true for the application cmpEJB
weblogic.management.ApplicationException: activate failed forcmpEJB
{
Module Name: cmpEJB, Error: Exception activating module: EJBModule(cmpEJB,status
=PREPARED)

Unable to deploy EJB: TbZyda from cmpEJB.jar:

TargetException:

Unable to deploy EJB: TbZyda from cmpEJB.jar:

}
at weblogic.j2ee.J2EEApplicationContainer.activate(J2EEApplicationContai
ner.java:1035)
at weblogic.j2ee.J2EEApplicationContainer.activate(J2EEApplicationContai
ner.java:966)
at weblogic.management.deploy.slave.SlaveDeployer.setActivationStateForA
llApplications(SlaveDeployer.java:619)
at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.j
ava:376)
at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resum
e(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)
>
<2003-8-5 上午11时31分40秒> <141052> tarted for development server.>
<2003-8-5 上午11时31分45秒> <000355> read.Default“ listening on port 7001, ip address 127.0.0.1>
<2003-8-5 上午11时31分45秒> <000355> nThread.Default“ listening on port 7002, ip address 127.0.0.1>
<2003-8-5 上午11时31分45秒> <141030> f Managed Server... This feature is on by default, you may turn this off by pass
ing -Dweblogic.management.discover=false>
<2003-8-5 上午11时31分45秒> <000331> Admin Server “myserver“ for domain “mydomain“ running in Development Mode>
<2003-8-5 上午11时31分45秒> <000365> nged to RUNNING>
<2003-8-5 上午11时31分45秒> <000360> n RUNNING mode>
请高人指点!
还有在本机要安装DB2 V8的客户端吗?

2003-08-06 16:28

就是没有找到COM.ibm.db2.jdbc.net.DB2Driver这个类。
两个可能，
一、检查你“COM.ibm.db2.jdbc.net.DB2Driver”的大小写。
二、 classpath没有设对，如果决绝不了把zip解压缩到web-inf/clesses下试试！

2003-08-06 16:44

db2java.zip确信是放在classpath里.类COM.ibm.db2.jdbc.net.DB2Driver
我用jb9工具database pilot测试是正确的.请指教!

2003-08-06 17:02

你看log里是：
>com.ibm.db2.jcc.DB2Driver
而你写的是：
>COM.ibm.db2.jdbc.net.DB2Driver

2003-08-06 17:22

抱歉,我刚才贴错了:错误如下:
CLASSPATH=F:\bea2\jdk131_03\lib\tools.jar;F:\bea2\weblogic700\server\lib\weblogi
c_sp.jar;F:\bea2\weblogic700\server\lib\weblogic.jar;C:\j2sdk1.4.0_01;C:\j2sdk1.
4.0_01\bin;C:\j2sdk1.4.0_01\lib;C:\j2sdk1.4.0_01\lib\tools.jar;C:\j2sdk1.4.0_01\
lib\dt.jar;F:\bea2\weblogic700\server\lib\msbase.jar;F:\bea2\weblogic700\server\
lib\msutil.jar;F:\bea2\weblogic700\server\lib\mssqlserver.jar; F:\bea2\weblogic7
00\server\lib\db2java.zip; F:\bea2\weblogic700\server\lib\db2jcc.jar;

PATH=.;F:\bea2\weblogic700\server\bin;F:\bea2\jdk131_03\bin;C:\Program Files\Bor
land\Delphi5\Projects\Bpl;C:\Program Files\Borland\vbroker\jre\Bin;C:\Program Fi
les\Borland\vbroker\Bin;C:\Program Files\Borland\Delphi5\Bin;C:\WINNT\system32;C
:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BI
NN;D:\Borland\Delphi6\Bin;D:\Borland\Delphi6\Projects\Bpl;c:\j2sdk1.4.0_01;c:\j2
sdk1.4.0_01\bin;c:\j2sdk1.4.0_01\lib;c:\j2sdk1.4.0_01\lib\tools.jar;c:\j2sdk1.4.
0_01\lib\dt.jar;C:\KAV2003;d:\jini\lib\jini-core.jar;d:\jini\lib\jini-ext.jar;d:
\jini\lib\sun-util.jar;D:\jj\cdl;D:\jj\cdl\cc;D:\j2me_cldc\bin;D:\midp-2_0-src-w
indows-i686\midp2.0fcs\bin;D:\midp-2_0-src-windows-i686\midp2.0fcs\lib;C:\j2sdk1
.4.0_01\jre\lib;C:\j2sdk1.4.0_01\jre\bin;D:\Apache Group\Tomcat 4.1;D:\Apache Gr
oup\Tomcat 4.1\bin;D:\jj;F:\bea\wlserver6.1\lib\msbase.jar;F:\bea\wlserver6.1\li
b\msutil.jar;F:\bea\wlserver6.1\lib\mssqlserver.jar;F:\bea\wlserver6.1\lib\msuti
l.jar;F:\bea\wlserver6.1\lib\db2java.zip;F:\bea2\weblogic700\server\lib\db2jcc.j
ar;

F:\bea2\user_projects\mydomain>"F:\bea2\jdk131_03\bin\java" -hotspot -Xms32m -Xm
x200m -Dweblogic.security.SSL.trustedCAKeyStore=F:\bea2\weblogic700\server\lib\c
acerts -Dweblogic.Name=myserver -Dbea.home="F:\bea2" -Dweblogic.management.usern
ame= -Dweblogic.management.password= -Dweblogic.ProductionModeEnabled= -Djava.se
curity.policy="F:\bea2\weblogic700\server\lib\weblogic.policy" weblogic.Server
<2003-8-6 下午05时22分21秒> <090065> om user.>
Enter username to boot WebLogic server:system
Enter password to boot WebLogic server:
Starting WebLogic Server...
<2003-8-6 下午05时23分13秒> <140005> n F:\bea2\user_projects\mydomain\.\config.xml>
<2003-8-6 下午05时23分24秒> <090082> using realm myrealm.>
<2003-8-6 下午05时23分24秒> <000327> c Admin Server "myserver" for domain "mydomain">
<2003-8-6 下午05时23分57秒> <001060> ool "PoolDB2" weblogic.common.ResourceException: Cannot load driver class: COM.i
bm.db2.jdbc.net.DB2Driver>
<2003-8-6 下午05时23分57秒> <001059> eation: weblogic.common.ResourceException: DataSource(DB2DataSource) can't be cr
eated with non-existent Pool (connection or multi) (PoolDB2)
at weblogic.jdbc.common.internal.JdbcInfo.validateConnectionPool(JdbcInf
o.java:127)
at weblogic.jdbc.common.internal.JdbcInfo.startDataSource(JdbcInfo.java:
189)
at weblogic.jdbc.common.internal.JDBCService.addDeploymentx(JDBCService.
java:293)
at weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.j
ava:270)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(Depl
oymentTarget.java:375)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(Dep
loymentTarget.java:303)
at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeploy
ments(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(DynamicMB
eanImpl.java:732)
at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl
.java:714)
at weblogic.management.internal.ConfigurationMBeanImpl.invoke(Configurat
ionMBeanImpl.java:417)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
57)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
25)
at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBean
ServerImpl.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.updateDeplo
yments(ServerMBean_CachingStub.java:4060)
at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployment
s(SlaveDeployer.java:2259)
at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.j
ava:373)
at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resum
e(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)
>
<2003-8-6 下午05时23分58秒> <141052> tarted for development server.>
<2003-8-6 下午05时24分17秒> <000355> nThread.Default" listening on port 7002, ip address 127.0.0.1>
<2003-8-6 下午05时24分17秒> <000355> read.Default" listening on port 7001, ip address 127.0.0.1>
<2003-8-6 下午05时24分17秒> <141030> f Managed Server... This feature is on by default, you may turn this off by pass
ing -Dweblogic.management.discover=false>
<2003-8-6 下午05时24分17秒> <000331> Admin Server "myserver" for domain "mydomain" running in Development Mode>
<2003-8-6 下午05时24分18秒> <000365> nged to RUNNING>
<2003-8-6 下午05时24分18秒> <000360> n RUNNING mode>

2003-08-07 11:26

你需要找到startWebLogic.cmd ，在这个文件里加入db2Driver的classpath。

set CLASSPATH=%WEBLOGIC_CLASSPATH%;%POINTBASE_CLASSPATH%;%JAVA_HOME%\jre\lib\rt.jar;%WL_HOME%\server\lib\webservices.jar;D:\db2\java\db2java.zip;%CLASSPATH%

另外需要注意，db2的driver是type2的driver。必需要有客户端才能用。
我曾经想在tomcat里连接db2，死活也连不上，最后只好用JDBC－ODBC桥，真恶心。

2003-08-07 18:31

谢谢 Sun Mellon !
我已经在StartWls.cmd里加入了驱动路径.
可能是我没在本机安装db2客户端吧/

weblogic7 db2 V8连接池问题

什么是Context上下文？

抽象两种方法：上下文与类型

Content与Context一字之差暗藏逆天极道

语境崩塌：你的注意力正被劫持

Context逻辑之道