Java Help - OC4j and abnormal exit of stm.executeQuery

Author

OC4j and abnormal exit of stm.executeQuery

Antonio

2004-03-27, 12:30 am

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" );
}

Antonio

2004-03-29, 6:32 am

Good Morning Joe
first of all thanks for your answer, in any case I've still not solved
this problem,
naturally the getConnection() include the right arguments and the
query is working on a time interval of 9 mounths while is not working
on a greater time interval, I've changed to Throwable ex as you
suggest but the execution do not enter there where that "something
strange" happens, I'm thinking that maybe the virtual machine crash or
something else, have you any idea else ???

Thanks

Antonio D'Ottavio

"Joe Weinstein" <joeNOSPAM@bea.com> ha scritto nel messaggio
news:406460E5.4040604@bea.com...
>
>
> Antonio wrote:
>
>
> That's a mystery to me... If you print out a line just before the
> query, do you get it? I would change the catch (Exception to a
> catch (Throwable ex) to see if maybe you catch that...
> I do hope the real code is similar to this, but includes the right
> arguments to getConnection()...
> Joe Weinstein at BEA
>
>
>

Antonio

2004-03-31, 3:37 am

Problem solved passing from OC4j 9.03 to OC4j 9.0.4 but please don't ask me why,
bye
Antonio

Sponsored Links