Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

"Function sequence error!" what is it mean

 
Huzefa Zohaib
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 9312
10
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic