Hey folks, first off let me quickly say that this is the coolest site I have ever found in my life! Ive learned more here in two weeks than I have in 6 months of school!! Keep it up. On to the dynamite. Ive just gotten
Tomcat 3.2 installed & running on my win98 machine (thanks to Jimi Rock) I also have succesfully installed Mysql & have the server configured, running & tables created. I downloaded the driver & installed accordingly (I think). Im using this JdbcServletCheckup
servlet that we used in school to attempt the connection between the two apps. When I call the servlet it shuts tomcat right down.........BOOM, closes the window, no errors to read..nothing. The dent in my forehead from banging my head on the desk is getting a tad big so I hope to heaven someone here knows what to do. Im used to win NT, javaweserver1.1 & Oracle 8ai so this stuff is brandy new to me. Im posting the whole code from this servlet so there isnt any confusion about what its doing. Thanks a million fold to any of you willing to help out.
/**************************************
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class JdbcServletCheckup extends HttpServlet {
private static void loadJDBCDriver () {
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
}
catch (Exception e) {
System.err.println (e.getMessage ());
System.exit (1); // Driver error
}
}
private static Connection getConnected () {
try {
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/intLovers");
return conn;
}
catch (SQLException e) {
System.err.println (e.getMessage () ) ;
System.exit (1); // Driver failure
}
return null;// never happen
}
private static Statement makeStatement (Connection conn) {
try {
Statement stmt = conn.createStatement ();
return stmt;
}
catch (SQLException e) {
System.err.println (e.getMessage () ) ;
System.exit (2); // Driver failure
}
return null;// never happen
}
private static ResultSet openResultSet (Statement stmt,
String query) {
try {
ResultSet rs = stmt.executeQuery (query);
return rs;
}
catch (SQLException e) {
System.err.println (e.getMessage () ) ;
System.exit (3); // ResultSet error
}
return null;// never happen
}
private static void processResultSet (ServletOutputStream out, ResultSet rs) {
try {
while (rs.next() ) {
out.println("Username: " +rs.getString(1) + " ");
out.println("Password: " +rs.getString(2) + " ");
out.println("Member Status: "+rs.getInt(3)+ " ");
out.println("Email Address: " +rs.getString(4)+ " ");
out.println("gender: " +rs.getInt(5)+ " ");
out.println("Verified? " +rs.getInt(6)+ " ");
out.println("sign-up date: " +rs.getString(7)+ " ");
out.println("Logged On? " +rs.getInt(8)+ " ");
}
}
catch (IOException e) {
System.err.println (e.getMessage () ) ;
System.exit (4); // Output error
}
catch (SQLException e) {
System.err.println (e.getMessage () ) ;
System.exit (5); // Processing error
}
}
private static void closeThingsDown (ResultSet rs, Statement stmt, Connection conn) {
try {
rs.close();
stmt.close ();
conn.close();
}
catch (SQLException e) {
System.err.println (e.getMessage () ) ;
System.exit (5); // Closure failure
}
}
public void doGet (HttpServletRequest request, HttpServletResponse response)
{
try {
loadJDBCDriver ();
Connection conn = getConnected ();
Statement stmt = makeStatement (conn);
response.setContentType ("text/html");
ServletOutputStream out = response.getOutputStream();
String query = "SELECT * FROM mastMem";
out.println ("<HTML><BODY>");
out.println ("<HEAD><TITLE>
JDBC SERVLET
TEST</TITLE></HEAD>");
ResultSet rs = openResultSet (stmt, query);
processResultSet (out, rs);// print results as xml
closeThingsDown (rs, stmt, conn);// close db stuff
out.println ("</BODY></HTML>");
}
catch (IOException e) {
System.err.println (e.getMessage () );
}
}
public void doPost (HttpServletRequest request, HttpServletResponse response) {
doGet (request, response);
}
}
[This message has been edited by DC Dalton (edited June 18, 2001).]
[This message has been edited by DC Dalton (edited June 18, 2001).]
