[opencms-dev] nested SQL Exception if connection pool

[Christoph P. Kukulies]

> Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de
> 
> 
> On Fri, Feb 29, 2008 at 05:48:31PM +0100, Jordi Mart? wrote:
> > Wops, my bad:
> > 
> > Connection c;
> > Statement st;
> > ResultSet rs;
> >  try {
> >  	c=getSqlManager()......;
> > 	st=c......
> >  	rs=st....
> >  	}
> >  catch (Exception e) {
> >  	e.printStackTrace();
> >  	}
> >  finally {
> >  	rs.close();
> > 	st.close();
> >  	c.close();
> >  	}
> > 
> > (this is an ugly example, you should do some exception checking, some
> > logging, create managers and dao classes to do all this stuff, blablablabla,
> > ok?).

I got it stable now without the try-catch-finally clause. Ommitting to
close the connection was the culprit.

--
Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de