Hi, i cant seem to get DB2 data to display on my JSP page. Is it because of my coding or because for the db2driver? Attached below is a copy of my class file.


package WH;

import java.sql.*;
import java.sql.Statement;

public class DbConnect1 {

private String dbUser = "XXX";
private String dbPasswd = "XXX";
private String dbDriver = "COM.ibm.db2.jdbc.app.DB2Driver";
private String dbURL = "jdbc:db2:http://XXXX:8080/invsys";

private Connection dbCon;

public DbConnect1(){}

public boolean connect() throws ClassNotFoundException,SQLException{
try
{
Class.forName(dbDriver);
System.out.println("Loaded the instantDB JDBC driver.");
dbCon = DriverManager.getConnection(dbURL, dbUser, dbPasswd);
System.out.println("Created and connected to database TimingTest");
return true;
}

catch (Throwable e)
{
e.printStackTrace();
System.out.println("FAIL LAHHHHHHHHHHHH");
return false;
}
}

public void close() throws SQLException{
dbCon.close();
}

//accepts the SQL query in the form of a string from the JSP file in which this bean is implemented
public ResultSet execSQL(String sql) throws SQLException{
System.out.println("haha");



//initiates the connection with the dbCon connection object
Statement s = dbCon.createStatement();
ResultSet r = s.executeQuery(sql);
return (r == null) ? null : r;
}

public int updateSQL(String sql) throws SQLException{
Statement s = dbCon.createStatement();
int r = s.executeUpdate(sql);
return (r == 0) ? 0 : r;
}
}