• Post Reply Bookmark Topic Watch Topic
  • New Topic

how to close unused open cursors

 
partho mukherjee
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
can we directly close the cursor declared in a CallableStatement without assinging it to a ResultSet?
 
Jesper de Jong
Java Cowboy
Sheriff
Posts: 15758
74
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This question is not about SCJP.
Moving to JDBC forum.
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36007
422
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Partho,
What Java object are you referring to? We have a Connection, CallableStatement and ResultSet object. Doesn't the ResultSet refer to the cursor?
 
partho mukherjee
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I was referring to the Callablestatement object. I found that it has a method getParameterMetaData() in JDBC 3.0 which gives me some information about the parameters(in and out) declared in the CallableStatement.
But do we have anyway to refer to the parameters in a generic way if I am using an older version of JDBC?
I want to close all open cursors without having to refer to the ResultSet, i.e I have only the CallableStatement object at my disposal. Is there any way?
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!