Ant执行SQL server 存储过程时的一个问题

YY-LIN

在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.xml
10/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.ddl
10/30/12 13:44:22.966 INFO: [ProcessWrapper] [STDOUT] [sql] 0 rows affected
10/30/12 13:44:25.616 INFO: [ProcessWrapper] [STDERR]
10/30/12 13:44:25.616 INFO: [ProcessWrapper] [STDERR] BUILD FAILED
10/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)