You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ant.apache.org by bu...@apache.org on 2004/07/07 18:20:28 UTC
DO NOT REPLY [Bug 29954] -
Ant attempts to process result sets for SQL statements that do not return result sets, generating CLI0125E function sequence error in DB2
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=29954>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=29954
Ant attempts to process result sets for SQL statements that do not return result sets, generating CLI0125E function sequence error in DB2
------- Additional Comments From jeakins@us.ibm.com 2004-07-07 16:20 -------
Steps to reproduce:
1. Create an SQL script C:/CreateTables.sql with the following statements:
drop table test;
create table test(col1 char(1));
2. Create the following build.xml file. Be sure to adjust the database name
in the url as well as userid and password:
<?xml version="1.0" encoding="UTF-8"?>
<project name="DatabaseLoad" default="main">
<target name="main">
<echo message="Building Database..."/>
<sql
driver="COM.ibm.db2.jdbc.app.DB2Driver"
url="jdbc:db2:MyDataBase"
userid="username"
password="password"
onerror="continue">
<transaction src="C:/CreateTables.sql"/>
</sql>
</target>
</project>
3. Install DB2 8.1 FixPak 6 and Ant 1.6.1. Run with the command:
ant -v -f build.xml
4. To test with earlier DB2 8.1 FixPak releases, you will need to enable CLI
tracing in DB2 and manually review the trace file to verify that the CLI0125E
is indeed occurring, though it is never reported to the end user in FixPak 5
and under. to enable tracing in DB2 CLI, issue the commands:
db2 update cli cfg for section common using TRACE 1
db2 update cli cfg for section common using TRACEFLUSH 1
db2 update cli cfg for section common using TRACEPATHNAME C:\temp
db2 terminate
A .cli trace file will be written to the specified TRACEPATHNAME directory.
This directory must already exist as DB2 will not create it.
Tracing may be disabled using:
db2 update cli cfg for section common using TRACE 0
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@ant.apache.org
For additional commands, e-mail: dev-help@ant.apache.org