Does anybody have any idea about this problem?
________________________________
From: Sigal Shaharabani [mailto:Sigal.Shaharabani_at_Teledata-Networks.com]
Sent: Sunday, October 04, 2009 10:02 AM
To: users_at_glassfish.dev.java.net
Subject: RE: Glassfish problem with JDBC connection
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?