surprise!

> I didn't download the driver yet. and not set the

> class for the driver, how come I can use my java

> servelet programmer to access, search the datbase by

> localhost. do I realy need JDBC driver?

Your JDBC driver is probably packaged in your web application in the WEB-INF/lib.

I wouldn't be surprised unless you provide more information.

aniseeda at 2007-7-13 19:09:24 >

Hi all,

now I have the following classpath

.;D:\Servlets+JSP;D:\jakarta-tomcat-5.5.9\common\lib\servlet-api.jar;D:\jakarta-tomcat-5.5.9\common\lib\jsp-api.jar;D:\ jdk1.5.0_06\lib\tools.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar [ /code]

my programmer under tomcat work fine , but my client code not work I got java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

at java.net.URLClassLoader$1.run(Unknown Source) why[code]import java.sql.*;

public class connect{

private java.sql.Connection con = null;

private final String url = "jdbc:microsoft:sqlserver://";

private final String serverName= "localhost";

private final String portNumber = "1433";

private final String databaseName= "pubs";

private final String userName = "test";

private final String password = "1234";

// Informs the driver to use server a side-cursor,

// which permits more than one active statement

// on a connection.

private final String selectMethod = "cursor";

// Constructor

public 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

*/

public void 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;

}

private void closeConnection(){

try{

if(con!=null)

con.close();

con=null;

}catch(Exception e){

e.printStackTrace();

}

}

public static void main(String[] args) throws Exception

{

connect myDbTest = new connect();

myDbTest.displayDbProperties();

}

}

TMarya at 2007-7-13 19:09:24 >