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

Reply via email to