Re: [sqlite] Statement is not executing

2011-07-05 Thread Stephan Beal
On Tue, Jul 5, 2011 at 11:08 AM, Cecil Westerhof wrote:

> The problem was a Java problem. I use a preparedStatement and for one
> reason
> or another this went wrong after a little more as 2.000 inserts. I now do a
> new preparedStatement every 1.000 inserts.
>

Long Live Garbage Collection.

Did you try running reset() on the statement between each insert? Maybe that
would help free up some resources? Interrupting your loop every 1000
iterations is a hacky workaround which might or might not work on any given
machine (maybe on my machine the threshold is 1200 or 700). i would expend
the effort to look for a real solution, rather than relying on something
like that (i can't sleep at night if i know my software might break at any
second due to hacks like that one).

-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Statement is not executing

2011-07-05 Thread Cecil Westerhof
In case people are wondering. :-D

2011/7/3 Cecil Westerhof 

> I am not sure if it is a SQLite problem, or a Java problem.
>
> While filling a table I get an error "Statement is not executing". It
> happens in the following code:
> System.out.printf("%d, %s, %s\n", line, citation, author);
> prep.setString(1, citation);
> System.out.print("After citation\n");
>
> I see the first output, but not the second. After this there is a -journal
> file. What could be happening here?
>

The problem was a Java problem. I use a preparedStatement and for one reason
or another this went wrong after a little more as 2.000 inserts. I now do a
new preparedStatement every 1.000 inserts.

-- 
Cecil Westerhof
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Statement is not executing

2011-07-03 Thread Cecil Westerhof
2011/7/3 Simon Slavin 

>
> On 3 Jul 2011, at 12:19am, Cecil Westerhof wrote:
>
> > I am not sure if it is a SQLite problem, or a Java problem.
> >
> > While filling a table I get an error "Statement is not executing". It
> > happens in the following code:
> >System.out.printf("%d, %s, %s\n", line, citation, author);
> >prep.setString(1, citation);
> >System.out.print("After citation\n");
> >
> > I see the first output, but not the second. After this there is a
> -journal
> > file. What could be happening here?
>
> The -journal file just means that some program with a SQLite connection
> quit without closing it.  It's a result, rather than a cause, of the program
> crashing.  Do not delete/rename/move the -journal file, since when the
> application is relaunched SQLite will use it to figure out if the database
> is corrupt and needs fixing.
>
> The error text "Statement is not executing" is not anything I've ever seen
> from SQLite, so I suspect you're right and that your problem isn't anything
> to do with SQLite.  But I don't know what 'prep' is in your app.
>

It is java code. prep is of type preparedStatement ("INSERT INTO
storeCitations (citation, name) VALUES (?, ?);") and I am trying to set the
value for citation. The 2005 times before it goes good, but here it goes
wrong. I also put it on a java list. Maybe they can help me.

-- 
Cecil Westerhof
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Statement is not executing

2011-07-02 Thread Simon Slavin

On 3 Jul 2011, at 12:19am, Cecil Westerhof wrote:

> I am not sure if it is a SQLite problem, or a Java problem.
> 
> While filling a table I get an error "Statement is not executing". It
> happens in the following code:
>System.out.printf("%d, %s, %s\n", line, citation, author);
>prep.setString(1, citation);
>System.out.print("After citation\n");
> 
> I see the first output, but not the second. After this there is a -journal
> file. What could be happening here?

The -journal file just means that some program with a SQLite connection quit 
without closing it.  It's a result, rather than a cause, of the program 
crashing.  Do not delete/rename/move the -journal file, since when the 
application is relaunched SQLite will use it to figure out if the database is 
corrupt and needs fixing.

The error text "Statement is not executing" is not anything I've ever seen from 
SQLite, so I suspect you're right and that your problem isn't anything to do 
with SQLite.  But I don't know what 'prep' is in your app.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] statement is not executing

2008-09-01 Thread Javier Julio
I don't want to upset anyone here either since SQLite is a great database
but since you work with CF8 and so do I, I think its safe to say SQLite is
not the answer for you here. Derby offers a lot but why I suggested it is
because it comes out of the box with CF8. You will have more pain setting up
SQLite connectivity then with Derby. Plus you get to use all those
cfqueryparams!

Again don't want to upset anyone here but since I work a lot with CF I think
this is the best call for you. Heck if you paid for a CF8 license you might
as well use everything it has out of the box! I'm thinking it will do you
much better since if it has CF support you won't have to worry about the
drivers. Hope this helps out.

Ciao!
Javi

On Mon, Sep 1, 2008 at 12:06 PM, Greg Morphis <[EMAIL PROTECTED]> wrote:

> Honestly, for S 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)
> >>
> >>  >> returntype="boolean">
> >>
> >>/>
> >>
> >>   
> >>
> >>  datasource="#variables.DSN#">
> >>INSERT INTO
> >>   BILLS
> >>   (
> >>  PAYEEID,
> >>  PAYEE,
> >>  MINIMUMDUE,
> >>  DUEDAY,
> >>  ISCC,
> >>  ISACTIVE,
> >>  AMOUNTOWED,
> >>  APR
> >>   )
> >>VALUES
> >>   (
> >>   >>
> >> value="#arguments.bill.getPayeeID()#"
> >> cfsqltype="cf_sql_numeric" />,
> >>   >>
> value="#arguments.bill.getPayee()#"
> >> cfsqltype="cf_sql_longvarchar"
> />,
> >>   >>
> >> value="#arguments.bill.getMinimumDue()#"
> >> cfsqltype="cf_sql_numeric" />,
> >>   >>
> >> value="#arguments.bill.getDueDay()#"
> >> cfsqltype="cf_sql_longvarchar"
> />,
> >>   >>
> value="#arguments.bill.getIsCC()#"
> >> cfsqltype="cf_sql_numeric" />,
> >>   >>
> >> value="#arguments.bill.getIsActive()#"
> >> cfsqltype="cf_sql_numeric" />,
> >>   >>
> >> value="#arguments.bill.getAmountOwed()#"
> >> cfsqltype="cf_sql_numeric" />,
> >>   >>
> value="#arguments.bill.getAPR()#"
> >> cfsqltype="cf_sql_numeric" />
> >>   )
> >> 
> >>
> >>   
> >>
> >> 
> >>
> >> 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 

Re: [sqlite] statement is not executing

2008-09-01 Thread Greg Morphis
Honestly, for S 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)
>>
>> > returntype="boolean">
>>
>>   
>>
>>   
>>
>> 
>>INSERT INTO
>>   BILLS
>>   (
>>  PAYEEID,
>>  PAYEE,
>>  MINIMUMDUE,
>>  DUEDAY,
>>  ISCC,
>>  ISACTIVE,
>>  AMOUNTOWED,
>>  APR
>>   )
>>VALUES
>>   (
>>  >
>> value="#arguments.bill.getPayeeID()#"
>> cfsqltype="cf_sql_numeric" />,
>>  > value="#arguments.bill.getPayee()#"
>> cfsqltype="cf_sql_longvarchar" />,
>>  >
>> value="#arguments.bill.getMinimumDue()#"
>> cfsqltype="cf_sql_numeric" />,
>>  >
>> value="#arguments.bill.getDueDay()#"
>> cfsqltype="cf_sql_longvarchar" />,
>>  > value="#arguments.bill.getIsCC()#"
>> cfsqltype="cf_sql_numeric" />,
>>  >
>> value="#arguments.bill.getIsActive()#"
>> cfsqltype="cf_sql_numeric" />,
>>  >
>> value="#arguments.bill.getAmountOwed()#"
>> cfsqltype="cf_sql_numeric" />,
>>  > value="#arguments.bill.getAPR()#"
>> cfsqltype="cf_sql_numeric" />
>>   )
>> 
>>
>>   
>>
>> 
>>
>> 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
>> >>  > >>
>> >>  I suppose since this is a local app, I don't need the > >>  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 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

Re: [sqlite] statement is not executing

2008-09-01 Thread Greg Morphis
I rebuilt the table as

CREATE TABLE bills
(
  payeeid integer primary key,
  payee TEXT,
  minimumdue float,
  apr float,
  amountowed float,
  iscc integer DEFAULT 1,
  dueday TEXT,
  isactive integer DEFAULT 1
)



On Mon, Sep 1, 2008 at 10:46 AM, Greg Morphis <[EMAIL PROTECTED]> wrote:
> It's just a simple insert into table (columns) values (values)
>
> 
>
>   
>
>   
>
> 
>INSERT INTO
>   BILLS
>   (
>  PAYEEID,
>  PAYEE,
>  MINIMUMDUE,
>  DUEDAY,
>  ISCC,
>  ISACTIVE,
>  AMOUNTOWED,
>  APR
>   )
>VALUES
>   (
>   value="#arguments.bill.getPayeeID()#"
> cfsqltype="cf_sql_numeric" />,
>   value="#arguments.bill.getPayee()#"
> cfsqltype="cf_sql_longvarchar" />,
>   
> value="#arguments.bill.getMinimumDue()#"
> cfsqltype="cf_sql_numeric" />,
>   value="#arguments.bill.getDueDay()#"
> cfsqltype="cf_sql_longvarchar" />,
>   value="#arguments.bill.getIsCC()#"
> cfsqltype="cf_sql_numeric" />,
>   value="#arguments.bill.getIsActive()#"
> cfsqltype="cf_sql_numeric" />,
>   
> value="#arguments.bill.getAmountOwed()#"
> cfsqltype="cf_sql_numeric" />,
>   value="#arguments.bill.getAPR()#"
> cfsqltype="cf_sql_numeric" />
>   )
> 
>
>   
>
> 
>
> 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
>>>  >>
>>>  I suppose since this is a local app, I don't need the >>  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 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)
>>>  >>  ...
>>>  >>
>>>  >>
>>>  >>
>>>  >>
>>>  >>

Re: [sqlite] statement is not executing

2008-09-01 Thread Javier Julio
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)
>
>  returntype="boolean">
>
>   
>
>   
>
> 
>INSERT INTO
>   BILLS
>   (
>  PAYEEID,
>  PAYEE,
>  MINIMUMDUE,
>  DUEDAY,
>  ISCC,
>  ISACTIVE,
>  AMOUNTOWED,
>  APR
>   )
>VALUES
>   (
>  
> value="#arguments.bill.getPayeeID()#"
> cfsqltype="cf_sql_numeric" />,
>   value="#arguments.bill.getPayee()#"
> cfsqltype="cf_sql_longvarchar" />,
>  
> value="#arguments.bill.getMinimumDue()#"
> cfsqltype="cf_sql_numeric" />,
>  
> value="#arguments.bill.getDueDay()#"
> cfsqltype="cf_sql_longvarchar" />,
>   value="#arguments.bill.getIsCC()#"
> cfsqltype="cf_sql_numeric" />,
>  
> value="#arguments.bill.getIsActive()#"
> cfsqltype="cf_sql_numeric" />,
>  
> value="#arguments.bill.getAmountOwed()#"
> cfsqltype="cf_sql_numeric" />,
>   value="#arguments.bill.getAPR()#"
> cfsqltype="cf_sql_numeric" />
>   )
> 
>
>   
>
> 
>
> 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
> >>   >>
> >>  I suppose since this is a local app, I don't need the  >>  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 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 

Re: [sqlite] statement is not executing

2008-09-01 Thread Greg Morphis
It's just a simple insert into table (columns) values (values)



   

   

 
INSERT INTO
   BILLS
   (
  PAYEEID,
  PAYEE,
  MINIMUMDUE,
  DUEDAY,
  ISCC,
  ISACTIVE,
  AMOUNTOWED,
  APR
   )
VALUES
   (
  , 

  ,
  ,
  ,
  ,
  ,
  ,
  
   )
 

   



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
>>  >
>>  I suppose since this is a local app, I don't need the >  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 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 

Re: [sqlite] statement is not executing

2008-09-01 Thread P Kishor
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
>  
>  I suppose since this is a local app, I don't need the   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 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


Re: [sqlite] statement is not executing

2008-09-01 Thread Greg Morphis
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
 wrote:
> On 9/1/08, Greg Morphis <[EMAIL PROTECTED]> wrote:
>> To further complicate things..  I removed all of the 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


Re: [sqlite] statement is not executing

2008-09-01 Thread P Kishor
On 9/1/08, Greg Morphis <[EMAIL PROTECTED]> wrote:
> To further complicate things..  I removed all of the 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


Re: [sqlite] statement is not executing

2008-09-01 Thread Greg Morphis
To further complicate things..  I removed all of the 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?
>>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] statement is not executing

2008-08-31 Thread Greg Morphis
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?
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users