Hi
Thank you for your reply, but my question is not about how to increase
the number of Oracle cursors my question is about glassfish.
From the link I provided I understood this is a known Glassfish problem,
which is already fixed.
My questions are: Is this correct? And if so where can I get this fix?
Thanks in advance
Sigal
P please consider the environment - do you really need to print this
email?
________________________________
From: Andy.Knight_at_Sun.COM [mailto:Andy.Knight_at_Sun.COM]
Sent: Friday, October 02, 2009 9:03 AM
To: users_at_glassfish.dev.java.net
Subject: Re: Glassfish problem with JDBC connection
A change needs to be made in your Oracle instance.
ALTER SYSTEM SET open_cursors=500 SCOPE=BOTH
The value of 500 is a guess. You may need to vary this.
<
http://www.sun.com>
Andy Knight
Principal Engineer,
Sun Microsystems, Inc.
Java House, Guillemont Park, Minley Road,
Camberley, Surrey GU17 9QG United Kingdom
Home office: +44 1494 462438
Mobile: +44 7775 583415
Skype: aprknight
Email: Andy.Knight_at_Sun.COM
Blog:
http://blogs.sun.com/andky
<
http://www.sun.com>
On 1 Oct 2009, at 19:50, Sigal Shaharabani wrote:
Hello
We are working with Glassfish v2ur2-b04.
We are encountering a problem with Oracle JDBC connection pool - We
receive the Oracle error ORA-01000
Searching the web I noticed here
http://dlc.sun.com/pdf/820-7667/820-7667.pdf
<
http://dlc.sun.com/pdf/820-7667/820-7667.pdf> that this is a known
problem which was fixed for Liferay (search for [LPS-2428]
Is this fix also available in any Glassfish release or patch? (or
expected to be)
Many thanks
Sigal
P please consider the environment - do you really need to print this
email?