I am trying the JDBC Driver from http://www.zentus.com/sqlitejdbc/ which seems to be cross linked from SQLite home and others.
I looked at another here: http://www.ch-werner.de/javasqlite/overview-summary.html However, I am not a java guy, and need to figure out how to make the jar file that I need. SQLite is pretty popular, especially for deployed applications to stand alone machines... I am new to it. David, which driver did you use? Thanks, Rob On Oct 22, 9:03 am, Paul Bonfanti <[EMAIL PROTECTED]> wrote: > I agree with Alan. Sounds like it might be an issue with the way they've > implemented the JDBC API. If sqlite supports stored procedures then you could > try doing your updates/inserts in a stored procedure to see if that works > around the issue. > > Paul > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Rob > Sent: Wednesday, October 22, 2008 2:49 PM > To: Open BlueDragon > Subject: [OpenBD] Re: sqlite datasource > > I have also set up the Jetty/OpenBD, and have it running against SQL > Server and MySQL. My goal is a true xCopy installation of my > application, and I am getting closer. I installed Sqlite 3.6.4, and > the sqlitejdbc-v053.jar driver. I verified the SQLite works using the > SQLite2008Pro manager. I am able to perform select statement OK. > When I run an Update or Insert statement, the SQL executes, but throws > a CF error, "no ResultSet available". This actually makes sense, as > there are no results on an update or insert. Any advice? > > Here is the error I get on an update. > Type:Database > Query Error:no ResultSet available > Datasource:SAIL > Native Error Code:0 > SQL StateSQLupdate manufacturers > set name = ?, > comments = ? > where PK_ManufacturerID = ?Tag ContextCFIF: Line=2; Column=1 > | > +-- CFQUERY: Line=3; Column=2Source > 1: <!--- 1234<cfdump> ---> > 2: <cfif action is "Edit"> > 3: <cfquery datasource="#dsn_name#" name="update"> > 4: update manufacturers > 5: set name = <cfqueryparam cfsqltype="cf_sql_varchar" > value="#form.name#">, > ^ Snippet from underlying CFML source > > In the bluedragon.xml, under the query section I have: > > <datasource name="sail"> > <name>sail</name> > <logintimeout>120</logintimeout> > <databasename>sail</databasename> > <initstring></initstring> > <connectionretries>0</connectionretries> > <connectiontimeout>120</connectiontimeout> > <username></username> > <sqlstoredprocedures>true</sqlstoredprocedures> > <hoststring>jdbc:sqlite:/jetty/webroot_cfmlapps/log/sail/ > sail.sqlite</hoststring> > <sqlupdate>true</sqlupdate> > <perrequestconnections>true</perrequestconnections> > <drivername>org.sqlite.JDBC</drivername> > <sqlinsert>true</sqlinsert> > <sqldelete>true</sqldelete> > <password>******</password> > <maxconnections>24</maxconnections> > <sqlselect>true</sqlselect> > </datasource> > > Thanks in advance for your time, > > Rob > > On Aug 28, 10:27 pm, David <[EMAIL PROTECTED]> wrote: > > I did not have the datasource section within a <cfquery> block. I > > missed that when copying and pasting from the commented example. > > Adding this got it going. Thanks for the reply and good suggestion. > > > I am looking forward to the admin console. > > > David > > > > Did you restart Jetty after dropping the jar file in the lib directory? > > > You're probably already aware of this, but when you edit the XML config > > > file manually you also need to restart Jetty for the changes to be > > > picked up. And I assume that the datasource node you pasted in your > > > email is nested in a cfquery node? Do you have databases of other types > > > that are working OK? > > > > It sounds like the jar file is in the right place, but the "need to > > > specify class name" error sounds to me like it isn't finding the classes > > > it needs.sqliteis one of the databases I'm probably going to add to > > > the admin console so I'll give it a shot before long, but I haven't ever > > > used it before, so my apologies that I can't be of more assistance at > > > the moment. > > > > -- > > > Matt Woodward > > > [EMAIL PROTECTED]://www.mattwoodward.com/blog > > > > Please do not send me proprietary file formats such as Word, PowerPoint, > > > etc. as attachments.http://www.gnu.org/philosophy/no-word-attachments.html > > --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official blog @ http://blog.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
