Hi all, does anyone knows that's the case of this error:
 
This happened when I tried to access MySQL Database from remote client.
 
Regards,
Joe
 

HTTP Status 500 - 

  _____  

type Exception report
message 
description The server encountered an internal error () that prevented
it from fulfilling this request.
exception 
org.apache.jasper.JasperException: com.mysql.jdbc.Driver
...
 
 
 
Here's my code:
 
<%
 
 
            //Step 1com.mysql.jdbc.Driver
             //Class.forName("org.gjt.mm.mysql.Driver");
             Class.forName("org.gjt.mm.mysql.Driver");
             
             //Step 2
             Connection myConn =
DriverManager.getConnection("jdbc:mysql://192.168.1.74/mex", "name",
"password");
             
             //Step 3
             Statement stmt=myConn.createStatement();
             
             //Step 4
             ResultSet myResultSet = stmt.executeQuery("SELECT * FROM
admin");
             
             //Step 6
             if (myResultSet != null)
             {
             
             //Step 7
             while (myResultSet.next())
             {
                        String aid = myResultSet.getString("id");
                        String username =
myResultSet.getString("username");
                        String password =
myResultSet.getString("password");
                        String name = myResultSet.getString("name");
%>
<table border="1" width="400">
<tr>
<td><%=aid%></td>
<td><%=username%></td>
<td><%=password%></td>
<td><%=name%></td>
</tr>
<% //Step 8
            } /* of while */
            } /* of if */
            
            //Step 9 and 10
            myConn.close();
            
            
%>

Reply via email to