数据库我用的是Microsoft SQL Server 2000 简体中文个人版 的然后写了个简单的JDBC连接程序,但总是出现下面的异常
public class DataConnection {
private static String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=sunhotel";
private static String user="sa";
private static String pwd="sa";
private static Connection conn;
public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
DriverManager.registerDriver (new com.microsoft.jdbc.sqlserver.SQLServerDriver());
conn=DriverManager.getConnection(url,user,pwd);
}
}
,但是一运行总是出现下面的异常
[Microsoft][SQLServer 2000 Driver for JDBC]Connection reset
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.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 java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.sunshine.sunsdk.sql.DataConnection.main(DataConnection.java:24)
我去GOOGLE上搜索了,有人说1433端口没开 可是我的SQL Server服务器是启动着的,我的应该不是这个问题
数据库用户名和密码 连接URL 我都检查了几遍应该没有问题,有人说 SP4补丁没有打,不知道是不是这样的问题
大家帮忙看下
public class DataConnection {
private static String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=sunhotel";
private static String user="sa";
private static String pwd="sa";
private static Connection conn;
public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
DriverManager.registerDriver (new com.microsoft.jdbc.sqlserver.SQLServerDriver());
conn=DriverManager.getConnection(url,user,pwd);
}
}
,但是一运行总是出现下面的异常
[Microsoft][SQLServer 2000 Driver for JDBC]Connection reset
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.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 java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.sunshine.sunsdk.sql.DataConnection.main(DataConnection.java:24)
我去GOOGLE上搜索了,有人说1433端口没开 可是我的SQL Server服务器是启动着的,我的应该不是这个问题
数据库用户名和密码 连接URL 我都检查了几遍应该没有问题,有人说 SP4补丁没有打,不知道是不是这样的问题
大家帮忙看下
解决方案 »
- Unhandled Exception thrown: class org.springframework.dao.CannotAcquireLockExcep
- struts2上传文件到tomcat虚拟目录问题
- 请教一个java timer定时器实用时问题
- 小弟初学 麻烦问一下 com.opensymphony.xwork2.Action放在struts中的哪里
- MyFaces 2.0.4 java.lang.NullPointerException at javax.faces.component.UIViewRoot
- Mian方法里测试Oracle数据库异常
- Eclipse中如何由UML类图直接生成代码
- 打印?
- BodyTagSupport救急
- 新手问问deploy.wsdd和server-config.wsdd的关系。
- SSH整合环境,spring初始化对象为空
- Spring里面有没有类似If语句的功能,能让用户更容易的修改配置?
msbase.jar
mssqlserver.jar
msutil.jar