Re: OC4j and abnormal exit of stm.executeQuery

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

P.S. : Maybe there is some timeout on servlet in OC4J, I've used

httpSession.setMaxInactiveInterval(10000);

but with no result

"Joe Weinstein" <joeNOSPAM_at_bea.com> ha scritto nel messaggio news:406460E5.4040604_at_bea.com...
>
>
> Antonio wrote:
>
> > 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) {
>
> 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
>
> > 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" );
> > }
>

> Received on Mon Mar 29 2004 - 04:31:52 CST