Good Morning,
I've a Servlet with inside the doPost() method a connection to a dB,
the problem is that is a long query that work ok if launched on the dB
with something like TOAD and also works well on (JbuilderX + Tomcat)
environment but when deployed on OC4j it happens that during the
execution of
     rs = stm.executeQuery(sSQL);
something appens and the result is that the execution go out of the
doPost() without passing for the catch() or the finally(), after this
the servlet is recharged again.
I can't not figure what is happening, could you help me ???
Thanks

         Antonio D'Ottavio


P.S. :      Here's the code :

   ResultSet rs = null;
   Statement stm = null;
   Connection connR = null;
   try {
     sSQL = getSQLSelect();
     Class.forName("oracle.jdbc.driver.OracleDriver");
     connR = DriverManager.getConnection();
     stm = connR.createStatement();
     rs = stm.executeQuery(sSQL);
     System.out.println("WebStampaRERO - after executeQuery" );
   }
   catch (Exception ex) {
     System.out.println("WebStampaRERO - inside exception" );
     ex.printStackTrace(System.out);
   }
   finally {
     System.out.println("WebStampaRERO - dentro finally" );
     if (rs != null) {
       try {rs.close();} catch (Exception ex) {}
     }
     if (stm != null) {
       try {stm.close();} catch (Exception ex) {}
     }
     if (connR != null) {
       try { connR.close();} catch (Exception ex) {}
     }
   }
   System.out.println("WebStampaRERO - dopo sendTemplate" );
 }