DO NOT REPLY [Bug 26000] New: - sql task always fails ever since Ant 1.5.4 -- java.sql.SQLException: Method can be called only once

[bugzilla]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=26000>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=26000

sql task always fails ever since Ant 1.5.4 -- java.sql.SQLException: Method can 
be called only once

           Summary: sql task always fails ever since Ant 1.5.4 --
                    java.sql.SQLException: Method can be called only once
           Product: Ant
           Version: 1.7Alpha (nightly)
          Platform: Other
        OS/Version: All
            Status: NEW
          Severity: Major
          Priority: Other
         Component: Core tasks
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


Here is the build file:

<project name="ACE-Fix-Scanned-DocumentTypeIds" default="main" basedir=".">

        <property name="driver" value="com.informix.jdbc.IfxDriver"/>
        <property name="url"
value="jdbc:informix-sqli://raventest:3305/usdcdeuce:InformixServer=raventest_tcp"/>
        <property name="userid" value="informix"/>
        <property name="password" value="ifmx2251"/>

        <property name="jdbcdriverlocation"
location="/packages/apache/jakarta/tomcat/shared/lib/xeuce_ifxjdbc.jar"/>

        <target name="main">
                <sql
                        driver="${driver}"
                        url="${url}"
                        userid="${userid}"
                        password="${password}"
                        classpath="${jdbcdriverlocation}"
                        print="true">
                        <transaction>
                                UPDATE
                                        tbldocument
                                SET
                                        tbldocument.doctypeid = 50
                                WHERE
                                        tbldocument.documentid IN
                                                (SELECT
                                                        t2.documentid
                                                FROM
                                                        tbldocumentcase t2,
                                                        tbldocketentry t3
                                                WHERE
                                                        t2.caseid = t3.caseid 
AND
                                                        t2.documentid = 
t3.documentid AND
                                                        t2.documentid = 
tbldocument.documentid AND
                                                        tbldocument.doctypeid = 
67 AND
                                                        t3.eventid IN (317, 
425)) ;
                        </transaction>
                </sql>
        </target>
</project>

Here is the result:
[EMAIL PROTECTED] ACE-Fix-Scanned-DocumentTypeIds]# ant
Buildfile: build.xml
 
main:
      [sql] Executing commands
      [sql] Failed to execute:   UPDATE tbldocument SET tbldocument.doctypeid =
50 WHERE tbldocument.documentid IN (SELECT t2.documentid FROM tbldocumentcase
t2, tbldocketentry t3 WHERE t2.caseid = t3.caseid AND t2.documentid =
t3.documentid AND t2.documentid = tbldocument.documentid AND
tbldocument.doctypeid = 67 AND t3.eventid IN (317, 425))
 
BUILD FAILED
/projects/jbuilder/ACE-Fix-Scanned-DocumentTypeIds/build.xml:21:
java.sql.SQLException: Method can be called only once.
 
Total time: 26 seconds


All sql tasks using 1.6.0 and 1.7alpha, no matter what the sql, does not work
with this informix jdbc driver.  However, 1.5.4 runs perfectly.  :(

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]