在ant上执行SQL server的存储过程, 事务不会自动提交, </sql> task中autoCommit默认是false, 所以必须设为true才能避免下列问题.
10/30/12 13:44:10.336 INFO: [ProcessWrapper] Executing: D:\DataSynapse\Engine\resources\win64\wrappid.exe,D:\DataSynapse\Engine\work\Jessica-PC-0\antcall.pid,D:/DataSynapse/Engine/work/Jessica-PC-0/tibcoamx/tibcojre64/1.6.0/bin/java,-cp,D:/DataSynapse/Engine/work/Jessica-PC-0/tibcoamx/tools/lib/antpackage.jar,org.apache.tools.ant.launch.Launcher,-f,D:\DataSynapse\Engine\work\Jessica-PC-0\scripts\cleanupDDL\cleanupDB.xml,-Dadmin.db.password=#Unable to render embedded object: File (sqlserver://192.168.66.101:1433;databaseName=Jessica_CleanDB1,-Dadmin.db.username=sa,-Dpayload.db.url=jdbc:sqlserver://192.168.66.101:1433;databaseName=Jessica_CleanDB1,-Dlogging.db.username=sa,-Dlogging.db.password=#) not found./NmiC+PYIr/jBkQDY2sFFGRazFSM32DE/LUogIwmDyM=,-Dpayload.db.username=sa,-Dadmin.db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver,-Dpayload.db.password=#Unable to render embedded object: File (\DataSynapse\Engine\work\Jessica-PC-0/fabric/mssql2008_driver,-Dmcr.db.username=sa,-Dlogging.db.url=jdbc:sqlserver://192.168.66.101:1433;databaseName=Jessica_CleanDB1,-Dtibco.home=D:/DataSynapse/Engine/work/Jessica-PC-0/tibcoamx,-Dmcr.db.url=jdbc:sqlserver://192.168.66.101:1433;databaseName=Jessica_CleanDB1,-Dmcr.db.password=#) not found./NmiC+PYIr/jBkQDY2sFFGRazFSM32DE/LUogIwmDyM=,cleanup.db.admin,10/30/12 13:44:10.776 INFO: [ProcessWrapper] [STDOUT] Buildfile: D:\DataSynapse\Engine\work\Jessica-PC-0\scripts\cleanupDDL\cleanupDB.xml10/30/12 13:44:11.256 INFO: [ProcessWrapper] [STDOUT]10/30/12 13:44:11.256 INFO: [ProcessWrapper] [STDOUT] replace.db.password:10/30/12 13:44:11.486 INFO: [ProcessWrapper] [STDOUT] [script] log4j:WARN No appenders could be found for logger (com.tibco.security.TIBCOSecurity).10/30/12 13:44:11.496 INFO: [ProcessWrapper] [STDOUT] [script] log4j:WARN Please initialize the log4j system properly.10/30/12 13:44:12.586 INFO: [ProcessWrapper] [STDOUT]10/30/12 13:44:12.616 INFO: [ProcessWrapper] [STDOUT] cleanup.db.admin:10/30/12 13:44:13.056 INFO: [ProcessWrapper] [STDOUT] [sql] Executing resource: D:\DataSynapse\Engine\work\Jessica-PC-0\scripts\cleanupDDL\mssql300\drop_admin.ddl10/30/12 13:44:22.966 INFO: [ProcessWrapper] [STDOUT] [sql] 0 rows affected10/30/12 13:44:25.616 INFO: [ProcessWrapper] [STDERR]10/30/12 13:44:25.616 INFO: [ProcessWrapper] [STDERR] BUILD FAILED10/30/12 13:44:25.616 INFO: [ProcessWrapper] [STDERR] com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:3400000001.10/30/12 13:44:25.616 INFO: [ProcessWrapper] [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)10/30/12 13:44:25.626 INFO: [ProcessWrapper] [STDERR] at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)10/30/12 13:44:25.626 INFO: [ProcessWrapper] [STDERR] at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)10/30/12 13:44:25.626 INFO: [ProcessWrapper] [STDERR] at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39)10/30/12 13:44:25.626 INFO: [ProcessWrapper] [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1441)10/30/12 13:44:25.626 INFO: [ProcessWrapper] [STDERR] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874)10/30/12 13:44:25.626 INFO: [ProcessWrapper] [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)10/30/12 13:44:25.626 INFO: [ProcessWrapper] [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1446)10/30/12 13:44:25.626 INFO: [ProcessWrapper] [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerConnection.commit(SQLServerConnection.java:1627)10/30/12 13:44:25.626 INFO: [ProcessWrapper] [STDERR] at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:452)10/30/12 13:44:25.626 INFO: [ProcessWrapper] [STDERR] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)10/30/12 13:44:25.626 INFO: [ProcessWrapper] [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)10/30/12 13:44:25.636 INFO: [ProcessWrapper] [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)10/30/12 13:44:25.636 INFO: [ProcessWrapper] [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)10/30/12 13:44:25.646 INFO: [ProcessWrapper] [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)10/30/12 13:44:25.646 INFO: [ProcessWrapper] [STDERR] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)10/30/12 13:44:25.646 INFO: [ProcessWrapper] [STDERR] at org.apache.tools.ant.Task.perform(Task.java:348)10/30/12 13:44:25.646 INFO: [ProcessWrapper] [STDERR] at org.apache.tools.ant.Target.execute(Target.java:357)10/30/12 13:44:25.646 INFO: [ProcessWrapper] [STDERR] at org.apache.tools.ant.Target.performTasks(Target.java:385)10/30/12 13:44:25.646 INFO: [ProcessWrapper] [STDERR] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)10/30/12 13:44:25.646 INFO: [ProcessWrapper] [STDERR] at org.apache.tools.ant.Project.executeTarget(Project.java:1306)10/30/12 13:44:25.646 INFO: [ProcessWrapper] [STDERR] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)10/30/12 13:44:25.646 INFO: [ProcessWrapper] [STDERR] at org.apache.tools.ant.Project.executeTargets(Project.java:1189)10/30/12 13:44:25.646 INFO: [ProcessWrapper] [STDERR] at org.apache.tools.ant.Main.runBuild(Main.java:758)10/30/12 13:44:25.646 INFO: [ProcessWrapper] [STDERR] at org.apache.tools.ant.Main.startAnt(Main.java:217)10/30/12 13:44:25.646 INFO: [ProcessWrapper] [STDERR] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)10/30/12 13:44:25.656 INFO: [ProcessWrapper] [STDERR] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)