Andy: That is fantastic! My last ditch effort was to create a test case for you and Alan to see if you wanted to take the time and look into the issue but I guess that will not be needed now. Thank you. Thank you.
I actually spent most of the morning messing with H2 as a replacement this morning for the core application since it has been quite some time since I messed with it. I prefer SQLite though since I have three rather large CSV files which I bulk load into SQLite much quicker and more efficiently than H2. I will look forward to giving this a test tomorrow and will report back with results. Thanks again for your help and looking into the issue. Just curious, was the JDBC driver returning something not quite on par? Have a great rest of your weekend. Kind regards, -JSLucido On Sat, May 18, 2013 at 2:38 PM, Andy Wu <[email protected]> wrote: > Jeff, > > I was able to recreate this one locally and found the issue. > > A fix will be in the nightly release. > > Andy > > > On 18/05/2013 09:28, J.Lucido wrote: > > 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<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. > > > > > -- > -- > 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. > > > -- -- 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.
