/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/package jdbc.connection;import java.sql.*;
import java.sql.Connection;
import java.util.logging.Level;
import java.util.logging.Logger;/**
*
* @author Administrator
*/
public class JDBC_MSSQL_Connection {
static String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
static String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs";
static String userName = "sa";
static String userPwd = "";
static Connection con = null; public static void main(String args[]) throws ClassNotFoundException{
Class.forName(driverName);
try {
con = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
} catch (SQLException ex) {
Logger.getLogger(JDBC_MSSQL_Connection.class.getName()).log(Level.SEVERE, null, ex);
} finally{
try {
con.close();
} catch (SQLException ex) {
Logger.getLogger(JDBC_MSSQL_Connection.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
}
run:
2008-12-14 16:50:37 jdbc.connection.JDBC_MSSQL_Connection main
严重: null
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:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at jdbc.connection.JDBC_MSSQL_Connection.main(JDBC_MSSQL_Connection.java:27)
Exception in thread "main" java.lang.NullPointerException
at jdbc.connection.JDBC_MSSQL_Connection.main(JDBC_MSSQL_Connection.java:33)
Java Result: 1
成功生成(总时间:3 秒)
在网上找了好久
找到了两个问题
1.sql server 2000没有升级到sp4
2.TCP/IP端口号没有设置为1433
两个问题我都试了试,结果还是没有解决
请高手帮忙解决一下这个问题
万分感谢
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/package jdbc.connection;import java.sql.*;
import java.sql.Connection;
import java.util.logging.Level;
import java.util.logging.Logger;/**
*
* @author Administrator
*/
public class JDBC_MSSQL_Connection {
static String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
static String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs";
static String userName = "sa";
static String userPwd = "";
static Connection con = null; public static void main(String args[]) throws ClassNotFoundException{
Class.forName(driverName);
try {
con = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
} catch (SQLException ex) {
Logger.getLogger(JDBC_MSSQL_Connection.class.getName()).log(Level.SEVERE, null, ex);
} finally{
try {
con.close();
} catch (SQLException ex) {
Logger.getLogger(JDBC_MSSQL_Connection.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
}
run:
2008-12-14 16:50:37 jdbc.connection.JDBC_MSSQL_Connection main
严重: null
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:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at jdbc.connection.JDBC_MSSQL_Connection.main(JDBC_MSSQL_Connection.java:27)
Exception in thread "main" java.lang.NullPointerException
at jdbc.connection.JDBC_MSSQL_Connection.main(JDBC_MSSQL_Connection.java:33)
Java Result: 1
成功生成(总时间:3 秒)
在网上找了好久
找到了两个问题
1.sql server 2000没有升级到sp4
2.TCP/IP端口号没有设置为1433
两个问题我都试了试,结果还是没有解决
请高手帮忙解决一下这个问题
万分感谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货