Facebook
Twitter
B
buntyindia
Guest
I Am getting Socket error while using this code whereas this code is working fine on my localTomcat Server.
ERROR
Please Help
Bunty
Code:
<%@ page import = "java.io.*, java.util.*,java.net.URL,java.awt.*,java.lang.*,java.sql.*" %>
<%@ page import="com.mysql.jdbc.Driver" %>
<HTML>
<head></head>
<body>
<%
ResultSet rs;
Statement stmt;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/petrofe","petro", "petro");
String sql = "SELECT * FROM sample";
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while (rs.next())
{
out.println(rs.getString(1));
out.println(rs.getString(2));
}
// Do something with the Connection
} catch (SQLException ex) {
// handle any errors
out.println("SQLException: " + ex.getMessage());
out.println("SQLState: " + ex.getSQLState());
out.println("VendorError: " + ex.getErrorCode());
}
catch (ClassNotFoundException cnfex)
{
out.println("SQLException: " + cnfex.getMessage());
}
%>
</body>
</html>ERROR
Please Help
Bunty