Honestly, for S&G mainly.. I have been using Postgres and I don't need that kind of power or resources tied up for a simple app. I suppose I could use MySQL but it's a simple DB.. I like using SQLite and would love to get this to work..
I'll look into Apache Derby.. I know nothing of it however On Mon, Sep 1, 2008 at 10:52 AM, Javier Julio <[EMAIL PROTECTED]> wrote: > Greg, > > I'm sorry to hear about the troubles you are running into. I've been using > SQLite since I've been doing AIR development although my real bread and > butter is CF development. I've never seen anyone connect CF8 and SQLite and > am wondering why you have chosen that? The reason I ask is CF8 comes with > Derby embedded and I would think that would be the best answer for you. > Sorry I can't help any further. > > Ciao! > Javi > > On Mon, Sep 1, 2008 at 11:46 AM, Greg Morphis <[EMAIL PROTECTED]> wrote: > >> It's just a simple insert into table (columns) values (values).... >> >> <cffunction name="create" access="public" output="false" >> returntype="boolean"> >> >> <cfargument name="bill" required="true" type="Bills" hint="Bills bean" /> >> >> <cfset var qCreateBill = "" /> >> >> <cfquery name="qCreateBill" datasource="#variables.DSN#"> >> INSERT INTO >> BILLS >> ( >> PAYEEID, >> PAYEE, >> MINIMUMDUE, >> DUEDAY, >> ISCC, >> ISACTIVE, >> AMOUNTOWED, >> APR >> ) >> VALUES >> ( >> <cfqueryparam >> >> value="#arguments.bill.getPayeeID()#" >> cfsqltype="cf_sql_numeric" />, >> <cfqueryparam >> value="#arguments.bill.getPayee()#" >> cfsqltype="cf_sql_longvarchar" />, >> <cfqueryparam >> >> value="#arguments.bill.getMinimumDue()#" >> cfsqltype="cf_sql_numeric" />, >> <cfqueryparam >> >> value="#arguments.bill.getDueDay()#" >> cfsqltype="cf_sql_longvarchar" />, >> <cfqueryparam >> value="#arguments.bill.getIsCC()#" >> cfsqltype="cf_sql_numeric" />, >> <cfqueryparam >> >> value="#arguments.bill.getIsActive()#" >> cfsqltype="cf_sql_numeric" />, >> <cfqueryparam >> >> value="#arguments.bill.getAmountOwed()#" >> cfsqltype="cf_sql_numeric" />, >> <cfqueryparam >> value="#arguments.bill.getAPR()#" >> cfsqltype="cf_sql_numeric" /> >> ) >> </cfquery> >> >> <cfreturn true /> >> >> </cffunction> >> >> and the DB looks like.. >> >> CREATE TABLE bills >> ( >> payeeid integer primary key, >> payee TEXT, >> minimumdue numeric, >> apr numeric, >> amountowed real, >> iscc numeric DEFAULT 1, >> dueday TEXT, >> isactive numeric DEFAULT 1 >> ) >> >> >> >> >> >> >> >> On Mon, Sep 1, 2008 at 10:24 AM, P Kishor <[EMAIL PROTECTED]> wrote: >> > On 9/1/08, Greg Morphis <[EMAIL PROTECTED]> wrote: >> >> 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.. >> > >> > No, no... don't get me wrong. There is no problem with describing the >> > tools you are using (CF and JDBC driver, in this case). However, you >> > have given no other context... no db schema, no example code, the >> > query you are executing, etc. There is little here for anyone to try >> > and help, other than if there happens to be another CF/SQLite/JDBC >> > user. >> > >> > Just offer more details, and you have a slightly better chance of >> > getting a meaningful reply. >> > >> >> >> >> 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 >> >> > >> >> >> > >> > >> > -- >> > 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 >> > _______________________________________________ > 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