|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.apache.tools.ant.ProjectComponent org.apache.tools.ant.Task org.apache.torque.task.TorqueSQLExec
public class TorqueSQLExec
This task uses an SQL -> Database map in the form of a properties file to insert each SQL file listed into its designated database.
Nested Class Summary | |
---|---|
static class |
TorqueSQLExec.DelimiterType
|
static class |
TorqueSQLExec.OnError
Enumerated attribute with the values "continue", "stop" and "abort" for the onerror attribute. |
class |
TorqueSQLExec.Transaction
Contains the definition of a new transaction element. |
Field Summary |
---|
Fields inherited from class org.apache.tools.ant.Task |
---|
target, taskName, taskType, wrapper |
Fields inherited from class org.apache.tools.ant.ProjectComponent |
---|
description, location, project |
Constructor Summary | |
---|---|
TorqueSQLExec()
|
Method Summary | |
---|---|
void |
addText(java.lang.String sql)
Deprecated. This method has no effect and will be removed in a future version. |
org.apache.tools.ant.types.Path |
createClasspath()
Create the classpath for loading the driver. |
protected void |
execSQL(java.lang.String sql,
java.io.PrintStream out)
Exec the sql statement. |
void |
execute()
Load the sql file and then execute it |
java.io.File |
getSqlDbMap()
Get the sqldbmap properties file. |
java.lang.String |
getSrcDir()
Get the src directory for the sql files listed in the sqldbmap file. |
protected boolean |
isValidRdbms(java.sql.Connection conn)
Verify if connected to the correct RDBMS |
protected void |
printResults(java.io.PrintStream out)
print any results in the statement. |
protected void |
runStatements(java.io.Reader reader,
java.io.PrintStream out)
Read the statements from the .sql file and execute them. |
void |
setAutocommit(boolean autocommit)
Set the autocommit flag for the DB connection. |
void |
setClasspath(org.apache.tools.ant.types.Path classpath)
Set the classpath for loading the driver. |
void |
setClasspathRef(org.apache.tools.ant.types.Reference r)
Set the classpath for loading the driver using the classpath reference. |
void |
setDelimiter(java.lang.String delimiter)
Set the statement delimiter. |
void |
setDelimiterType(TorqueSQLExec.DelimiterType delimiterType)
Set the Delimiter type for this sql task. |
void |
setDriver(java.lang.String driver)
Set the JDBC driver to be used. |
void |
setEncoding(java.lang.String encoding)
Set the file encoding to use on the sql files read in |
void |
setOnerror(TorqueSQLExec.OnError action)
Set the action to perform onerror |
void |
setOutput(java.io.File output)
Set the output file. |
void |
setPassword(java.lang.String password)
Set the password for the DB connection. |
void |
setPrint(boolean print)
Set the print flag. |
void |
setRdbms(java.lang.String vendor)
Set the rdbms required |
void |
setShowheaders(boolean showheaders)
Set the showheaders flag. |
void |
setSqlDbMap(java.lang.String sqldbmap)
Set the sqldbmap properties file. |
void |
setSrcDir(java.lang.String srcDir)
Set the src directory for the sql files listed in the sqldbmap file. |
void |
setUrl(java.lang.String url)
Set the DB connection url. |
void |
setUserid(java.lang.String userId)
Set the user name for the DB connection. |
void |
setVersion(java.lang.String version)
Set the version required |
Methods inherited from class org.apache.tools.ant.Task |
---|
bindToOwner, getOwningTarget, getRuntimeConfigurableWrapper, getTaskName, getTaskType, getWrapper, handleErrorFlush, handleErrorOutput, handleFlush, handleInput, handleOutput, init, isInvalid, log, log, log, log, maybeConfigure, perform, reconfigure, setOwningTarget, setRuntimeConfigurableWrapper, setTaskName, setTaskType |
Methods inherited from class org.apache.tools.ant.ProjectComponent |
---|
clone, getDescription, getLocation, getProject, setDescription, setLocation, setProject |
Methods inherited from class java.lang.Object |
---|
equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public TorqueSQLExec()
Method Detail |
---|
public void setSqlDbMap(java.lang.String sqldbmap)
sqldbmap
- filename for the sqldbmappublic java.io.File getSqlDbMap()
public void setSrcDir(java.lang.String srcDir)
srcDir
- sql source directorypublic java.lang.String getSrcDir()
public void setClasspath(org.apache.tools.ant.types.Path classpath)
classpath
- the classpathpublic org.apache.tools.ant.types.Path createClasspath()
public void setClasspathRef(org.apache.tools.ant.types.Reference r)
r
- reference to the classpathpublic void addText(java.lang.String sql)
sql
- sql command to executepublic void setDriver(java.lang.String driver)
driver
- driver class namepublic void setUrl(java.lang.String url)
url
- connection urlpublic void setUserid(java.lang.String userId)
userId
- database userpublic void setEncoding(java.lang.String encoding)
encoding
- the encoding to use on the filespublic void setPassword(java.lang.String password)
password
- database passwordpublic void setAutocommit(boolean autocommit)
autocommit
- the autocommit flagpublic void setDelimiter(java.lang.String delimiter)
For example, set this to "go" and delimitertype to "ROW" for Sybase ASE or MS SQL Server.
delimiter
- public void setDelimiterType(TorqueSQLExec.DelimiterType delimiterType)
delimiterType
- public void setPrint(boolean print)
print
- public void setShowheaders(boolean showheaders)
showheaders
- public void setOutput(java.io.File output)
output
- public void setRdbms(java.lang.String vendor)
vendor
- public void setVersion(java.lang.String version)
version
- public void setOnerror(TorqueSQLExec.OnError action)
action
- public void execute() throws org.apache.tools.ant.BuildException
execute
in class org.apache.tools.ant.Task
org.apache.tools.ant.BuildException
protected void runStatements(java.io.Reader reader, java.io.PrintStream out) throws java.sql.SQLException, java.io.IOException
reader
- out
-
java.sql.SQLException
java.io.IOException
protected boolean isValidRdbms(java.sql.Connection conn)
conn
- protected void execSQL(java.lang.String sql, java.io.PrintStream out) throws java.sql.SQLException
sql
- out
-
java.sql.SQLException
protected void printResults(java.io.PrintStream out) throws java.sql.SQLException
out
-
java.sql.SQLException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |