sql server 连接多个实例报错

现在有两个sql    server 实例，连接报错

##SQLServer

jdbc-0.proxool.driver-class=net.sourceforge.jtds.jdbc.Driver
jdbc-0.proxool.driver-url=jdbc:jtds:sqlserver://192.168.1.21\\SQL:1433/obpm
jdbc-0.user=sa
jdbc-0.password=123

jdbc-0.proxool.maximum-connection-count=50
jdbc-0.proxool.minimum-connection-count=10
jdbc-0.proxool.prototype-count=4
jdbc-0.proxool.house-keeping-test-SQL=SELECTCURRENT_DATE
jdbc-0.proxool.verbose=true
jdbc-0.proxool.statistics=10s,1m,1d
jdbc-0.proxool.statistics-log-level=DEBUG
jdbc-0.proxool.house-keeping-sleep-time=30000
jdbc-0.proxool.maximum-connection-lifetime=60000
jdbc-0.proxool.simultaneous-build-throttle=20
jdbc-0.proxool.overload-wIThout-refusal-lifetime=10000
jdbc-0.proxool.maximum-active-time=50000
jdbc-0.proxool.trace=true
jdbc-0.proxool.fatal-SQL-exception=ORA-1234
jdbc-0.proxool.prototype-count=2

jdbc:jtds:sqlserver://192.168.1.21\\SQL:1433/obpm
斜杠加上反斜杠肯定不行的嘛，请问你是如何配置的呢？
你可以参考一下帖子
http://www.teemlink.com/bbs/view ... %B5%CD%B3%CA%FD%BE%

jdbc-0.proxool.driver-class=net.sourceforge.jtds.jdbc.Driver
jdbc-0.proxool.driver-url=jdbc:jtds:sqlserver://localhost:1433/obpm
jdbc-0.user=sa
jdbc-0.password=

++++++++++++++++++++++++++++++++++++
powerby=\u5929\u7FCE\u516C\u53F8
type=G.\u96C6\u56E2\u7248

04:04:01,140 ERROR AutoAuditJobManager:127 - Auto Audit Job Manager Init Jobs Er
ror:
org.hibernate.exception.GenericJDBCException: Cannot open connection
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException
(SQLStateConverter.java:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:29)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager
.java:424)
        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.
java:144)
        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatc
her.java:139)
        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1538)
        at org.hibernate.loader.Loader.doQuery(Loader.java:661)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:224)
        at org.hibernate.loader.Loader.doList(Loader.java:2211)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
        at org.hibernate.loader.Loader.list(Loader.java:2090)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja
va:338)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java
:172)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at cn.myapps.base.dao.HibernateBaseDAO.getData(HibernateBaseDAO.java:83)

        at cn.myapps.core.superuser.dao.HibernateSuperUserDAO.findByLoginno(Hibe
rnateSuperUserDAO.java:93)
        at cn.myapps.core.superuser.ejb.SuperUserProcessBean.doViewByLoginno(Sup
erUserProcessBean.java:243)
        at cn.myapps.core.superuser.ejb.SuperUserProcessBean$$EnhancerByCGLIB$$6
f33f3db.CGLIB$doViewByLoginno$17(<generated>)
        at cn.myapps.core.superuser.ejb.SuperUserProcessBean$$EnhancerByCGLIB$$6
f33f3db$$FastClassByCGLIB$$62dee6d.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:167)
        at cn.myapps.protection.util.WarpProcessFactory.intercept(WarpProcessFac
tory.java:272)
        at cn.myapps.core.superuser.ejb.SuperUserProcessBean$$EnhancerByCGLIB$$6
f33f3db.doViewByLoginno(<generated>)
        at cn.myapps.core.superuser.ejb.SuperUserProcessBean.getDefaultAdmin(Sup
erUserProcessBean.java:239)
        at cn.myapps.core.superuser.ejb.SuperUserProcessBean$$EnhancerByCGLIB$$6
f33f3db.CGLIB$getDefaultAdmin$9(<generated>)
        at cn.myapps.core.superuser.ejb.SuperUserProcessBean$$EnhancerByCGLIB$$6
f33f3db$$FastClassByCGLIB$$62dee6d.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:167)
        at cn.myapps.protection.util.WarpProcessFactory.intercept(WarpProcessFac
tory.java:272)
        at cn.myapps.core.superuser.ejb.SuperUserProcessBean$$EnhancerByCGLIB$$6
f33f3db.getDefaultAdmin(<generated>)
        at cn.myapps.core.workflow.engine.AutoAuditJobManager.initJobs(AutoAudit
JobManager.java:88)
        at cn.myapps.base.web.listener.StartupListener.contextInitialized(Startu
pListener.java:76)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3830)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
337)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
1)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)

        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.jav
a:920)
        at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j
ava:883)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492
)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
        at org.apache.catalina.core.StandardService.start(StandardService.java:5
16)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: java.sql.SQLException: 无法打开登录 'obpm' 中请求的数据库。登录失败。

        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j
ava:368)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
        at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:602)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java
:344)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java
:50)
        at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(D
efaultConnectionBuilder.java:39)
        at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java
:159)
        at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPoo
l.java:211)
        at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:8
9)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:207)
        at org.hibernate.connection.ProxoolConnectionProvider.getConnection(Prox
oolConnectionProvider.java:53)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager
.java:421)

您好，根据您的错误提示是无法连接数据库。麻烦您用数据库客户端确认您的数据库是否能够连接。确认是否是数据库本身的问题。

电话跟客户沟通，目前比较忙，没时间测试http://wenku.baidu.com/view/21f174d85022aaea998f0f40.html帖子所提供的解决方案，已经换了一台没有实例名的机器做开发。故帖子先移到其他，后期客户尝试有问题时，可继续在帖子后跟进。