bonjour tout le monde.
je veux me connecter a une base de donnée sql 2000 a partir d'eclipse
et voila le code que j'ai utilisé
import
java.*;public
class Connect{private java.sql.Connection con = null;privatefinal String url = "jdbc:microsoft:sqlserver://";privatefinal String serverName= "localhost";privatefinal String portNumber = "1433";privatefinal String databaseName= "CDR";privatefinal String userName = "user";privatefinal String password = "password";// Informs the driver to use server a side-cursor, // which permits more than one active statement // on a connection.privatefinal String selectMethod = "cursor"; // Constructorpublic Connect(){}private String getConnectionUrl(){return url+serverName+":"+portNumber+";databaseName="+databaseName+";selectMethod="+selectMethod+";";}
private java.sql.Connection getConnection(){try{Class.forName(
"com.microsoft.jdbc.sqlserver.SQLServerDriver"); con = java.sql.DriverManager.getConnection(getConnectionUrl(),userName,password);
if(con!=null) System.out.println("Connection Successful!");}
catch(Exception e){e.printStackTrace();
System.out.println(
"Error Trace in getConnection() : " + e.getMessage());}
return con;}
/*Display the driver properties, database details
*/
publicvoid displayDbProperties(){java.sql.DatabaseMetaData dm =
null;java.sql.ResultSet rs =
null;try{con=
this.getConnection();if(con!=null){dm = con.getMetaData();
System.out.println(
"Driver Information");System.out.println(
"\tDriver Name: "+ dm.getDriverName());System.out.println(
"\tDriver Version: "+ dm.getDriverVersion ());System.out.println(
"\nDatabase Information ");System.out.println(
"\tDatabase Name: "+ dm.getDatabaseProductName());System.out.println(
"\tDatabase Version: "+ dm.getDatabaseProductVersion());System.out.println(
"Avalilable Catalogs ");rs = dm.getCatalogs();
while(rs.next()){System.out.println(
"\tcatalog: "+ rs.getString(1));}
rs.close();
rs =
null;closeConnection();
}
else System.out.println("Error: No active Connection");}
catch(Exception e){e.printStackTrace();
}
dm=
null;}
privatevoid closeConnection(){try{if(con!=null)con.close();
con=
null;}
catch(Exception e){e.printStackTrace();
}
}
publicstaticvoid main(String[] args) throws Exception{
Connect CDR =
new Connect();CDR.displayDbProperties();
}
}
mais j'ai rencontré un probléme et voila le message qui apparait:
Error occurred during initialization of VM
java/lang/NoClassDefFoundError: java/lang/Object