Hi, I'm a developer in the eclipsesql project on sourceforge. SQLExplorer is a SQL plugin for eclipse. We try to support as much as possible JDBC drivers. Currently I had a problem with your SQLite JDBC driver. While using the JDBC API we don't worry about a SQL database can handle multiple result sets or not. After we checked the first result set we call getMoreResults and after that getUpdateCount to check if we've got all results/update counts. The Stmt class implements this in a correct way. If we use a PrepStmt it is broken. I think the call to checkOpen should come after checking the pointer (which is reset on the preceeding getMoreResults call). For us the solution was to switch back to 'normal' statements. Nevertheless this seems to be a bug.
--~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
