== All suites ==

The package comes with a testsuite that is disabled by default.

With a few fixes I'll work:
 * src/testsuite/regression/StatementRegressionTest.java: drop testBug33823 (conflict with Debian patches)
 * src/testsuite/regression/StatementRegressionTest.java: {{{pStmt.setClob(1, null); -> pStmt.setClob(1, (Clob)null);}}}
 * build.xml: drop {{{-testsuite-jvm-check}}} in target {{{test}}}

Prepare MySQL server:
 * {{{apt-get install mysql-server}}}
 * Enable SSL: {{{
cd src/testsuite/ssl-test-certs/
cp -a ca-cert.pem server-cert.pem server-key.pem /etc/mysql/
cd /etc/mysql/
chmod -R go= *.pem
chown mysql: *.pem
}}}
 * {{{/etc/mysql/my.cnf}}} / {{{/etc/mysql/mariadb.conf.d/50-server.cnf:max_allowed_packet}}}: {{{
# for BlobRegressionTest, simple.ConnectionTest
max_allowed_packet      = 64M
innodb_log_file_size    = 640M

ssl-ca=/etc/mysql/ca-cert.pem
ssl-cert=/etc/mysql/server-cert.pem
ssl-key=/etc/mysql/server-key.pem
}}}
 * {{{mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql mysql}}}
 * {{{CREATE DATABASE testDB;}}}
 * {{{GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root';}}}
 * Stop/start MySQL

If you need to investigate a stuck/long test:
{{{
        <junit printsummary="yes"
         showoutput="yes" enabletestlistenerevents="true"
}}}

Additional build dependencies: {{{
apt-get install libjboss-connector-java  # or grab from wheezy
cp -a /usr/share/java/junit-3.8.2.jar lib/
cp -a /usr/share/java/jboss-connector-4.2.3.GA.jar lib/
}}}

Old RefFSContextFactory JNDI class that isn't bundled anymore, for {{{testsuite.simple.DataSourceTest,testsuite.regression.DataSourceRegressionTest}}}:
 * https://www.oracle.com/java/technologies/java-archive-downloads-java-plat-downloads.html#7110-jndi-1.2.1-oth-JPR
 * click fscontext-1_2-beta3.zip, accept license to set download cookie, ignore sign-on form
 * https://download.oracle.com/otn-pub/java/jndi/1.2.1/fscontext-1_2-beta3.zip
 * or: {{{curl -L -b oraclelicense=140 http://download.oracle.com/otn-pub/java/jndi/1.2.1/fscontext-1_2-beta3.zip > fscontext.zip}}}
 * {{{unzip fscontext-1_2-beta3.zip lib/fscontext.jar lib/providerutil.jar}}}

Prepare environment: {{{
quilt push -a
JAVA_HOME=/usr/lib/jvm/default-java
}}}

Run the testsuite: {{{
ant \
  -Dcom.mysql.jdbc.jdk5.javac=$JAVA_HOME/bin/javac \
  -Dcom.mysql.jdbc.jdk8.javac=$JAVA_HOME/bin/javac \
  -Dsnapshot.version= \
  -Dcom.mysql.jdbc.extra.libs=lib \
  -Dant.java.version=1.5 \
  -Dant.build.javac.source=1.6 \
  -Dant.build.javac.target=1.6 \
  \
  -Dcom.mysql.jdbc.testsuite.url='jdbc:mysql://localhost/testDB?user=root&password=root&serverTimezone=UTC' \
  -Dcom.mysql.jdbc.testsuite.jvm=$JAVA_HOME \
  -Dcom.mysql.jdbc3.testsuite.jvm.java=$JAVA_HOME/bin/java \
  -Dcom.mysql.jdbc4.testsuite.jvm.java=$JAVA_HOME/bin/java \
  -Dcom.mysql.jdbc42.testsuite.jvm.java=$JAVA_HOME/bin/java \
  -Dcom.mysql.jdbc.noCleanBetweenCompiles=true \
  compile-testsuite test
}}}

To select specific tests: {{{
-Dtest=testsuite.simple.StringUtilsTest
-Dtest=testsuite.simple.ConnectionTest -Dmethods=testCacheDefaultTimezone 
}}}

The test suite should run in ~15mn.

There are some errors, make sure there are no more than in the previous upload. 

See also: https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-testing.html