====================
mysql-connector-java
====================

----------
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


| Copyright (C) 2020  Sylvain Beucler