aspose file tools
The moose likes JDBC and the fly likes function sequence error in DB2 Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "function sequence error in DB2" Watch "function sequence error in DB2" New topic
Author

function sequence error in DB2

kishore goswami
Greenhorn

Joined: Aug 13, 2003
Posts: 18
Hi all

I am accessing a stored procedure in DB2 which is returning a resultset.
The first time i access the SP ,Iam able to get the resultset and print its values.

but after that for subsequent runs it is giving
db2exception : function sequence error
Iam closing the resultset,statement and connection after each run.

Any help would be greatly appreciated
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 26496
    
  78

Kishore,
Does this happen for all of your user defined functions or just this one? If you don't have any others, try simplifying this one to do a simple query to test this out.

If it only affects this function, you can post the function to see if anyone has an idea.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: function sequence error in DB2
 
Similar Threads
hibernate: could not get next sequence value
How to close ResultSet in a function after returning it
Little hitch trying to use the JDBC tool
DB issue (prepared statement)
How to execute an scalar query ?