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 !! -~----------~----~----~----~------~----~------~--~---
