PLEASE DO NOT REPLY TO THIS MESSAGE. TO FURTHER COMMENT ON THE STATUS OF THIS BUG PLEASE FOLLOW THE LINK BELOW AND USE THE ON-LINE APPLICATION. REPLYING TO THIS MESSAGE DOES NOT UPDATE THE DATABASE, AND SO YOUR COMMENT WILL BE LOST SOMEWHERE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=2971 *** shadow/2971 Thu Aug 2 11:34:19 2001 --- shadow/2971.tmp.19706 Thu Aug 2 11:34:20 2001 *************** *** 0 **** --- 1,42 ---- + +============================================================================+ + | The <sql> task does not release memory after it is completed which causes | + +----------------------------------------------------------------------------+ + | Bug #: 2971 Product: Ant | + | Status: NEW Version: 1.3 | + | Resolution: Platform: PC | + | Severity: Critical OS/Version: Windows NT/2K | + | Priority: Other Component: Core tasks | + +----------------------------------------------------------------------------+ + | Assigned To: [EMAIL PROTECTED] | + | Reported By: [EMAIL PROTECTED] | + +----------------------------------------------------------------------------+ + | URL: | + +============================================================================+ + | DESCRIPTION | + The <sql> task does not seem to release the memory after the task is + completed. When running the <sql> task numberous times from the same VM, an + out of memory error occurs. Here is the <sql> target: + + <sql driver="${db.driver}" url="${db.url}" + userid="${db.user}" password="${db.pwd}" autocommit="true" onerror="continue"> + <classpath> + <fileset dir="lib" includes="j2ee.jar,jdbc_sql7.jar,jdbc_oracle8.jar,jdbc_db2- + 7.jar,jconn2.jar"/> + </classpath> + <transaction src="blank-file.sql"/> <-just a blank file + </sql> + + ${db.driver}: + com.inet.tds.TdsDriver (mssql 7.0) + COM.ibm.db2.jdbc.net.DB2Driver (DB2 version 7) + oracle.jdbc.driver.OracleDriver (Oracle 81) + + ${db.url}: + jdbc:inetdae7:localhost?database=dbname (mssql 7.0) + jdbc:db2://localhost/dbname (DB2 version 7) + jdbc:oracle:thin:@localhost:dbname (Oracle 81) + + With an oracle driver, the out of memory error occurs after 38 <sql> calls. + With an mssql driver, the out of memory error occurs after 379 <sql> calls. + With an db2 driver, the out of memory error occurs after 124 <sql> calls. + Note: the number of <sql> calls may vary depending on the computer \ No newline at end of file
