No problem Jeff. I've been meaning to give SQLite a try so this was a
good excuse.
The jdbc driver was behaving differently to other jdbc drivers in that a
call to getResultSet() was throwing an error rather than just returning
null for insert/update executions.
Andy
On 18/05/2013 16:02, Jeff Lucido wrote:
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]
<mailto:[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
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]
<mailto:[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]
<mailto:openbd%[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.
