Package scriptella.driver.mysql

MySQL Driver(Connector/J) adapter for Scriptella.

See: Description

Class Summary

Class	Description
Driver	Scriptella Adapter for MySQL database.

Package scriptella.driver.mysql Description

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>