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();
%>