Correct use of PreparedStatements

Thread View: comp.lang.java.databases

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Chris McCarthy Thu, 09 Jul 1998 00:00

#40

Author: 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.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads