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.
