Thread: [Squirrel-sql-users] Informix: Method can be called only once. / ErrorCode: -79782
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: <ep...@we...> - 2010-03-19 17:25:21
|
I'm using SQL Squirrel against an Informix 11 database. For every *successful* query I run I see the following in the error console. Error: Method can be called only once. SQLState: IX000 ErrorCode: -79782 Position: 1 I do get back the expected query results, and this error does not appear if I have another error w/my query (e.g., syntax, etc.) I'm running SQL Squirel 3.1. Informix driver: ifxjdbc-3.50-JC3.jar Just wanted to post this in case there's a known solution or if I need to file a bug report. FYI. I found this on IBM's site (for an older version of the driver): http://www-01.ibm.com/software/data/informix/pubs/library/notes/relnotes/JDBCdr20.html "-79782 Method can be called only once Make sure methods like Statement.getUpdateCount() and Statement.getResultSet() are called only once per result." Thanks, Eric P. |
From: <ep...@we...> - 2010-03-19 21:31:18
|
This problem seems to be related to SQL SQuirreL not the JDBC driver. With the exact same JDBC Informix driver as below this problem does not exist in SQL SQuirreL 2.6. Thanks, Eric P. From: ep...@we... To: squ...@li... Date: 03/19/2010 12:25 PM Subject: [Squirrel-sql-users] Informix: Method can be called only once. / ErrorCode: -79782 I'm using SQL Squirrel against an Informix 11 database. For every *successful* query I run I see the following in the error console. Error: Method can be called only once. SQLState: IX000 ErrorCode: -79782 Position: 1 I do get back the expected query results, and this error does not appear if I have another error w/my query (e.g., syntax, etc.) I'm running SQL Squirel 3.1. Informix driver: ifxjdbc-3.50-JC3.jar Just wanted to post this in case there's a known solution or if I need to file a bug report. FYI. I found this on IBM's site (for an older version of the driver): http://www-01.ibm.com/software/data/informix/pubs/library/notes/relnotes/JDBCdr20.html "-79782 Method can be called only once Make sure methods like Statement.getUpdateCount() and Statement.getResultSet() are called only once per result." Thanks, Eric P. ------------------------------------------------------------------------------ |
From: Robert M. <rob...@gm...> - 2010-03-20 02:10:23
|
Eric, Yes - that is our bug, I believe. The javadocs here: http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html#getUpdateCount%28%29 say to only call getUpdateCount once per result. We are doing that more often than once per result. Please enter a bug report here: https://sourceforge.net/tracker/?group_id=28383&atid=393414 Thank you, Rob On Fri, Mar 19, 2010 at 12:09 PM, <ep...@we...> wrote: > I'm using SQL Squirrel against an Informix 11 database. > > For every *successful* query I run I see the following in the error console. > Error: Method can be called only once. > SQLState: IX000 > ErrorCode: -79782 > Position: 1 > > I do get back the expected query results, and this error does not appear if > I have another error w/my query (e.g., syntax, etc.) > > I'm running SQL Squirel 3.1. > > Informix driver: > ifxjdbc-3.50-JC3.jar > > > Just wanted to post this in case there's a known solution or if I need to > file a bug report. > > > FYI. I found this on IBM's site (for an older version of the driver): > http://www-01.ibm.com/software/data/informix/pubs/library/notes/relnotes/JDBCdr20.html > "-79782 Method can be called only once > > Make sure methods like Statement.getUpdateCount() and > Statement.getResultSet() are called only once per result." > > Thanks, > Eric P. > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
From: <ep...@we...> - 2010-03-22 13:10:50
|
Filed. https://sourceforge.net/tracker/?func=detail&aid=2974533&group_id=28383&atid=393414 Thanks, Eric P. From: Robert Manning <rob...@gm...> To: ep...@we... Cc: squ...@li... Date: 03/19/2010 09:09 PM Subject: Re: [Squirrel-sql-users] Informix: Method can be called only once. / ErrorCode: -79782 Eric, Yes - that is our bug, I believe. The javadocs here: http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html#getUpdateCount%28%29 say to only call getUpdateCount once per result. We are doing that more often than once per result. Please enter a bug report here: https://sourceforge.net/tracker/?group_id=28383&atid=393414 Thank you, Rob On Fri, Mar 19, 2010 at 12:09 PM, <ep...@we...> wrote: > I'm using SQL Squirrel against an Informix 11 database. > > For every *successful* query I run I see the following in the error console. > Error: Method can be called only once. > SQLState: IX000 > ErrorCode: -79782 > Position: 1 > > I do get back the expected query results, and this error does not appear if > I have another error w/my query (e.g., syntax, etc.) > > I'm running SQL Squirel 3.1. > > Informix driver: > ifxjdbc-3.50-JC3.jar > > > Just wanted to post this in case there's a known solution or if I need to > file a bug report. > > > FYI. I found this on IBM's site (for an older version of the driver): > http://www-01.ibm.com/software/data/informix/pubs/library/notes/relnotes/JDBCdr20.html > "-79782 Method can be called only once > > Make sure methods like Statement.getUpdateCount() and > Statement.getResultSet() are called only once per result." > > Thanks, > Eric P. > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |