连接MSSQL数据库时出现Unknown Source错误是怎么回事?

[EdifierX]

我确定MSSQL是开着的.

环境为Win2k3+resin 2.1 +ms sql server 2000


<%@ page import='java.sql.*, javax.sql.*' %>


<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs";
String user="sa";
String password="123456";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="select tablename from jobs";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
System.out.println(rs.getString(1));
}
rs.close();
stmt.close();
conn.close();
%>

[sagittarius1979]

把错误贴完整。

[EdifierX]

500 Servlet Exception
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error
establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(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 java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at _mssql__jsp._jspService(/equiz/mssql.jsp:8)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:506)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:534)

[sagittarius1979]

不是Unknown Source的错误，而是你的连接出错，看看你的lib目录下有没有连接mySQL的驱动程序包，连接字有没有写错。。

[EdifierX]

不是MySQL, MS SQL , 我放了驱动了, 三个JAR文件嘛.

[EdifierX]

是补丁问题, WIN2K3 要给SQL SERVER 打上SP3...问题已解决

[weijian]

恭喜你解决了问题。

[ninghao37]

你把数据库用odbc连接一下
之后
<%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url="jdbc:odbc:pubs";
String user="sa";
String password="123456";
Connection conn= DriverManager.getConnection(url,user,password);
检查连接。就能分析出问题所在了。
如果上面能完成
那你就检查一下你的mssql的jdbc驱动

[panpan221]

新手来学习,友情UP