Re: [sqlite] Statement is not executing
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
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/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
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
[sqlite] Statement is not executing
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? -- 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
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&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) > >> > >> >> 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 deta
Re: [sqlite] statement is not executing
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) >> >> > 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
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
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 coldfusion.sql.Executive.executeQ
Re: [sqlite] statement is not executing
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 the
Re: [sqlite] statement is not executing
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
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
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
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
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
[sqlite] statement is not executing
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