It works on my computer but not on the dedicated server..
Originally Posted by
5tuart
please provide the complete code for the query which is being made?
Code:
int[] resultData = new int[7];
try {
ResultSet results = null;
String query = "SELECT * FROM vb_user WHERE username LIKE '"+username+"'";
try {
if (statement == null) {
statement = connection.createStatement();
}
if (statement.isClosed()) { //line 102 (from the error)
statement = connection.createStatement();
}
} catch (Exception e5) {
statement = null;
connection = null;
createConnection();
statement = connection.createStatement();
e5.printStackTrace();
}
try {
results = statement.executeQuery(query);
} catch (Exception e) {
e.printStackTrace();
}