在weblogic server 7使用ms的jdbc driver for sql server 2000是出错!急,大侠帮忙!

merlin45 2002-12-02 11:55:30

I use microsoft's jdbc driver for sql server 2000

when i only config connection pool ,everything is ok
but i config the tx datasource,the server show error.

the config.xml is
<JDBCConnectionPool
DriverName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
MaxCapacity="30" Name="pubs_db" Password="{3DES}HHqQcuRGKdU="
Properties="user=merlin45;databaseName=pubs"
Targets="myserver" URL="jdbc:microsoft:sqlserver://merlin45:1433"/>
<JDBCTxDataSource JNDIName="jdbc/pubs" Name="ds_pubs"
PoolName="pubs_db" Targets="myserver"/>

the exception is

<2000-12-2 上午11时08分49秒> <Error> <JDBC> <001059> <Error during Data Source c
reation: weblogic.common.ResourceException: DataSource(jdbc/pubs) can't be creat
ed with non-existent Pool (connection or multi) (pubs_db)
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)
>
<2000-12-2 上午11时08分52秒> <Notice> <Management> <141052> <Application Poller
started for development server.>
<2000-12-2 上午11时08分57秒> <Notice> <WebLogicServer> <000354> <Thread "ListenT
hread.Default" listening on port 7001>
<2000-12-2 上午11时08分57秒> <Notice> <WebLogicServer> <000354> <Thread "SSLList
enThread.Default" listening on port 7002>
<2000-12-2 上午11时08分57秒> <Notice> <Management> <141030> <Starting discovery
of Managed Server... This feature is on by default, you may turn this off by pas
sing -Dweblogic.management.discover=false>
<2000-12-2 上午11时08分57秒> <Notice> <WebLogicServer> <000331> <Started WebLogi
c Admin Server "myserver" for domain "sqldomain" running in Development Mode>
<2000-12-2 上午11时08分58秒> <Notice> <WebLogicServer> <000365> <Server state ch
anged to RUNNING>
<2000-12-2 上午11时08分58秒> <Notice> <WebLogicServer> <000360> <Server started
in RUNNING mode>


but the connection pool name is same ,How to fix the problem?help me!
...全文
41 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
thlong 2002-12-02
  • 打赏
  • 举报
回复
好像有一个weblogic.mssqlserver4.driver(记不清具体得了,抱歉)
是可以用的
weblogic的帮助中有介绍的
merlin45 2002-12-02
  • 打赏
  • 举报
回复
谢谢楼上,问题找到了。
是sql server set问题。

另weblogic 只能使用sql server auth吗?
merlin45 2002-12-02
  • 打赏
  • 举报
回复
哪个driver不止为什么已经deprecated by weblogic。

1,220

社区成员

发帖
与我相关
我的任务
社区描述
企业软件 中间件技术
社区管理员
  • 中间件
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧