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

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,

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: > >

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);

[sqlite] Statement is not executing

2011-07-02 Thread 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);

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

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

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

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

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,

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.

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

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 >

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

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

[sqlite] statement is not executing

2008-08-31 Thread Greg Morphis
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