Hi everybody,
i am using a JDBC connection to Oracle Lite database.
the driver is oracle.lite.poljdbc.POLJDBCDriver
from file olite40.jar from Mobile Developement Kit which is part of Oracle Lite 9i distribution.

However after obtaining the connection i noticed that following code was not working as expected :

String query = "select a_date from test";
java.sql.PreparedStatement stmt = connection.prepareStatement(query);
java.sql.ResultSet rs = stmt.executeQuery();
if (rs.next()) {
System.out.println("a_date = " + rs.getDate(1));

Well ,
rs.getDate(1) - throws NullPointerException .... which is not ok.

This is the last part of the stack trace :

java.sql.Date oracle.lite.poljdbc.LiteEmbResultSet.jniGetDataDat e(int, int, int)
java.lang.Object oracle.lite.poljdbc.LiteEmbResultSet.getVal(int, int)
java.sql.Date oracle.lite.poljdbc.POLJDBCResultSet.getDate(int)

The field "a_date" from table "test" is DATE database type .

Does anyone noticed this sort of problems about Oracle Lite JDBC access ?
VARCHAR, INTEGER, LONG are ok the only problem is about DATE.