java servlet database connection error
hey,
i have tested database connection using normal java application and it works, so i moved on to test the database connection for servlets because i need to create a mobile application that goes through the servlets to the sql server database.
below is a sample code i got from other sources:
import java.io.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class getConnection extends HttpServlet {
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= "Northwind";
private final String userName = "sa";
private final String password = "";
private String getConnectionUrl(){
return url+serverName+":"+portNumber+";databaseName="+databaseName;
}
public void init() {
}
public void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException,
IOException {
String message = "";
try {
connect(userName.trim(),
password.trim());
message += "100 ok";
} catch (Throwable t) {
message += "200 " + t.toString();
}
response.setContentType("text/plain");
response.setContentLength(message.length());
PrintWriter out = response.getWriter();
out.println(message);
out.close();
out.flush();
}
public void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException,
IOException {
doPost(request,response);
}
private void connect(String user,String pwd)
throws Exception {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = java.sql.DriverManager.getConnection(getConnectionUrl(),user,pwd);
}
}
i always get the 200 java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver as the output from my midlet and not 100 ok.
please help me out, thanks alot.
