File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes CallableStatement (Oracle JDBC) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "CallableStatement (Oracle JDBC)" Watch "CallableStatement (Oracle JDBC)" New topic

CallableStatement (Oracle JDBC)

Phyllis @systemetrix

Joined: Mar 08, 2005
Posts: 2
The close of the CallableStatement and the Connection are leaving open cursors in my database. Any ideas what I can do to tighten up the code so that the cursors are closed?

Is there another route other than callablestatement? The call is to a procedure within a package that has an output parameter.

Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63053

"Phyllis @systemetrix",

We're pleased to have you here with us on the Ranch, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Forum Bartender

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1138

If your "CallableStatement" is returning a "ResultSet", I suggest you also close the "ResultSet" -- preferrably in the following order:
  • ResultSet
  • CallableStatement
  • Connection

  • Good Luck,
    I agree. Here's the link:
    subject: CallableStatement (Oracle JDBC)
    It's not a secret anymore!