Re: 81 SP2 maximum open cursor

[Slava Imeshev]

Please check this:

http://www.viewtier.com/newsgroups/thread.jspa?threadID=4&tstart=0

Regards,

Slava Imeshev

"muktidham muktidham" <noad...@noaddress.given> wrote in message news:1586860.1095696177463.JavaMail.root@jserv5...
> Hi,
>
> We are using weblogic 81 SP2 with oracle oracle 8.1.7 driver. Getting ORA-1000 maximum open cursors in certain scenarios. We have
narrowed down the problem to following code fragment scenario.
>
> public methodA () {
> ...
> for (i going upto 2000) {
> methodB()
> }
> }
>
> public methodB() {
> k = ejbFindByPrimaryKey();
> k.update();
> }
> (methodA and methodB are in session bean and methodB calls a CMP 1.1 bean)
>
> for both methods, container transaction is RequiresNew. Also did JDBC trace logging and found that the prepareStatement() for
SELECT calls due to ejbfindbyprimarykey() method are not being closed by the driver, although prepareStatement() for UPDATE calls
are getting closed. Our OPEN_CURSOR parameter is set to 1000.
>
> This was exact same code running in weblogic 5.1, no cursor problem. Cursors are not being held on in weblogic 5.1.