Package scriptella.driver.mysql

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

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

General information

Driver class:scriptella.driver.mysql.Driver
URL:Same as for MySQL JDBC Driver.
Runtime dependencies: mysql-connector-java.jar

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.