I am just pinging this again to see if anyone is using SQLite with Open BlueDragon. If you are able to successfully run update/insert statements I would greatly appreciate any feedback you have.
Thanks! -JSLucido On Monday, May 13, 2013 8:30:59 AM UTC-5, J.Lucido wrote: > > 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.
