You are viewing a plain text version of this content. The canonical link for it is here.

Posted to slide-dev@jakarta.apache.org by "Pan, Jiantao" <ji...@labbook.com> on 2001/03/16 23:49:46 UTC

Too many open cursor problem

We have tried to use slide agaist oracle.
And found out there is a problem with too many opened cursors.
It seems that this is because in JDBCDescriptorStore, after each 
statement.execute(s); 
There is no statement.close();
Furthermore. it will be better to have 
resultset.close();
statement.close(); 
in finally block so that we always close after using one.

Thanks and have a good weekend.

Re: Too many open cursor problem

Posted by Remy Maucherat <re...@betaversion.org>.

Quoting "Pan, Jiantao" <ji...@labbook.com>:

> We have tried to use slide agaist oracle.
> And found out there is a problem with too many opened cursors.
> It seems that this is because in JDBCDescriptorStore, after each 
> statement.execute(s); 
> There is no statement.close();
> Furthermore. it will be better to have 
> resultset.close();
> statement.close(); 
> in finally block so that we always close after using one.

Yes indeed. Thanks.

Remy