1 | <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
|
---|
2 | <!--NewPage-->
|
---|
3 | <HTML>
|
---|
4 | <HEAD>
|
---|
5 | <!-- Generated by javadoc (build 1.4.2_13) on Mon Oct 01 14:33:22 NZST 2007 -->
|
---|
6 | <TITLE>
|
---|
7 | SQLExec (Apache Ant API)
|
---|
8 | </TITLE>
|
---|
9 |
|
---|
10 | <META NAME="keywords" CONTENT="org.apache.tools.ant.taskdefs.SQLExec class">
|
---|
11 |
|
---|
12 | <LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../../stylesheet.css" TITLE="Style">
|
---|
13 |
|
---|
14 | <SCRIPT type="text/javascript">
|
---|
15 | function windowTitle()
|
---|
16 | {
|
---|
17 | parent.document.title="SQLExec (Apache Ant API)";
|
---|
18 | }
|
---|
19 | </SCRIPT>
|
---|
20 |
|
---|
21 | </HEAD>
|
---|
22 |
|
---|
23 | <BODY BGCOLOR="white" onload="windowTitle();">
|
---|
24 |
|
---|
25 |
|
---|
26 | <!-- ========= START OF TOP NAVBAR ======= -->
|
---|
27 | <A NAME="navbar_top"><!-- --></A>
|
---|
28 | <A HREF="#skip-navbar_top" title="Skip navigation links"></A>
|
---|
29 | <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
|
---|
30 | <TR>
|
---|
31 | <TD COLSPAN=3 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
|
---|
32 | <A NAME="navbar_top_firstrow"><!-- --></A>
|
---|
33 | <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
|
---|
34 | <TR ALIGN="center" VALIGN="top">
|
---|
35 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD>
|
---|
36 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD>
|
---|
37 | <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD>
|
---|
38 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD>
|
---|
39 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD>
|
---|
40 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD>
|
---|
41 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD>
|
---|
42 | </TR>
|
---|
43 | </TABLE>
|
---|
44 | </TD>
|
---|
45 | <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
|
---|
46 | </EM>
|
---|
47 | </TD>
|
---|
48 | </TR>
|
---|
49 |
|
---|
50 | <TR>
|
---|
51 | <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
|
---|
52 | <A HREF="../../../../../org/apache/tools/ant/taskdefs/Sleep.html" title="class in org.apache.tools.ant.taskdefs"><B>PREV CLASS</B></A>
|
---|
53 | <A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.DelimiterType.html" title="class in org.apache.tools.ant.taskdefs"><B>NEXT CLASS</B></A></FONT></TD>
|
---|
54 | <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
|
---|
55 | <A HREF="../../../../../index.html" target="_top"><B>FRAMES</B></A>
|
---|
56 | <A HREF="SQLExec.html" target="_top"><B>NO FRAMES</B></A>
|
---|
57 | <SCRIPT type="text/javascript">
|
---|
58 | <!--
|
---|
59 | if(window==top) {
|
---|
60 | document.writeln('<A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>');
|
---|
61 | }
|
---|
62 | //-->
|
---|
63 | </SCRIPT>
|
---|
64 | <NOSCRIPT>
|
---|
65 | <A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>
|
---|
66 | </NOSCRIPT>
|
---|
67 |
|
---|
68 | </FONT></TD>
|
---|
69 | </TR>
|
---|
70 | <TR>
|
---|
71 | <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
|
---|
72 | SUMMARY: <A HREF="#nested_class_summary">NESTED</A> | <A HREF="#fields_inherited_from_class_org.apache.tools.ant.Task">FIELD</A> | <A HREF="#constructor_summary">CONSTR</A> | <A HREF="#method_summary">METHOD</A></FONT></TD>
|
---|
73 | <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
|
---|
74 | DETAIL: FIELD | <A HREF="#constructor_detail">CONSTR</A> | <A HREF="#method_detail">METHOD</A></FONT></TD>
|
---|
75 | </TR>
|
---|
76 | </TABLE>
|
---|
77 | <A NAME="skip-navbar_top"></A>
|
---|
78 | <!-- ========= END OF TOP NAVBAR ========= -->
|
---|
79 |
|
---|
80 | <HR>
|
---|
81 | <!-- ======== START OF CLASS DATA ======== -->
|
---|
82 | <H2>
|
---|
83 | <FONT SIZE="-1">
|
---|
84 | org.apache.tools.ant.taskdefs</FONT>
|
---|
85 | <BR>
|
---|
86 | Class SQLExec</H2>
|
---|
87 | <PRE>
|
---|
88 | java.lang.Object
|
---|
89 | <IMG SRC="../../../../../resources/inherit.gif" ALT="extended by"><A HREF="../../../../../org/apache/tools/ant/ProjectComponent.html" title="class in org.apache.tools.ant">org.apache.tools.ant.ProjectComponent</A>
|
---|
90 | <IMG SRC="../../../../../resources/inherit.gif" ALT="extended by"><A HREF="../../../../../org/apache/tools/ant/Task.html" title="class in org.apache.tools.ant">org.apache.tools.ant.Task</A>
|
---|
91 | <IMG SRC="../../../../../resources/inherit.gif" ALT="extended by"><A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html" title="class in org.apache.tools.ant.taskdefs">org.apache.tools.ant.taskdefs.JDBCTask</A>
|
---|
92 | <IMG SRC="../../../../../resources/inherit.gif" ALT="extended by"><B>org.apache.tools.ant.taskdefs.SQLExec</B>
|
---|
93 | </PRE>
|
---|
94 | <HR>
|
---|
95 | <DL>
|
---|
96 | <DT>public class <B>SQLExec</B><DT>extends <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html" title="class in org.apache.tools.ant.taskdefs">JDBCTask</A></DL>
|
---|
97 |
|
---|
98 | <P>
|
---|
99 | Executes a series of SQL statements on a database using JDBC.
|
---|
100 |
|
---|
101 | <p>Statements can
|
---|
102 | either be read in from a text file using the <i>src</i> attribute or from
|
---|
103 | between the enclosing SQL tags.</p>
|
---|
104 |
|
---|
105 | <p>Multiple statements can be provided, separated by semicolons (or the
|
---|
106 | defined <i>delimiter</i>). Individual lines within the statements can be
|
---|
107 | commented using either --, // or REM at the start of the line.</p>
|
---|
108 |
|
---|
109 | <p>The <i>autocommit</i> attribute specifies whether auto-commit should be
|
---|
110 | turned on or off whilst executing the statements. If auto-commit is turned
|
---|
111 | on each statement will be executed and committed. If it is turned off the
|
---|
112 | statements will all be executed as one transaction.</p>
|
---|
113 |
|
---|
114 | <p>The <i>onerror</i> attribute specifies how to proceed when an error occurs
|
---|
115 | during the execution of one of the statements.
|
---|
116 | The possible values are: <b>continue</b> execution, only show the error;
|
---|
117 | <b>stop</b> execution and commit transaction;
|
---|
118 | and <b>abort</b> execution and transaction and fail task.</p>
|
---|
119 | <P>
|
---|
120 |
|
---|
121 | <P>
|
---|
122 | <DL>
|
---|
123 | <DT><B>Since:</B></DT>
|
---|
124 | <DD>Ant 1.2</DD>
|
---|
125 | </DL>
|
---|
126 | <HR>
|
---|
127 |
|
---|
128 | <P>
|
---|
129 | <!-- ======== NESTED CLASS SUMMARY ======== -->
|
---|
130 |
|
---|
131 | <A NAME="nested_class_summary"><!-- --></A>
|
---|
132 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
|
---|
133 | <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
|
---|
134 | <TD COLSPAN=2><FONT SIZE="+2">
|
---|
135 | <B>Nested Class Summary</B></FONT></TD>
|
---|
136 | </TR>
|
---|
137 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
138 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
139 | <CODE>static class</CODE></FONT></TD>
|
---|
140 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.DelimiterType.html" title="class in org.apache.tools.ant.taskdefs">SQLExec.DelimiterType</A></B></CODE>
|
---|
141 |
|
---|
142 | <BR>
|
---|
143 | delimiters we support, "normal" and "row"</TD>
|
---|
144 | </TR>
|
---|
145 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
146 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
147 | <CODE>static class</CODE></FONT></TD>
|
---|
148 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.OnError.html" title="class in org.apache.tools.ant.taskdefs">SQLExec.OnError</A></B></CODE>
|
---|
149 |
|
---|
150 | <BR>
|
---|
151 | The action a task should perform on an error,
|
---|
152 | one of "continue", "stop" and "abort"</TD>
|
---|
153 | </TR>
|
---|
154 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
155 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
156 | <CODE> class</CODE></FONT></TD>
|
---|
157 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.Transaction.html" title="class in org.apache.tools.ant.taskdefs">SQLExec.Transaction</A></B></CODE>
|
---|
158 |
|
---|
159 | <BR>
|
---|
160 | Contains the definition of a new transaction element.</TD>
|
---|
161 | </TR>
|
---|
162 | </TABLE>
|
---|
163 |
|
---|
164 | <!-- =========== FIELD SUMMARY =========== -->
|
---|
165 |
|
---|
166 | <A NAME="field_summary"><!-- --></A>
|
---|
167 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
|
---|
168 | <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
|
---|
169 | <TD COLSPAN=2><FONT SIZE="+2">
|
---|
170 | <B>Field Summary</B></FONT></TD>
|
---|
171 | </TR>
|
---|
172 | </TABLE>
|
---|
173 | <A NAME="fields_inherited_from_class_org.apache.tools.ant.Task"><!-- --></A>
|
---|
174 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
|
---|
175 | <TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
|
---|
176 | <TD><B>Fields inherited from class org.apache.tools.ant.<A HREF="../../../../../org/apache/tools/ant/Task.html" title="class in org.apache.tools.ant">Task</A></B></TD>
|
---|
177 | </TR>
|
---|
178 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
179 | <TD><CODE><A HREF="../../../../../org/apache/tools/ant/Task.html#description">description</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#location">location</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#target">target</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#taskName">taskName</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#taskType">taskType</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#wrapper">wrapper</A></CODE></TD>
|
---|
180 | </TR>
|
---|
181 | </TABLE>
|
---|
182 | <A NAME="fields_inherited_from_class_org.apache.tools.ant.ProjectComponent"><!-- --></A>
|
---|
183 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
|
---|
184 | <TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
|
---|
185 | <TD><B>Fields inherited from class org.apache.tools.ant.<A HREF="../../../../../org/apache/tools/ant/ProjectComponent.html" title="class in org.apache.tools.ant">ProjectComponent</A></B></TD>
|
---|
186 | </TR>
|
---|
187 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
188 | <TD><CODE><A HREF="../../../../../org/apache/tools/ant/ProjectComponent.html#project">project</A></CODE></TD>
|
---|
189 | </TR>
|
---|
190 | </TABLE>
|
---|
191 |
|
---|
192 | <!-- ======== CONSTRUCTOR SUMMARY ======== -->
|
---|
193 |
|
---|
194 | <A NAME="constructor_summary"><!-- --></A>
|
---|
195 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
|
---|
196 | <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
|
---|
197 | <TD COLSPAN=2><FONT SIZE="+2">
|
---|
198 | <B>Constructor Summary</B></FONT></TD>
|
---|
199 | </TR>
|
---|
200 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
201 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#SQLExec()">SQLExec</A></B>()</CODE>
|
---|
202 |
|
---|
203 | <BR>
|
---|
204 | </TD>
|
---|
205 | </TR>
|
---|
206 | </TABLE>
|
---|
207 |
|
---|
208 | <!-- ========== METHOD SUMMARY =========== -->
|
---|
209 |
|
---|
210 | <A NAME="method_summary"><!-- --></A>
|
---|
211 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
|
---|
212 | <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
|
---|
213 | <TD COLSPAN=2><FONT SIZE="+2">
|
---|
214 | <B>Method Summary</B></FONT></TD>
|
---|
215 | </TR>
|
---|
216 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
217 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
218 | <CODE> void</CODE></FONT></TD>
|
---|
219 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#addFileset(org.apache.tools.ant.types.FileSet)">addFileset</A></B>(<A HREF="../../../../../org/apache/tools/ant/types/FileSet.html" title="class in org.apache.tools.ant.types">FileSet</A> set)</CODE>
|
---|
220 |
|
---|
221 | <BR>
|
---|
222 | Adds a set of files (nested fileset attribute).</TD>
|
---|
223 | </TR>
|
---|
224 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
225 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
226 | <CODE> void</CODE></FONT></TD>
|
---|
227 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#addText(java.lang.String)">addText</A></B>(java.lang.String sql)</CODE>
|
---|
228 |
|
---|
229 | <BR>
|
---|
230 | Set an inline SQL command to execute.</TD>
|
---|
231 | </TR>
|
---|
232 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
233 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
234 | <CODE> <A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.Transaction.html" title="class in org.apache.tools.ant.taskdefs">SQLExec.Transaction</A></CODE></FONT></TD>
|
---|
235 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#createTransaction()">createTransaction</A></B>()</CODE>
|
---|
236 |
|
---|
237 | <BR>
|
---|
238 | Add a SQL transaction to execute</TD>
|
---|
239 | </TR>
|
---|
240 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
241 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
242 | <CODE>protected void</CODE></FONT></TD>
|
---|
243 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#execSQL(java.lang.String, java.io.PrintStream)">execSQL</A></B>(java.lang.String sql,
|
---|
244 | java.io.PrintStream out)</CODE>
|
---|
245 |
|
---|
246 | <BR>
|
---|
247 | Exec the sql statement.</TD>
|
---|
248 | </TR>
|
---|
249 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
250 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
251 | <CODE> void</CODE></FONT></TD>
|
---|
252 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#execute()">execute</A></B>()</CODE>
|
---|
253 |
|
---|
254 | <BR>
|
---|
255 | Load the sql file and then execute it</TD>
|
---|
256 | </TR>
|
---|
257 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
258 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
259 | <CODE>protected void</CODE></FONT></TD>
|
---|
260 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#printResults(java.io.PrintStream)">printResults</A></B>(java.io.PrintStream out)</CODE>
|
---|
261 |
|
---|
262 | <BR>
|
---|
263 | <B>Deprecated.</B> <I>use <A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#printResults(java.sql.ResultSet, java.io.PrintStream)"><CODE>the two arg version</CODE></A> instead.</I></TD>
|
---|
264 | </TR>
|
---|
265 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
266 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
267 | <CODE>protected void</CODE></FONT></TD>
|
---|
268 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#printResults(java.sql.ResultSet, java.io.PrintStream)">printResults</A></B>(java.sql.ResultSet rs,
|
---|
269 | java.io.PrintStream out)</CODE>
|
---|
270 |
|
---|
271 | <BR>
|
---|
272 | print any results in the result set.</TD>
|
---|
273 | </TR>
|
---|
274 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
275 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
276 | <CODE>protected void</CODE></FONT></TD>
|
---|
277 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#runStatements(java.io.Reader, java.io.PrintStream)">runStatements</A></B>(java.io.Reader reader,
|
---|
278 | java.io.PrintStream out)</CODE>
|
---|
279 |
|
---|
280 | <BR>
|
---|
281 | read in lines and execute them</TD>
|
---|
282 | </TR>
|
---|
283 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
284 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
285 | <CODE> void</CODE></FONT></TD>
|
---|
286 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#setAppend(boolean)">setAppend</A></B>(boolean append)</CODE>
|
---|
287 |
|
---|
288 | <BR>
|
---|
289 | whether output should be appended to or overwrite
|
---|
290 | an existing file.</TD>
|
---|
291 | </TR>
|
---|
292 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
293 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
294 | <CODE> void</CODE></FONT></TD>
|
---|
295 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#setDelimiter(java.lang.String)">setDelimiter</A></B>(java.lang.String delimiter)</CODE>
|
---|
296 |
|
---|
297 | <BR>
|
---|
298 | Set the delimiter that separates SQL statements.</TD>
|
---|
299 | </TR>
|
---|
300 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
301 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
302 | <CODE> void</CODE></FONT></TD>
|
---|
303 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#setDelimiterType(org.apache.tools.ant.taskdefs.SQLExec.DelimiterType)">setDelimiterType</A></B>(<A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.DelimiterType.html" title="class in org.apache.tools.ant.taskdefs">SQLExec.DelimiterType</A> delimiterType)</CODE>
|
---|
304 |
|
---|
305 | <BR>
|
---|
306 | Set the delimiter type: "normal" or "row" (default "normal").</TD>
|
---|
307 | </TR>
|
---|
308 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
309 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
310 | <CODE> void</CODE></FONT></TD>
|
---|
311 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#setEncoding(java.lang.String)">setEncoding</A></B>(java.lang.String encoding)</CODE>
|
---|
312 |
|
---|
313 | <BR>
|
---|
314 | Set the file encoding to use on the SQL files read in</TD>
|
---|
315 | </TR>
|
---|
316 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
317 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
318 | <CODE> void</CODE></FONT></TD>
|
---|
319 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#setEscapeProcessing(boolean)">setEscapeProcessing</A></B>(boolean enable)</CODE>
|
---|
320 |
|
---|
321 | <BR>
|
---|
322 | Set escape processing for statements.</TD>
|
---|
323 | </TR>
|
---|
324 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
325 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
326 | <CODE> void</CODE></FONT></TD>
|
---|
327 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#setKeepformat(boolean)">setKeepformat</A></B>(boolean keepformat)</CODE>
|
---|
328 |
|
---|
329 | <BR>
|
---|
330 | whether or not format should be preserved.</TD>
|
---|
331 | </TR>
|
---|
332 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
333 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
334 | <CODE> void</CODE></FONT></TD>
|
---|
335 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#setOnerror(org.apache.tools.ant.taskdefs.SQLExec.OnError)">setOnerror</A></B>(<A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.OnError.html" title="class in org.apache.tools.ant.taskdefs">SQLExec.OnError</A> action)</CODE>
|
---|
336 |
|
---|
337 | <BR>
|
---|
338 | Action to perform when statement fails: continue, stop, or abort
|
---|
339 | optional; default "abort"</TD>
|
---|
340 | </TR>
|
---|
341 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
342 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
343 | <CODE> void</CODE></FONT></TD>
|
---|
344 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#setOutput(java.io.File)">setOutput</A></B>(java.io.File output)</CODE>
|
---|
345 |
|
---|
346 | <BR>
|
---|
347 | Set the output file;
|
---|
348 | optional, defaults to the Ant log.</TD>
|
---|
349 | </TR>
|
---|
350 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
351 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
352 | <CODE> void</CODE></FONT></TD>
|
---|
353 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#setPrint(boolean)">setPrint</A></B>(boolean print)</CODE>
|
---|
354 |
|
---|
355 | <BR>
|
---|
356 | Print result sets from the statements;
|
---|
357 | optional, default false</TD>
|
---|
358 | </TR>
|
---|
359 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
360 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
361 | <CODE> void</CODE></FONT></TD>
|
---|
362 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#setShowheaders(boolean)">setShowheaders</A></B>(boolean showheaders)</CODE>
|
---|
363 |
|
---|
364 | <BR>
|
---|
365 | Print headers for result sets from the
|
---|
366 | statements; optional, default true.</TD>
|
---|
367 | </TR>
|
---|
368 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
369 | <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
|
---|
370 | <CODE> void</CODE></FONT></TD>
|
---|
371 | <TD><CODE><B><A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#setSrc(java.io.File)">setSrc</A></B>(java.io.File srcFile)</CODE>
|
---|
372 |
|
---|
373 | <BR>
|
---|
374 | Set the name of the SQL file to be run.</TD>
|
---|
375 | </TR>
|
---|
376 | </TABLE>
|
---|
377 | <A NAME="methods_inherited_from_class_org.apache.tools.ant.taskdefs.JDBCTask"><!-- --></A>
|
---|
378 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
|
---|
379 | <TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
|
---|
380 | <TD><B>Methods inherited from class org.apache.tools.ant.taskdefs.<A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html" title="class in org.apache.tools.ant.taskdefs">JDBCTask</A></B></TD>
|
---|
381 | </TR>
|
---|
382 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
383 | <TD><CODE><A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#createClasspath()">createClasspath</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#getClasspath()">getClasspath</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#getConnection()">getConnection</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#getLoader()">getLoader</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#getLoaderMap()">getLoaderMap</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#getPassword()">getPassword</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#getRdbms()">getRdbms</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#getUrl()">getUrl</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#getUserId()">getUserId</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#getVersion()">getVersion</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#isAutocommit()">isAutocommit</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#isCaching(boolean)">isCaching</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#isValidRdbms(java.sql.Connection)">isValidRdbms</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#setAutocommit(boolean)">setAutocommit</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#setCaching(boolean)">setCaching</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#setClasspath(org.apache.tools.ant.types.Path)">setClasspath</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#setClasspathRef(org.apache.tools.ant.types.Reference)">setClasspathRef</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#setDriver(java.lang.String)">setDriver</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#setPassword(java.lang.String)">setPassword</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#setRdbms(java.lang.String)">setRdbms</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#setUrl(java.lang.String)">setUrl</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#setUserid(java.lang.String)">setUserid</A>, <A HREF="../../../../../org/apache/tools/ant/taskdefs/JDBCTask.html#setVersion(java.lang.String)">setVersion</A></CODE></TD>
|
---|
384 | </TR>
|
---|
385 | </TABLE>
|
---|
386 | <A NAME="methods_inherited_from_class_org.apache.tools.ant.Task"><!-- --></A>
|
---|
387 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
|
---|
388 | <TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
|
---|
389 | <TD><B>Methods inherited from class org.apache.tools.ant.<A HREF="../../../../../org/apache/tools/ant/Task.html" title="class in org.apache.tools.ant">Task</A></B></TD>
|
---|
390 | </TR>
|
---|
391 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
392 | <TD><CODE><A HREF="../../../../../org/apache/tools/ant/Task.html#getDescription()">getDescription</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#getLocation()">getLocation</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#getOwningTarget()">getOwningTarget</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#getRuntimeConfigurableWrapper()">getRuntimeConfigurableWrapper</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#getTaskName()">getTaskName</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#getTaskType()">getTaskType</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#getWrapper()">getWrapper</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#handleErrorFlush(java.lang.String)">handleErrorFlush</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#handleErrorOutput(java.lang.String)">handleErrorOutput</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#handleFlush(java.lang.String)">handleFlush</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#handleInput(byte[], int, int)">handleInput</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#handleOutput(java.lang.String)">handleOutput</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#init()">init</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#isInvalid()">isInvalid</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#log(java.lang.String)">log</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#log(java.lang.String, int)">log</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#maybeConfigure()">maybeConfigure</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#perform()">perform</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#reconfigure()">reconfigure</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#setDescription(java.lang.String)">setDescription</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#setLocation(org.apache.tools.ant.Location)">setLocation</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#setOwningTarget(org.apache.tools.ant.Target)">setOwningTarget</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#setRuntimeConfigurableWrapper(org.apache.tools.ant.RuntimeConfigurable)">setRuntimeConfigurableWrapper</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#setTaskName(java.lang.String)">setTaskName</A>, <A HREF="../../../../../org/apache/tools/ant/Task.html#setTaskType(java.lang.String)">setTaskType</A></CODE></TD>
|
---|
393 | </TR>
|
---|
394 | </TABLE>
|
---|
395 | <A NAME="methods_inherited_from_class_org.apache.tools.ant.ProjectComponent"><!-- --></A>
|
---|
396 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
|
---|
397 | <TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
|
---|
398 | <TD><B>Methods inherited from class org.apache.tools.ant.<A HREF="../../../../../org/apache/tools/ant/ProjectComponent.html" title="class in org.apache.tools.ant">ProjectComponent</A></B></TD>
|
---|
399 | </TR>
|
---|
400 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
401 | <TD><CODE><A HREF="../../../../../org/apache/tools/ant/ProjectComponent.html#getProject()">getProject</A>, <A HREF="../../../../../org/apache/tools/ant/ProjectComponent.html#setProject(org.apache.tools.ant.Project)">setProject</A></CODE></TD>
|
---|
402 | </TR>
|
---|
403 | </TABLE>
|
---|
404 | <A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A>
|
---|
405 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
|
---|
406 | <TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
|
---|
407 | <TD><B>Methods inherited from class java.lang.Object</B></TD>
|
---|
408 | </TR>
|
---|
409 | <TR BGCOLOR="white" CLASS="TableRowColor">
|
---|
410 | <TD><CODE>clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</CODE></TD>
|
---|
411 | </TR>
|
---|
412 | </TABLE>
|
---|
413 |
|
---|
414 | <P>
|
---|
415 |
|
---|
416 | <!-- ============ FIELD DETAIL =========== -->
|
---|
417 |
|
---|
418 |
|
---|
419 | <!-- ========= CONSTRUCTOR DETAIL ======== -->
|
---|
420 |
|
---|
421 | <A NAME="constructor_detail"><!-- --></A>
|
---|
422 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
|
---|
423 | <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
|
---|
424 | <TD COLSPAN=1><FONT SIZE="+2">
|
---|
425 | <B>Constructor Detail</B></FONT></TD>
|
---|
426 | </TR>
|
---|
427 | </TABLE>
|
---|
428 |
|
---|
429 | <A NAME="SQLExec()"><!-- --></A><H3>
|
---|
430 | SQLExec</H3>
|
---|
431 | <PRE>
|
---|
432 | public <B>SQLExec</B>()</PRE>
|
---|
433 | <DL>
|
---|
434 | </DL>
|
---|
435 |
|
---|
436 | <!-- ============ METHOD DETAIL ========== -->
|
---|
437 |
|
---|
438 | <A NAME="method_detail"><!-- --></A>
|
---|
439 | <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
|
---|
440 | <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
|
---|
441 | <TD COLSPAN=1><FONT SIZE="+2">
|
---|
442 | <B>Method Detail</B></FONT></TD>
|
---|
443 | </TR>
|
---|
444 | </TABLE>
|
---|
445 |
|
---|
446 | <A NAME="setSrc(java.io.File)"><!-- --></A><H3>
|
---|
447 | setSrc</H3>
|
---|
448 | <PRE>
|
---|
449 | public void <B>setSrc</B>(java.io.File srcFile)</PRE>
|
---|
450 | <DL>
|
---|
451 | <DD>Set the name of the SQL file to be run.
|
---|
452 | Required unless statements are enclosed in the build file
|
---|
453 | <P>
|
---|
454 | <DD><DL>
|
---|
455 | </DL>
|
---|
456 | </DD>
|
---|
457 | </DL>
|
---|
458 | <HR>
|
---|
459 |
|
---|
460 | <A NAME="addText(java.lang.String)"><!-- --></A><H3>
|
---|
461 | addText</H3>
|
---|
462 | <PRE>
|
---|
463 | public void <B>addText</B>(java.lang.String sql)</PRE>
|
---|
464 | <DL>
|
---|
465 | <DD>Set an inline SQL command to execute.
|
---|
466 | NB: Properties are not expanded in this text.
|
---|
467 | <P>
|
---|
468 | <DD><DL>
|
---|
469 | </DL>
|
---|
470 | </DD>
|
---|
471 | </DL>
|
---|
472 | <HR>
|
---|
473 |
|
---|
474 | <A NAME="addFileset(org.apache.tools.ant.types.FileSet)"><!-- --></A><H3>
|
---|
475 | addFileset</H3>
|
---|
476 | <PRE>
|
---|
477 | public void <B>addFileset</B>(<A HREF="../../../../../org/apache/tools/ant/types/FileSet.html" title="class in org.apache.tools.ant.types">FileSet</A> set)</PRE>
|
---|
478 | <DL>
|
---|
479 | <DD>Adds a set of files (nested fileset attribute).
|
---|
480 | <P>
|
---|
481 | <DD><DL>
|
---|
482 | </DL>
|
---|
483 | </DD>
|
---|
484 | </DL>
|
---|
485 | <HR>
|
---|
486 |
|
---|
487 | <A NAME="createTransaction()"><!-- --></A><H3>
|
---|
488 | createTransaction</H3>
|
---|
489 | <PRE>
|
---|
490 | public <A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.Transaction.html" title="class in org.apache.tools.ant.taskdefs">SQLExec.Transaction</A> <B>createTransaction</B>()</PRE>
|
---|
491 | <DL>
|
---|
492 | <DD>Add a SQL transaction to execute
|
---|
493 | <P>
|
---|
494 | <DD><DL>
|
---|
495 | </DL>
|
---|
496 | </DD>
|
---|
497 | </DL>
|
---|
498 | <HR>
|
---|
499 |
|
---|
500 | <A NAME="setEncoding(java.lang.String)"><!-- --></A><H3>
|
---|
501 | setEncoding</H3>
|
---|
502 | <PRE>
|
---|
503 | public void <B>setEncoding</B>(java.lang.String encoding)</PRE>
|
---|
504 | <DL>
|
---|
505 | <DD>Set the file encoding to use on the SQL files read in
|
---|
506 | <P>
|
---|
507 | <DD><DL>
|
---|
508 | <DT><B>Parameters:</B><DD><CODE>encoding</CODE> - the encoding to use on the files</DL>
|
---|
509 | </DD>
|
---|
510 | </DL>
|
---|
511 | <HR>
|
---|
512 |
|
---|
513 | <A NAME="setDelimiter(java.lang.String)"><!-- --></A><H3>
|
---|
514 | setDelimiter</H3>
|
---|
515 | <PRE>
|
---|
516 | public void <B>setDelimiter</B>(java.lang.String delimiter)</PRE>
|
---|
517 | <DL>
|
---|
518 | <DD>Set the delimiter that separates SQL statements. Defaults to ";";
|
---|
519 | optional
|
---|
520 |
|
---|
521 | <p>For example, set this to "go" and delimitertype to "ROW" for
|
---|
522 | Sybase ASE or MS SQL Server.</p>
|
---|
523 | <P>
|
---|
524 | <DD><DL>
|
---|
525 | </DL>
|
---|
526 | </DD>
|
---|
527 | </DL>
|
---|
528 | <HR>
|
---|
529 |
|
---|
530 | <A NAME="setDelimiterType(org.apache.tools.ant.taskdefs.SQLExec.DelimiterType)"><!-- --></A><H3>
|
---|
531 | setDelimiterType</H3>
|
---|
532 | <PRE>
|
---|
533 | public void <B>setDelimiterType</B>(<A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.DelimiterType.html" title="class in org.apache.tools.ant.taskdefs">SQLExec.DelimiterType</A> delimiterType)</PRE>
|
---|
534 | <DL>
|
---|
535 | <DD>Set the delimiter type: "normal" or "row" (default "normal").
|
---|
536 |
|
---|
537 | <p>The delimiter type takes two values - normal and row. Normal
|
---|
538 | means that any occurrence of the delimiter terminate the SQL
|
---|
539 | command whereas with row, only a line containing just the
|
---|
540 | delimiter is recognized as the end of the command.</p>
|
---|
541 | <P>
|
---|
542 | <DD><DL>
|
---|
543 | </DL>
|
---|
544 | </DD>
|
---|
545 | </DL>
|
---|
546 | <HR>
|
---|
547 |
|
---|
548 | <A NAME="setPrint(boolean)"><!-- --></A><H3>
|
---|
549 | setPrint</H3>
|
---|
550 | <PRE>
|
---|
551 | public void <B>setPrint</B>(boolean print)</PRE>
|
---|
552 | <DL>
|
---|
553 | <DD>Print result sets from the statements;
|
---|
554 | optional, default false
|
---|
555 | <P>
|
---|
556 | <DD><DL>
|
---|
557 | </DL>
|
---|
558 | </DD>
|
---|
559 | </DL>
|
---|
560 | <HR>
|
---|
561 |
|
---|
562 | <A NAME="setShowheaders(boolean)"><!-- --></A><H3>
|
---|
563 | setShowheaders</H3>
|
---|
564 | <PRE>
|
---|
565 | public void <B>setShowheaders</B>(boolean showheaders)</PRE>
|
---|
566 | <DL>
|
---|
567 | <DD>Print headers for result sets from the
|
---|
568 | statements; optional, default true.
|
---|
569 | <P>
|
---|
570 | <DD><DL>
|
---|
571 | </DL>
|
---|
572 | </DD>
|
---|
573 | </DL>
|
---|
574 | <HR>
|
---|
575 |
|
---|
576 | <A NAME="setOutput(java.io.File)"><!-- --></A><H3>
|
---|
577 | setOutput</H3>
|
---|
578 | <PRE>
|
---|
579 | public void <B>setOutput</B>(java.io.File output)</PRE>
|
---|
580 | <DL>
|
---|
581 | <DD>Set the output file;
|
---|
582 | optional, defaults to the Ant log.
|
---|
583 | <P>
|
---|
584 | <DD><DL>
|
---|
585 | </DL>
|
---|
586 | </DD>
|
---|
587 | </DL>
|
---|
588 | <HR>
|
---|
589 |
|
---|
590 | <A NAME="setAppend(boolean)"><!-- --></A><H3>
|
---|
591 | setAppend</H3>
|
---|
592 | <PRE>
|
---|
593 | public void <B>setAppend</B>(boolean append)</PRE>
|
---|
594 | <DL>
|
---|
595 | <DD>whether output should be appended to or overwrite
|
---|
596 | an existing file. Defaults to false.
|
---|
597 | <P>
|
---|
598 | <DD><DL>
|
---|
599 | <DT><B>Since:</B></DT>
|
---|
600 | <DD>Ant 1.5</DD>
|
---|
601 | </DL>
|
---|
602 | </DD>
|
---|
603 | </DL>
|
---|
604 | <HR>
|
---|
605 |
|
---|
606 | <A NAME="setOnerror(org.apache.tools.ant.taskdefs.SQLExec.OnError)"><!-- --></A><H3>
|
---|
607 | setOnerror</H3>
|
---|
608 | <PRE>
|
---|
609 | public void <B>setOnerror</B>(<A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.OnError.html" title="class in org.apache.tools.ant.taskdefs">SQLExec.OnError</A> action)</PRE>
|
---|
610 | <DL>
|
---|
611 | <DD>Action to perform when statement fails: continue, stop, or abort
|
---|
612 | optional; default "abort"
|
---|
613 | <P>
|
---|
614 | <DD><DL>
|
---|
615 | </DL>
|
---|
616 | </DD>
|
---|
617 | </DL>
|
---|
618 | <HR>
|
---|
619 |
|
---|
620 | <A NAME="setKeepformat(boolean)"><!-- --></A><H3>
|
---|
621 | setKeepformat</H3>
|
---|
622 | <PRE>
|
---|
623 | public void <B>setKeepformat</B>(boolean keepformat)</PRE>
|
---|
624 | <DL>
|
---|
625 | <DD>whether or not format should be preserved.
|
---|
626 | Defaults to false.
|
---|
627 | <P>
|
---|
628 | <DD><DL>
|
---|
629 | <DT><B>Parameters:</B><DD><CODE>keepformat</CODE> - The keepformat to set</DL>
|
---|
630 | </DD>
|
---|
631 | </DL>
|
---|
632 | <HR>
|
---|
633 |
|
---|
634 | <A NAME="setEscapeProcessing(boolean)"><!-- --></A><H3>
|
---|
635 | setEscapeProcessing</H3>
|
---|
636 | <PRE>
|
---|
637 | public void <B>setEscapeProcessing</B>(boolean enable)</PRE>
|
---|
638 | <DL>
|
---|
639 | <DD>Set escape processing for statements.
|
---|
640 | <P>
|
---|
641 | <DD><DL>
|
---|
642 | <DT><B>Since:</B></DT>
|
---|
643 | <DD>Ant 1.6</DD>
|
---|
644 | </DL>
|
---|
645 | </DD>
|
---|
646 | </DL>
|
---|
647 | <HR>
|
---|
648 |
|
---|
649 | <A NAME="execute()"><!-- --></A><H3>
|
---|
650 | execute</H3>
|
---|
651 | <PRE>
|
---|
652 | public void <B>execute</B>()
|
---|
653 | throws <A HREF="../../../../../org/apache/tools/ant/BuildException.html" title="class in org.apache.tools.ant">BuildException</A></PRE>
|
---|
654 | <DL>
|
---|
655 | <DD>Load the sql file and then execute it
|
---|
656 | <P>
|
---|
657 | <DD><DL>
|
---|
658 | <DT><B>Overrides:</B><DD><CODE><A HREF="../../../../../org/apache/tools/ant/Task.html#execute()">execute</A></CODE> in class <CODE><A HREF="../../../../../org/apache/tools/ant/Task.html" title="class in org.apache.tools.ant">Task</A></CODE></DL>
|
---|
659 | </DD>
|
---|
660 | <DD><DL>
|
---|
661 |
|
---|
662 | <DT><B>Throws:</B>
|
---|
663 | <DD><CODE><A HREF="../../../../../org/apache/tools/ant/BuildException.html" title="class in org.apache.tools.ant">BuildException</A></CODE> - if something goes wrong with the build</DL>
|
---|
664 | </DD>
|
---|
665 | </DL>
|
---|
666 | <HR>
|
---|
667 |
|
---|
668 | <A NAME="runStatements(java.io.Reader, java.io.PrintStream)"><!-- --></A><H3>
|
---|
669 | runStatements</H3>
|
---|
670 | <PRE>
|
---|
671 | protected void <B>runStatements</B>(java.io.Reader reader,
|
---|
672 | java.io.PrintStream out)
|
---|
673 | throws java.sql.SQLException,
|
---|
674 | java.io.IOException</PRE>
|
---|
675 | <DL>
|
---|
676 | <DD>read in lines and execute them
|
---|
677 | <P>
|
---|
678 | <DD><DL>
|
---|
679 |
|
---|
680 | <DT><B>Throws:</B>
|
---|
681 | <DD><CODE>java.sql.SQLException</CODE>
|
---|
682 | <DD><CODE>java.io.IOException</CODE></DL>
|
---|
683 | </DD>
|
---|
684 | </DL>
|
---|
685 | <HR>
|
---|
686 |
|
---|
687 | <A NAME="execSQL(java.lang.String, java.io.PrintStream)"><!-- --></A><H3>
|
---|
688 | execSQL</H3>
|
---|
689 | <PRE>
|
---|
690 | protected void <B>execSQL</B>(java.lang.String sql,
|
---|
691 | java.io.PrintStream out)
|
---|
692 | throws java.sql.SQLException</PRE>
|
---|
693 | <DL>
|
---|
694 | <DD>Exec the sql statement.
|
---|
695 | <P>
|
---|
696 | <DD><DL>
|
---|
697 |
|
---|
698 | <DT><B>Throws:</B>
|
---|
699 | <DD><CODE>java.sql.SQLException</CODE></DL>
|
---|
700 | </DD>
|
---|
701 | </DL>
|
---|
702 | <HR>
|
---|
703 |
|
---|
704 | <A NAME="printResults(java.io.PrintStream)"><!-- --></A><H3>
|
---|
705 | printResults</H3>
|
---|
706 | <PRE>
|
---|
707 | protected void <B>printResults</B>(java.io.PrintStream out)
|
---|
708 | throws java.sql.SQLException</PRE>
|
---|
709 | <DL>
|
---|
710 | <DD><B>Deprecated.</B> <I>use <A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.html#printResults(java.sql.ResultSet, java.io.PrintStream)"><CODE>the two arg version</CODE></A> instead.</I>
|
---|
711 | <P>
|
---|
712 | <DD>print any results in the statement
|
---|
713 | <P>
|
---|
714 | <DD><DL>
|
---|
715 | <DT><B>Parameters:</B><DD><CODE>out</CODE> - the place to print results
|
---|
716 | <DT><B>Throws:</B>
|
---|
717 | <DD><CODE>java.sql.SQLException</CODE> - on SQL problems.</DL>
|
---|
718 | </DD>
|
---|
719 | </DL>
|
---|
720 | <HR>
|
---|
721 |
|
---|
722 | <A NAME="printResults(java.sql.ResultSet, java.io.PrintStream)"><!-- --></A><H3>
|
---|
723 | printResults</H3>
|
---|
724 | <PRE>
|
---|
725 | protected void <B>printResults</B>(java.sql.ResultSet rs,
|
---|
726 | java.io.PrintStream out)
|
---|
727 | throws java.sql.SQLException</PRE>
|
---|
728 | <DL>
|
---|
729 | <DD>print any results in the result set.
|
---|
730 | <P>
|
---|
731 | <DD><DL>
|
---|
732 | <DT><B>Parameters:</B><DD><CODE>rs</CODE> - the resultset to print information about<DD><CODE>out</CODE> - the place to print results
|
---|
733 | <DT><B>Throws:</B>
|
---|
734 | <DD><CODE>java.sql.SQLException</CODE> - on SQL problems.<DT><B>Since:</B></DT>
|
---|
735 | <DD>Ant 1.6.3</DD>
|
---|
736 | </DL>
|
---|
737 | </DD>
|
---|
738 | </DL>
|
---|
739 | <!-- ========= END OF CLASS DATA ========= -->
|
---|
740 | <HR>
|
---|
741 |
|
---|
742 |
|
---|
743 | <!-- ======= START OF BOTTOM NAVBAR ====== -->
|
---|
744 | <A NAME="navbar_bottom"><!-- --></A>
|
---|
745 | <A HREF="#skip-navbar_bottom" title="Skip navigation links"></A>
|
---|
746 | <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
|
---|
747 | <TR>
|
---|
748 | <TD COLSPAN=3 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
|
---|
749 | <A NAME="navbar_bottom_firstrow"><!-- --></A>
|
---|
750 | <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
|
---|
751 | <TR ALIGN="center" VALIGN="top">
|
---|
752 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD>
|
---|
753 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD>
|
---|
754 | <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD>
|
---|
755 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD>
|
---|
756 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD>
|
---|
757 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD>
|
---|
758 | <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD>
|
---|
759 | </TR>
|
---|
760 | </TABLE>
|
---|
761 | </TD>
|
---|
762 | <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
|
---|
763 | </EM>
|
---|
764 | </TD>
|
---|
765 | </TR>
|
---|
766 |
|
---|
767 | <TR>
|
---|
768 | <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
|
---|
769 | <A HREF="../../../../../org/apache/tools/ant/taskdefs/Sleep.html" title="class in org.apache.tools.ant.taskdefs"><B>PREV CLASS</B></A>
|
---|
770 | <A HREF="../../../../../org/apache/tools/ant/taskdefs/SQLExec.DelimiterType.html" title="class in org.apache.tools.ant.taskdefs"><B>NEXT CLASS</B></A></FONT></TD>
|
---|
771 | <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
|
---|
772 | <A HREF="../../../../../index.html" target="_top"><B>FRAMES</B></A>
|
---|
773 | <A HREF="SQLExec.html" target="_top"><B>NO FRAMES</B></A>
|
---|
774 | <SCRIPT type="text/javascript">
|
---|
775 | <!--
|
---|
776 | if(window==top) {
|
---|
777 | document.writeln('<A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>');
|
---|
778 | }
|
---|
779 | //-->
|
---|
780 | </SCRIPT>
|
---|
781 | <NOSCRIPT>
|
---|
782 | <A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>
|
---|
783 | </NOSCRIPT>
|
---|
784 |
|
---|
785 | </FONT></TD>
|
---|
786 | </TR>
|
---|
787 | <TR>
|
---|
788 | <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
|
---|
789 | SUMMARY: <A HREF="#nested_class_summary">NESTED</A> | <A HREF="#fields_inherited_from_class_org.apache.tools.ant.Task">FIELD</A> | <A HREF="#constructor_summary">CONSTR</A> | <A HREF="#method_summary">METHOD</A></FONT></TD>
|
---|
790 | <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
|
---|
791 | DETAIL: FIELD | <A HREF="#constructor_detail">CONSTR</A> | <A HREF="#method_detail">METHOD</A></FONT></TD>
|
---|
792 | </TR>
|
---|
793 | </TABLE>
|
---|
794 | <A NAME="skip-navbar_bottom"></A>
|
---|
795 | <!-- ======== END OF BOTTOM NAVBAR ======= -->
|
---|
796 |
|
---|
797 | <HR>
|
---|
798 | Copyright © 2000-2007 Apache Software Foundation. All Rights Reserved.
|
---|
799 | </BODY>
|
---|
800 | </HTML>
|
---|