you need a driver,
for jdk1.4, the one from microsoft can not be used.
below one is free:
public class ConnectDatabaseSource {
private String login;
private String password ;
private String dbServerName ;
private String dbDatabaseName;
public ConnectDatabaseSource() {
ConfigParser myParser = new ConfigParser();
login = myParser.getParameterValue("DBUser");
password = myParser.getParameterValue("DBPassword");
dbServerName = myParser.getParameterValue("DBServer");
dbDatabaseName = myParser.getParameterValue("DBName");
} public DataSource getDBDataSource(){
try{
// for technical support
Class.forName("com.inet.pool.PoolDriver").newInstance();
// create a DataSource
com.inet.tds.TdsDataSource tds = new com.inet.tds.TdsDataSource();
tds.setServerName(dbServerName);
tds.setDatabaseName(dbDatabaseName);
tds.setLoginTimeout( 10 );
tds.setUser(login);
tds.setPassword( password );
tds.setLoginTimeout( 10 );
//tds.setDescription( "A Test Data Source" );
DataSource ds = tds;
return ds;
}catch(Exception de){
System.err.println(de.getMessage());
}
return null;
} public Connection getConnection(DataSource ds) throws SQLException{
return ds.getConnection();
}
}
for jdk1.4, the one from microsoft can not be used.
below one is free:
public class ConnectDatabaseSource {
private String login;
private String password ;
private String dbServerName ;
private String dbDatabaseName;
public ConnectDatabaseSource() {
ConfigParser myParser = new ConfigParser();
login = myParser.getParameterValue("DBUser");
password = myParser.getParameterValue("DBPassword");
dbServerName = myParser.getParameterValue("DBServer");
dbDatabaseName = myParser.getParameterValue("DBName");
} public DataSource getDBDataSource(){
try{
// for technical support
Class.forName("com.inet.pool.PoolDriver").newInstance();
// create a DataSource
com.inet.tds.TdsDataSource tds = new com.inet.tds.TdsDataSource();
tds.setServerName(dbServerName);
tds.setDatabaseName(dbDatabaseName);
tds.setLoginTimeout( 10 );
tds.setUser(login);
tds.setPassword( password );
tds.setLoginTimeout( 10 );
//tds.setDescription( "A Test Data Source" );
DataSource ds = tds;
return ds;
}catch(Exception de){
System.err.println(de.getMessage());
}
return null;
} public Connection getConnection(DataSource ds) throws SQLException{
return ds.getConnection();
}
}
try{
DataSource ds = getDBDataSource();
Connection con = getConnection(ds);
Statement statmt = con.createStatement();
ResultSet rs;
String queryString = "select * from myTable";
rs = statmt.executeQuery(queryString);
while(rs.hasNext){ //do what you want
}
statmt.close();
con.close();
}catch(Exception se){System.out.println(se.getMessage());};
}
"Untitled1.java": Error #: 750 : initialization error: com.borland.compiler.symtab.LoadError: class file has wrong version 48.0