Correct use of PreparedStatements

Article View: comp.lang.java.databases

Article #40

Back to comp.lang.java.databases Previous Next

#40

From: Chris McCarthy
Date: Thu, 09 Jul 1998 00:00

11 lines
1139 bytes

I am wondering what is the recommended way of using PreparedStatements.
I create my prepared statements on startup, and reference them during
execution, I don't close them until the application exits. Is this the
way they should be used ?
   If this is correct, eventually I will run out of available cursors. I
read somewhere that there is a limit of 50 open cursors per connection.
Is this limit imposed by the driver or the DBMS ? I am using the Oracle
Thin driver with 7.3 of Oracle.

Thanks for any suggestions,
..Chris.

Technical Details

Message-ID: <35A4F416.D1853D39@qumas.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 107d46,3308742ef366bb7b,start
X-Google-Attributes: gid107d46,public
X-Google-Thread: 1073da,3308742ef366bb7b,start
X-Google-Attributes: gid1073da,public
From: Chris McCarthy <cmccarthy@qumas.com>
Subject: Correct use of PreparedStatements
Date: 1998/07/09
Message-ID: <35A4F416.D1853D39@qumas.com>
X-Deja-AN: 369927577
Content-Transfer-Encoding: 7bit
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
Organization: Qumas Ltd
Mime-Version: 1.0
Newsgroups: comp.lang.java.databases,borland.public.jbuilder.database