ant-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject 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
Date Thu, 08 Jan 2004 21:26:02 GMT
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: dev@ant.apache.org
        ReportedBy: jwilson@nmcourt.fed.us


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:
[root@james 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: dev-unsubscribe@ant.apache.org
For additional commands, e-mail: dev-help@ant.apache.org


Mime
View raw message