Tomcat启动时出现java.sql.SQLException

Question

奇怪了!!为什么我启动Tomcat的时候会出现

而我类中运行一些对数据库的操作却没出现这个异常

我的Tomcat是5.5的 Myeclipse5.5 + sql server2000

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户 'sa' 登录失败。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:68)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:87)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C3P0PooledConnectionPool.java:83)
at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:884)
at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:601)
at com.mchange.v2.resourcepool.BasicResourcePool.access$400(BasicResourcePool.java:31)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1079)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:354)
如果不是Web应用程序直接在类中写连jdbc的代码能正常运行

Answer 1

如果不是Web应用程序直接在类中写连jdbc的代码能正常运行
如果那样的话是可以正常运行的。。

估计你是不是配置数据库连接池了。。或者你用到speing或者别的什么连接池了。所以在启动的时候。tomcat去访问数据库出现连接异常导致这个异常出现

Answer 2

1.sqlserver 2000 要装sp3或者sp4补丁
2.打开防火墙的TCP 1433,和UDP 1434端口
3.检查sa用户名密码是否正确。

Answer 3

1.删除这行语句： Connection con=DriverManager.getConnection
("jdbc:jtds:sqlserver://127.0.0.1:1433;databasename=你的数据库名;","sa","sa");的最后一个sa.那是你sa用户的登录密码.

2.检查防火墙是否屏蔽了1433端口

3.检查你sa用户的密码，然后填入最后一个sa那里

4.重装sql,并打上sp4补丁

Answer 4

用系统的能不能登陆.