| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: coding cursors in Java
Example:
Statement stmt = con.createStatement();
:
:
stmt.close();
HTP.
Gunawan Yuwono
Oracle DBA
Kansas City, MO
>--- Original Message ---
>From: Kimberly.smith_at_gmd.fujitsu.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: 7/18/00 4:10:13 PM
>
>Actually we figured it out after I sent out this e-mail. You
have to make
>sure you close your statement after. They were doing it in
the wrong spot
>in this particular case. Well I just tried finding the java
dudes but they
>all seem to be missing. Maybe someone else out there can send
you the
>syntax. If not e-mail me directly and I will try and get a
snippet of code.
>
>-----Original Message-----
>aheda_at_cdotd.ernet.in
>Sent: Monday, July 17, 2000 11:34 PM
>To: Multiple recipients of list ORACLE-L
>
>
>I am also facing the same problem of too many open cursors with
cdoing in
>the jbuilder.It would be of great help if somebody could tell
whaT is the
>reason of it and why are the implicit cursors not closed or
freed by
>themselves when there scope is over.
>
>
>
>Arvind
>
>
>On Mon, 17 Jul 2000 uucp-relay-delhi!Kimberly.smith_at_gmd.fujitsu.com
wrote:
>
>> We are using JBuilder 3 to code Java. Right now everything
is implicit
>> cursors
>> and that is causing issues with the ORA-01000 to many open
cursors error.
>> Now I
>> know I can change the open_cursors parameter but that really
does not fix
>> the problem,
>> not to mention the fact I cannot bring down the database for
a couple of
>> weeks.
>> Does anyone know how to code using explicit cursors in java.
>>
>>
>> ---------------------------------------------
>> Kimberly Smith
>> EDS/Fujitsu GMD
>> 21015 SE Stark St
>> Gresham, OR
>> 97030
>> E-Mail: kimberly.smith_at_gmd.fujitsu.com or
>> kimberly.smith_at_eds.com
>> Phone : (503) 669-6050
>> Fax : (503) 669-5705
>>
>> --
>> Author:
>> INET: Kimberly.smith_at_gmd.fujitsu.com
>>
>> Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
>> San Diego, California -- Public Internet access / Mailing
Lists
>> --------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail
message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from).
You may
>> also send the HELP command for other information (like subscribing).
>>
>>
>
>
>--
>Author:
> INET: aheda_at_cdotd.ernet.in
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing
Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).
You may
>also send the HELP command for other information (like subscribing).
>
>--
>Author:
> INET: Kimberly.smith_at_gmd.fujitsu.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing
Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).
You may
>also send the HELP command for other information (like subscribing).
>
>
 |
 |