This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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: 8843
    
    7

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 ]

"blabbing like a narcissistic fool with a superiority complex" ~ N.A.
[How To Ask Questions On JavaRanch]
 
wood burning stoves
 
subject: "Function sequence error!" what is it mean
 
Similar Threads
Connection.prepareStatement is throwing "General Error Exception"
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not
java.sql.SQLException: General error; is occuring
connecting to Webtrends reporting DB using JDBC-ODBC
How to create SQL server2005 database on remote machine using jdbc?