This error is with _no_ CFTRANSACTION. I get a different and far more cryptic error if I put a CFTRANSACTION around it.
I've tested this with the most simplest of inserts and it still breaks. I have exactly the same code and change the datasource from an ODBC connection to a specific database, to a JDBC connection to exactly the same database. It works with ODBC, but not with JDBC. I've checked, and both connections are connecting as exactly the same user, so permissions are not an issue. It fails in exactly the same way for any action that makes a change to the database. Selects all work just fine. I've tested it with the very latest JDBC driver from IBM and also with the previous version (the only other version available). Both behave the same way. I've now run out of things I can think of doing. Darren Tracey JDBC road-kill > -----Original Message----- > From: Steve Onnis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 10 March 2004 4:41 PM > To: CFAussie Mailing List > Subject: [cfaussie] RE: JDBC SQL problems > > > have you got a CFTRANSACTION around it at all? > > Steve > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Darren > Tracey > Sent: Wednesday, March 10, 2004 5:05 PM > To: CFAussie Mailing List > Subject: [cfaussie] JDBC SQL problems > > > I'm converting all my SQL to use a JDBC datasource instead of > the original > ODBC datasources, to avoid the mysterious server crashes as > detailed in > other threads. > With the modifications I explained in my original emails, all > my SELECT > statements work fine. > Every single insert, update and delete statement causes this error: > ------------------------------------------------------ > Error Executing Database Query. > Method can be called only once. The error occurred in > D:\Inetpub\wwwroot\Development\APPName\dirname\templateName.cf > m: line 55 > 53 : DELETE FROM table1 > 54 : WHERE field1='#VARIABLES.field1val#' > 55 : AND field2='#VARIABLES.field2val#' > 56 : </CFQUERY> > 57 : <CFELSE> > > SQL DELETE FROM table1 WHERE field1='xx' AND field2='yy' > DATASOURCE DARREN > VENDORERRORCODE -79782 > SQLSTATE IX000 > Please try the following: > ------------------------------------------------------ > > This page: > > http://www-306.ibm.com/software/data/informix/pubs/library/not es/relnotes/JD BCdr20.html tells me this about this error code: -79782 Method can be called only once Make sure methods like Statement.getUpdateCount() and Statement.getResultSet() are called only once per result. I am not doing either of these things, and if CF is, then there's not much I can do about it (is there?). Help!!!! Any ideas? Regards Darren Tracey JDBC victim --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
