Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> JDBC - ERROR: ORA-01000

JDBC - ERROR: ORA-01000

From: Frank Chiu <c4037619_at_comp.polyu.edu.hk>
Date: 23 May 1998 03:17:16 GMT
Message-ID: <01bd8595$5a0dd840$3291849e@frank_k6_200>


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 Fri May 22 1998 - 22:17:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US