RE: [PATCH] Print SQL to System.out or output file

[Eric VanLydegraf]

Here Here ! I Like the classpath idea - yet one more classpath I can build into the ant build.xml instead of requiring it in the actuall user environment CLASSPATH. -----Original Message----- From: Tomasini Andrea [mailto:[EMAIL PROTECTED] Sent: Friday, September 22, 2000 3:22 AM To: [EMAIL PROTECTED] Subject: R: [PATCH] Print SQL to System.out or output file Here's a patch to to the SQLExec.java which adds the ability to pipe the results of SQL statements executed with <sql/> to a file or the screen. It simply prints the output as comma delimited values, optionally printing the headers. I wrote it thinking of using it to write queries which generate sql statements which can then be fed back into <sql/> directive a second time.   Here is sample usage:                   <sql                         driver="${db.driver}"                         url=""                         userid="${db.userid}"                         password="${db.password}"                         print="yes"                         showheaders="no"                         output="output.txt">                 select count(*) from footable                 </sql>    Very Good!! What about adding a classpath attribute to locate multiple JDBC Drivers??   Byez ANdreaT