I understand this is a sqlite list, I had hoped that I wasnt the only one using it or trying to use it with ColdFusion.. I've also asked this on a CF list, just hoping somewhere out there is the answer..
Anyways, as I just posted the problem seems to be around the <cfqueryparam tag.. or at least that's part of it. I suppose since this is a local app, I don't need the <cfqueryparam tags, just looking for answers... Thanks On Mon, Sep 1, 2008 at 10:03 AM, P Kishor <[EMAIL PROTECTED]> wrote: > On 9/1/08, Greg Morphis <[EMAIL PROTECTED]> wrote: >> To further complicate things.. I removed all of the <cfqueryparam>s >> and the code works.. I readd them and I get the same >> >> >> Error Executing Database Query. >> statement is not executing >> >> >> The error occurred in >> >> C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\testCF\cfc\myApp\appDAO.cfc: >> line 92 >> >> The Stack Trace looks like : >> >> java.sql.SQLException: statement is not executing >> at org.sqlite.Stmt.checkOpen(Stmt.java:41) >> at org.sqlite.PrepStmt.getUpdateCount(PrepStmt.java:86) >> at >> coldfusion.server.j2ee.sql.JRunStatement.getUpdateCount(JRunStatement.java:277) >> at coldfusion.sql.Executive.getRowSet(Executive.java:513) >> at coldfusion.sql.Executive.executeQuery(Executive.java:1205) >> at coldfusion.sql.Executive.executeQuery(Executive.java:1008) >> at coldfusion.sql.Executive.executeQuery(Executive.java:939) >> ... >> >> >> >> >> >> On Sun, Aug 31, 2008 at 6:03 PM, Greg Morphis <[EMAIL PROTECTED]> wrote: >> > I think it has to do with the JDBC driver I'm using.. I updated to >> > v053 of the sqlitejdbc driver and am still getting the error.. >> > >> > >> > On Sun, Aug 31, 2008 at 5:27 PM, Greg Morphis <[EMAIL PROTECTED]> wrote: >> >> I've got ColdFusion 8 connecting to my SQLite3 database.. >> >> >> >> When I run an insert using CFCs I get the error : >> >> Error Executing Database Query. >> >> statement is not executing >> >> >> >> >> >> What's odd is that the row gets inserted into the table... >> >> If I hit refresh in the browser I get the error that the Primary Key >> >> must be unique.. >> >> >> >> Anyone ever seen this? >> >> >> > > > > Hi Greg, > > (a long time ago I used to use CF circa version 2 and 3). > > As you have yourself identified, the problem seems to be either with > your own queries, examples of which you have not provided in any of > your emails, or in the JDBC driver. Since neither CF nor the JDBC > driver are the focus of this list, you are unlikely to get much > response here... after all, this is a SQLite list, and SQLite seems to > be working fine. > > Perhaps if you were to provide example of your code, the query you are > doing, perhaps someone might be able to point out possible > logic/syntax errors, but other than that, you will likely get more > mileage from either CF list or from the provider of the JDBC driver. > > Fwiw, I have found that the JDBC driver does work fine, but most of my > queries have been rather simple via straight-ahead Java. > > > > -- > Puneet Kishor http://punkish.eidesis.org/ > Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ > Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users