Package scriptella.driver.mysql

package scriptella.driver.mysql
MySQL Connector/J adapter for Scriptella.

See Overview of JDBC package for a description of common features and connection properties.

See the core database compatibility matrix for the current validation target and status.

General information

Driver class:scriptella.driver.mysql.Driver
JDBC driver class:com.mysql.cj.jdbc.Driver
URL:jdbc:mysql://host:3306/database
Runtime dependencies: MySQL Connector/J (mysql-connector-j-VERSION.jar), supplied through the connection classpath.

Driver Specific Properties

Name Description Required
statement.fetchSize For MySQL, set the value of this property to Integer.MIN_VALUE, in order to avoid loading all rows into memory: 
statement.fetchSize = -2147483648
See MySQL bug #18148. 		No, default value is determined by Connector/J JDBC driver.

Examples

    <connection driver="mysql" url="jdbc:mysql://localhost:3306/test" user="username" password="password">
    </connection>
The following example specifies a custom delimiter for statements. This feature is similar to MySQL client ""DELIMITER" command.
Notes:
  • Delimiter is declared once and cannot be changed, so a separate connection might be necessary for processing SQL with a different delimiter.
  • DELIMITER command should not be used in scripts and queries. 
    <connection driver="mysql" url="jdbc:mysql://localhost:3306/test" user="username" password="password">
         statement.separator=$$ 
    </connection>
  • Classes
    Class
    Description
    Driver
    Scriptella Adapter for MySQL database.