Examples of org.apache.tools.ant.taskdefs.SQLExec

org.apache.tools.ant.taskdefs.SQLExec
EM at the start of the line.

The autocommit attribute specifies whether auto-commit should be turned on or off whilst executing the statements. If auto-commit is turned on each statement will be executed and committed. If it is turned off the statements will all be executed as one transaction.

The onerror attribute specifies how to proceed when an error occurs during the execution of one of the statements. The possible values are: continue execution, only show the error; stop execution and commit transaction; and abort execution and transaction and fail task.
@since Ant 1.2 @ant.task name="sql" category="database"

            writeCompressedText(scriptFile, _creationScript);


            project.setBasedir(tmpDir.getAbsolutePath());


            // we use the ant task 'sql' to perform the creation script
          SQLExec         sqlTask = new SQLExec();
          SQLExec.OnError onError = new SQLExec.OnError();
  
          onError.setValue("continue");
          sqlTask.setProject(project);
          sqlTask.setAutocommit(true);
          sqlTask.setDriver(_jcd.getDriver());
          sqlTask.setOnerror(onError);
          sqlTask.setUserid(_jcd.getUserName());
          sqlTask.setPassword(_jcd.getPassWord() == null ? "" : _jcd.getPassWord());
          sqlTask.setUrl(getDBCreationUrl());
          sqlTask.setSrc(scriptFile);
          sqlTask.execute();


          deleteDir(tmpDir);
        }
        catch (Exception ex)
        {

View Full Code Here

            writeCompressedText(scriptFile, _creationScript);


            project.setBasedir(tmpDir.getAbsolutePath());


            // we use the ant task 'sql' to perform the creation script
          SQLExec         sqlTask = new SQLExec();
          SQLExec.OnError onError = new SQLExec.OnError();
  
          onError.setValue("continue");
          sqlTask.setProject(project);
          sqlTask.setAutocommit(true);
          sqlTask.setDriver(_jcd.getDriver());
          sqlTask.setOnerror(onError);
          sqlTask.setUserid(_jcd.getUserName());
          sqlTask.setPassword(_jcd.getPassWord() == null ? "" : _jcd.getPassWord());
          sqlTask.setUrl(getDBCreationUrl());
          sqlTask.setSrc(scriptFile);
          sqlTask.execute();


          deleteDir(tmpDir);
        }
        catch (Exception ex)
        {

View Full Code Here

TOP

Related Classes of org.apache.tools.ant.taskdefs.SQLExec

org.apache.ojb.broker.util.dbhandling.TorqueDBHandling

org.apache.tools.ant.DirectoryScanner

org.apache.tools.ant.types.FileSet

org.apache.tools.ant.types.Resource

org.apache.tools.ant.types.resources.Appendable

org.apache.tools.ant.types.resources.FileProvider

org.apache.tools.ant.types.resources.FileResource

org.apache.tools.ant.types.resources.Union

java.sql.Blob

java.util.Iterator

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.