In case you are not aware of it Oracle provides support.
They look up the problem in their database.
You may find that some body else had the same problem
or there is a patch released to resolve that particular bug.
I have Oracle 9i which doesn't necessarily mean that
I have enhancements, there are always bug fixes as well.
I once reported a fault with them and they said they will
fix it in three months then release it
while I had a deadline to meet.
There was a bug on another occasion
and they then turn round to me and said they don't support
Oracle on that particular hardware and Operating system.
I had to write a listener in C++ to get
round the problem because they refused
support on that particular hardware and operating system
even though they released the product.
I never the less had to find a solution.
I suggest you try Oracle because unless somebody
had the same problem it is a guessing game.
Regards,
Zahid
----- Original Message -----
From: "Keith Kwiatek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 31, 2001 7:56 PM
Subject: Re: JSP JDBC bean doesn't seem to release cursor !?
> it is virtually closed, of course it returns it to the pool....
>
> BUT what about my explicit calls for the result set and statement to be
> closed? Why doesn't this immediately release the cursor from the oracle
> database... instead it lingers ....
>
> Keith
>
>
> ----- Original Message -----
> From: "Mattias Jiderhamn" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, July 31, 2001 2:04 AM
> Subject: Re: JSP JDBC bean doesn't seem to release cursor !?
>
>
> > > I am using connection pooling.
> > ...
> > > even though I have issued conn.close() explictedly (?) !
> >
> > If you use a connection pool you should *NOT* close your connection but
> > return it to the pool.
> >
> >
>
===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> DIGEST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
