scriptella.driver.mysql.package.html Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of scriptella-drivers Show documentation

The newest version!


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>

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