Nullpointerexception accessing Oracle Database

Suite and Optimus Suite 5
#1

I keep having troubles accessing an Oracle Express 10g Database:

Here the servlet code:

protected void configure() {
Connection conn= ( new DataBaseConnection()).getConnection();
GridConnector c = new GridConnector(conn,DBType.Oracle);
c.dynamic_loading(100);
c.render_sql(“SELECT * FROM SYSTEM.COUNTRIES”, “ID”,“LAND, SPRACHE”);
}

The connection itself is fine, the following query returned correct data:
String sqlQuery = “select * from system.Countries”;
ResultSet rSet = stmt.executeQuery(sqlQuery);
…

Opening the 01a_sql_basic.html-Page, I get a JavaScript-Alert:

java.lang.NullPointerException
…OracleDBDataWrapper.getStatement(OracleDBDataWrapper.java:30)
…DBDataWrapper.query(DBDataWrapper.java:351)
…

Any help is highly appreciated!

LH

#2

The connection itself is fine
Please double-check that next line really provides the valid connection object

Connection conn= ( new DataBaseConnection()).getConnection();

Error, in your case, occurs because the connection object is NULL, and the only way to have such effect - provide NULL instead of valid connection as parameter of connector’s constructor.