|
public Connection getConnection() throws SQLException, ClassNotFoundException {
Connection conn = null;
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db";
String user_id = "sa";
String passwd = "1234";
try {
Class.forName( driver );
conn = DriverManager.getConnection(url, user_id, passwd);
} catch ( ClassNotFoundException ex ) {
System.err.println( "mssql - connect faild : " + ex.toString() );
} catch ( SQLException e ) {
System.err.println( "mssql - connect faild : " + e.toString() );
}
return conn;
}
--> error log
mssql - connect faild : java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
참고로 classpath 는 잡은 상태입니다.
/home/aeroad/lib/msbase.jar:/home/aeroad/lib/mssqlserver.jar:/home/aeroad/lib/msutil.jar
|
