JDBC access to null value in J2EE

From: Yann <lokus44_at_ifrance.com>
Date: 28 Apr 2004 06:14:41 -0700
Message-ID: <9ecf91fd.0404280514.15802192@posting.google.com>

RDBMS Version: 5.0.2.10.0
Operating System and Version: Windows 2000 Pro

I have this error in OC4J 9.0.4.0 :

Unexpected Signal : EXCEPTION_ACCESS_VIOLATION (0xc0000005) occurred at PC=0x80743C1
Function=[Unknown.]
Library=c:\j2sdk1.4.2\jre\bin\client\jvm.dll

NOTE: We are unable to locate the function name symbol for the error just occurred. Please refer to release documentation for possible reason and solutions.

Current Java thread:
at oracle.lite.poljdbc.LiteEmbResultSet.jniGetDataString(Native Method)

at oracle.lite.poljdbc.LiteEmbResultSet.getVal(Unknown Source)
at oracle.lite.poljdbc.POLJDBCResultSet.getString(Unknown Source)
at oracle.lite.poljdbc.POLJDBCResultSet.getString(Unknown Source)

at fr.sigma.projetreference.test.page.TestJDBCServletSTD.doGet(TestJDBCServletSTD.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:765)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)

at java.lang.Thread.run(Thread.java:534)

Dynamic libraries:
0x00400000 - 0x00406000 c:\j2sdk1.4.2\bin\java.exe ......

when i execute this Servlet :

public class TestJDBCServletSTD extends HttpServlet { public void doGet (HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
PrintWriter out;
Properties props = new Properties();

response.setContentType("text/html"); // then write the data of the response
out = response.getWriter();
try {

Class.forName("oracle.lite.poljdbc.POLJDBCDriver");
props.put("user","envstdjava");
props.put("password","envstdjava");

Connection conn = DriverManager.getConnection("jdbc:polite:stdoralite", props);
String requeteSQL = "SELECT CSTD_MENUS.*, TRA_INTITULE, CSTD_TRA.LAN_CODE " + "FROM CSTD_MENUS, CSTD_TRA WHERE MNU_CODEPARENT IS NULL " + "AND CSTD_MENUS.INT_CODE = CSTD_TRA.INT_CODE " + "ORDER BY CSTD_TRA.LAN_CODE, MNU_ORDRE";
PreparedStatement stmtPortail = conn.prepareStatement(requeteSQL); ResultSet rsPortail = stmtPortail.executeQuery(); while (rsPortail.next()) {
out.println(rsPortail.getInt("MNU_CODE") + " - " + rsPortail.getString("MNU_CHEMIN") + "</ br>");
}

rsPortail.close();
stmtPortail.close();
conn.close();
out.println("Ok");
} catch ( Exception e ) {

out.println("Not Ok");
out.println( "Erreur : " + e.getMessage() );
}

out.close();
}
}

When getString() must get NULL value in MNU_CHEMIN column il have the error.

I reproduce the same error with TOMCAT 4.1.19 I reprocude the same error in JDK1.3.1_06 on OC4J 9.0.4.0 and TOMCAT 4.1.19

If i do this in Java Application Console, i have no problem.

Thanks,

Yann. Received on Wed Apr 28 2004 - 08:14:41 CDT