In the past I used the Java SQLite driver from http://www.ch-werner.de, but that was on Windows and not with Open BD. I installed Open BD on my Mac, but reinstalled and am not sure which driver I tried.
On Oct 22, 3:02 pm, Rob <[EMAIL PROTECTED]> wrote: > I am trying the JDBC Driver fromhttp://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 !! -~----------~----~----~----~------~----~------~--~---
