First, is anyone using SQLite with Open Blue Dragon for quick development local to your workstation? If so, what data access library are you using, if any, to interact with the SQLite database?
I am using the sqlite-jdbc-3.7.2 library from this open source project: https://bitbucket.org/xerial/sqlite-jdbc The project claims it is i JDBC compliant so I figured I could use it when setting up a datasource for my local app (which I did like this: jdbc:sqlite:C:\WebTools\Jetty\webapps\racermgmt\lib\local_db\racermgmt.db). I can run select statements against the database without issue. The problem arises when I try and run insert/update statements against the database. The error I receive is "General SQL Error; Database reported: no ResultSet available" but the update/insert statement ran does in fact succeed. Right now the only way I can utilize this database is to use try/catch statements around my database calls with nothing in the catch statement so the request can continue. The problem is if there truly is an issue with the query outside what I expect (as stated above) I will not catch the error. Is anyone using SQLite and if so are you experiencing this issue? I am running the latest nightly as well as the latest stable release and I am experiencing this issue with the above noted library. Any help/thoughts/recommendations would be greatly appreciated. Kind regards, -JSLucido -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
