We have set up datanucleus in weblogic 10.3 using the jca-connector datanucleus-jca.rar
We use datasources and the thin Oracle jdbc-driver.

We execute an sql-query like this:

  Query query = pm.newQuery("javax.jdo.query.SQL", "SELECT DISTINCT USAGE FROM
                              DOCUMENTSOORT ORDER BY USAGE");
  results = (Collection) query.execute();

In the line 'query.execute()', we get a NullPointerException in the method getMetadata() of class weblogic.jdbc.wrapper.ResultSet.

After some investigation, I found that the resultset (java.sql.ResultSet rs) was reset because the resultset was created in another thread (and transaction) than the current thread.

The creation of the resultset is done in org.datanucleus.store.rdbms.query.SQLQuery, method performExecute(Map parameters): (lines 275)
     // Execute the query as a task so we can allow timeout/cancel
     ResultSet rs = (ResultSet)performExecuteTask(new Object[] {sqlControl, mconn, ps});


I changed this lines to the following, and then the query is executed

             ResultSet rs;
             try
               {
                  rs = sqlControl.executeStatementQuery(mconn, compiledSQL, ps);
               }
             catch (SQLException sqle)
               {
                  throw new NucleusDataStoreException(LOCALISER.msg("059025", compiledSQL), sqle);
               }


If you need more information, do not hesitate to ask.

Frank