Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#845 Informix: Method can be called only once. / ErrorCode: -79

3.1
closed-fixed
Rob Manning
Core (461)
5
2010-03-24
2010-03-22
Eric Pierce
No

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

According to Rob Manning, SQL SQuirreL is calling 'getUpdateCount' more than once in per result and it sounds like maybe it should not be doing so (?)
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html#getUpdateCount%28%29

Running Informix driver:
ifxjdbc-3.50-JC3.jar

Running SQL SQuireL 3.1. FYI. I have verified that this issue does *not* exist in SQL SQuireL 2.6 w/the same Informix driver.

Related thread in mailing list.
https://sourceforge.net/mailarchive/forum.php?thread_name=3f0fe3d21003191910n72900b9es192d2f9b79df4075%40mail.gmail.com&forum_name=squirrel-sql-users

Thanks,
Eric P.

Discussion

  • Rob Manning
    Rob Manning
    2010-03-24

    Fixed in CVS. The change will be available in the next snapshot and/or stable release.

     
  • Rob Manning
    Rob Manning
    2010-03-24

    • labels: --> Core
    • milestone: --> 3.1
    • assigned_to: nobody --> manningr
    • status: open --> closed-fixed