Re: JDBC - ERROR: ORA-01000

There is an init.ora parameter OPEN_CURSORS or MAX_OPEN_CURSORS that you need to increase to a larger value and then restart the Oracle Instance.

Frank Chiu wrote:

> Hi! All,
>
> I am a Final Year student in Hong Kong Polytechnic University,
> and I am experiencing a technical problem with oracle 7 with JDBC.
>
> I need to build a Client/Server database application with Oracle 7/UNIX,
> with the client-tier is the java applets, and the middle tier is
> the java applications and connect together with JAVA/RMI
> and middle-tier to database tier with JDBC.
>
> I am using a Java Server-side program to connect with the Oracle server,
> and all client are calling the methods in the server end to get result
> sets.
> However, in the server-side program, (ie the middle tier),
> it gets the following error message:
>
> ORA-01000: maximum open cursors exceeded
>
> All SQL and SPs running are just very simple one, with not much data,
> and for any SQL and SPs calling, I do have the ResultSet.close() method run
> to close every my result generate.
>
> I can only perform a few transcations, for more transcations,
> the server side program would prompt out the error describe above.
>
> I believe my limited technical knowledge may find stuck with that,
> and hope any professional here can help me to solve this problems.
> If you have the same experience, also let me know,
> I really need help just becuase the project deadline is coming....
>
> Thanks in advance,
> Frank Chiu
> <c4037619_at_comp.polyu.edu.hk>
Received on Sat May 23 1998 - 18:12:04 CDT