function sequence error

[dendog]

what is a function sequence error and how is it caused. How do i go about fixing it. It occurrs in a jsp when i try to access a visual foxpro database. It usually occurs when i try to call the next method on a result set or the getString method.Thank you fro your help.

 

[manu0]

hi

I think that such errors arise when the driver is not able to handle correctly some JDBC calls...

I used to encounter this error when accessing some special column types in my requests such TEXT (or MEMO = a large text), and so on...

I noticed that we can overcome this using different kinds of statements : by exemple with my driver I can't use a PreparedStatement for a SELECT query, so I use a Statement.

But for a UPDATE/DELETE query i don't use a Statement object but a PreparedStatement...

As i use a JDBC 1.0 driver, I have always succeded to overcome all the errors of the driver by using different objects or method calls... manu0

 

[jdemmi]

Are you saying this only happens with JDBC? I have an app which uses ODBC and these errors are being generated in a DB log file. Is it possible some outside source is connecting to the same DB with JDBC?

 

[pipk]

basically it means you are not closing down your jdbc connection properly.

you open a connection for your query but you must also close it once you have finished with that query.

I had this happen to me and as soon as i added the correct directives at the end of my SQL processing it was fine.