File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and Relational Databases and the fly likes Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark ""Function sequence error!" what is it mean" Watch ""Function sequence error!" what is it mean" New topic
Author

"Function sequence error!" what is it mean

Huzefa Zohaib
Ranch Hand

Joined: Nov 21, 2001
Posts: 40
The following Exception
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Function sequence error
is occuring on the following code.
What does this error means and why is occuring.
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 9126
    
    9

What the "function sequence error" means is that the sequence of opening a statement, initalizing a result set, reading the result set (most often from beginning to end, from left to right) and releasing resources has not been performed in the proper order. I've seen this exception when someone tries to read from a result set before calling rs.next().
[/qb]<hr></blockquote>
This may be the offending code. Closing the statement also may release the result set. However, you should not rely on it and close both after you are finished with them.
[ October 06, 2003: Message edited by: Joe Ess ]

[How To Ask Questions On JavaRanch]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: "Function sequence error!" what is it mean
 
It's not a secret anymore!