torque:sqlExec

Full name:

org.apache.torque:torque-maven-plugin:3.3.1-SNAPSHOT:sqlExec

Description:

Executes the generated SQL.

Attributes:

  • Requires a Maven 2.0 project to be executed.
  • Binds by default to the lifecycle phase: generate-sources.

Required Parameters

Name Type Since Description
driver String - The fully qualified class name of the database driver.
onError String - Tells the Mojo what to do if an sql error occurs during execution. Can be either "continue", "stop" or "abort".
url String - The connect URL of the database.
user String - The user name to connect to the database.

Optional Parameters

Name Type Since Description
autocommit boolean - Autocommit flag. Default value is true.
delimiter String - The SQL Statement delimiter.
delimiterType String - Whether the delimiter can be anywhere in the sql ("normal") or needs to be in an extra row ("row").
password String - The password for the database user.
sqlDbMap String - The path to the properties file containing the mapping sql file -> target database.
srcDir String - The source directory where to find the SQL files.

Parameter Details

autocommit:

Autocommit flag. Default value is true.
  • Type: boolean
  • Required: No
  • Expression: true

delimiter:

The SQL Statement delimiter.
  • Type: java.lang.String
  • Required: No
  • Expression: ;

delimiterType:

Whether the delimiter can be anywhere in the sql ("normal") or needs to be in an extra row ("row").
  • Type: java.lang.String
  • Required: No
  • Expression: normal

driver:

The fully qualified class name of the database driver.
  • Type: java.lang.String
  • Required: Yes

onError:

Tells the Mojo what to do if an sql error occurs during execution. Can be either "continue", "stop" or "abort".
  • Type: java.lang.String
  • Required: Yes
  • Expression: continue

password:

The password for the database user.
  • Type: java.lang.String
  • Required: No

sqlDbMap:

The path to the properties file containing the mapping sql file -> target database.
  • Type: java.lang.String
  • Required: No
  • Expression: ${project.build.directory}/torque/sqldbmap.properties

srcDir:

The source directory where to find the SQL files.
  • Type: java.lang.String
  • Required: No
  • Expression: ${project.build.directory}/generated-sql/torque

url:

The connect URL of the database.
  • Type: java.lang.String
  • Required: Yes

user:

The user name to connect to the database.
  • Type: java.lang.String
  • Required: Yes