OC4j and abnormal exit of stm.executeQuery
From: Antonio (dottavio_at_ised.it)
Date: 03/26/04
- Previous message: Mark D Powell: "Re: Question regardin replacing the value in a column"
- Next in thread: Antonio: "Re: OC4j and abnormal exit of stm.executeQuery"
- Reply: Antonio: "Re: OC4j and abnormal exit of stm.executeQuery"
- Reply: Antonio: "Re: OC4j and abnormal exit of stm.executeQuery"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 26 Mar 2004 06:31:35 -0800
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" );
}
- Previous message: Mark D Powell: "Re: Question regardin replacing the value in a column"
- Next in thread: Antonio: "Re: OC4j and abnormal exit of stm.executeQuery"
- Reply: Antonio: "Re: OC4j and abnormal exit of stm.executeQuery"
- Reply: Antonio: "Re: OC4j and abnormal exit of stm.executeQuery"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
