Package org.jumpmind.db.sql

Class SqlScript

java.lang.Object

org.jumpmind.db.sql.SqlScript

public class SqlScript
extends Object

This class parses and runs SQL from an input file or buffer using the designed ISqlTemplate.

Constructor Summary

Constructors

Constructor	Description
SqlScript(Reader reader, ISqlTemplate sqlTemplate, boolean failOnError, String delimiter, Map<String,String> replacementTokens)
SqlScript(String sqlScript, ISqlTemplate sqlTemplate, boolean failOnError, boolean failOnDrop, boolean failOnSequenceCreate, boolean triggersContainJava, String delimiter, Map<String,String> replacementTokens)
SqlScript(String sqlScript, ISqlTemplate sqlTemplate, boolean failOnError, boolean failOnDrop, boolean failOnSequenceCreate, String delimiter, Map<String,String> replacementTokens)
SqlScript(String sqlScript, ISqlTemplate sqlTemplate, boolean failOnError, Map<String,String> replacementTokens)
SqlScript(URL url, ISqlTemplate sqlTemplate)
SqlScript(URL url, ISqlTemplate sqlTemplate, boolean failOnError)
SqlScript(URL url, ISqlTemplate sqlTemplate, boolean failOnError, String delimiter, Map<String,String> replacementTokens)
SqlScript(URL url, ISqlTemplate sqlTemplate, String delimiter)

Method Summary

Modifier and Type	Method	Description
static int	calculateTotalStatements(String sqlScript, String delimiter, boolean triggersContainJava)
long	execute()
long	execute(boolean autoCommit)
int	getCommitRate()
boolean	isFailOnDrop()
boolean	isFailOnError()
boolean	isFailOnSequenceCreate()
void	setCommitRate(int commitRate)
void	setFailOnDrop(boolean failOnDrop)
void	setFailOnError(boolean failOnError)
void	setFailOnSequenceCreate(boolean failOnSequenceCreate)
void	setLineDeliminator(String lineDeliminator)
void	setListener(ISqlResultsListener listener)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

SqlScript

public SqlScript(URL url,
 ISqlTemplate sqlTemplate)

SqlScript

public SqlScript(URL url,
 ISqlTemplate sqlTemplate,
 boolean failOnError)

SqlScript

public SqlScript(URL url,
 ISqlTemplate sqlTemplate,
 String delimiter)

SqlScript

public SqlScript(URL url,
 ISqlTemplate sqlTemplate,
 boolean failOnError,
 String delimiter,
 Map<String,String> replacementTokens)

SqlScript

public SqlScript(String sqlScript,
 ISqlTemplate sqlTemplate,
 boolean failOnError,
 Map<String,String> replacementTokens)

SqlScript

public SqlScript(String sqlScript,
 ISqlTemplate sqlTemplate,
 boolean failOnError,
 boolean failOnDrop,
 boolean failOnSequenceCreate,
 String delimiter,
 Map<String,String> replacementTokens)

SqlScript

public SqlScript(String sqlScript,
 ISqlTemplate sqlTemplate,
 boolean failOnError,
 boolean failOnDrop,
 boolean failOnSequenceCreate,
 boolean triggersContainJava,
 String delimiter,
 Map<String,String> replacementTokens)

SqlScript

public SqlScript(Reader reader,
 ISqlTemplate sqlTemplate,
 boolean failOnError,
 String delimiter,
 Map<String,String> replacementTokens)

Method Details

execute

public long execute()

execute

public long execute(boolean autoCommit)

calculateTotalStatements

public static int calculateTotalStatements(String sqlScript,
 String delimiter,
 boolean triggersContainJava)

getCommitRate

public int getCommitRate()

setCommitRate

public void setCommitRate(int commitRate)

setLineDeliminator

public void setLineDeliminator(String lineDeliminator)

setListener

public void setListener(ISqlResultsListener listener)

setFailOnDrop

public void setFailOnDrop(boolean failOnDrop)

setFailOnSequenceCreate

public void setFailOnSequenceCreate(boolean failOnSequenceCreate)

isFailOnDrop

public boolean isFailOnDrop()

setFailOnError

public void setFailOnError(boolean failOnError)

isFailOnError

public boolean isFailOnError()

isFailOnSequenceCreate

public boolean isFailOnSequenceCreate()