mysql-jdbc: add new packages to [pcr]

4 files changed, 1028 insertions, 0 deletions

diff --git a/pcr/mysql-jdbc/PKGBUILD b/pcr/mysql-jdbc/PKGBUILD
new file mode 100644
index 000000000..16c46a53e
--- /dev/null
+++ b/pcr/mysql-jdbc/PKGBUILD
@@ -0,0 +1,62 @@
+# Maintainer: Omar Vega Ramos <ovruni@gnu.org.pe>
+
+_libname=mysql-connector-java
+pkgname=mysql-jdbc
+pkgver=5.1.39
+pkgrel=1.parabola1
+pkgdesc='The official JDBC driver for MySQL'
+arch=('any')
+url='https://dev.mysql.com/downloads/connector/j/'
+license=('GPL2')
+depends=('java-runtime')
+makedepends=('apache-ant' 'java-environment=8' 'jh' 'slf4j')
+install=mysql-jdbc.install
+source=("https://cdn.mysql.com/Downloads/Connector-J/${_libname}-$pkgver.tar.gz"
+        'mysql-connector-java-fix_build.patch'
+        'mysql-connector-java-java6_compilation.patch')
+md5sums=('c8988d4fc6e44364a2f51efe5b5139c1'
+         'c0273ce1c1257119bfa5a1485c382610'
+         '784dce5d9e81f365c16cd710797173ae')
+
+prepare() {
+  cd "$srcdir/${_libname}-$pkgver"
+  rm -v {,src/lib/}*.jar
+  rm -v src/lib/*.zip
+  rm -rv docs
+  patch -Np1 -i "$srcdir/mysql-connector-java-fix_build.patch"
+  patch -Np1 -i "$srcdir/mysql-connector-java-java6_compilation.patch"
+  ln -sf /usr/share/java/slf4j-api.jar src/lib/slf4j-api.jar
+}
+
+build() {
+  cd "$srcdir/${_libname}-$pkgver"
+  ant \
+    -Dcom.mysql.jdbc.jdk5.javac=/usr/lib/jvm/java-8-openjdk/bin/javac \
+    -Dcom.mysql.jdbc.jdk8.javac=/usr/lib/jvm/java-8-openjdk/bin/javac \
+    -Dsnapshot.version= \
+    -Dant.java.version=1.5 \
+    -Dant.build.javac.source=1.6 \
+    -Dant.build.javac.target=1.7
+}
+
+package() {
+  cd "$srcdir/${_libname}-$pkgver"
+
+  # Install license file
+  install -Dm644 COPYING "$pkgdir/usr/share/licenses/$pkgname/COPYING"
+
+  # Install Maven artifacts
+  export DESTDIR="$pkgdir"
+  jh mvn-install mysql mysql-connector-java $pkgver \
+    "build/${_libname}-$pkgver/doc/sources/pom.xml" \
+    "build/${_libname}-$pkgver/${_libname}-$pkgver-bin.jar" \
+    "${_libname}-$pkgver.jar"
+  ln -s "/usr/share/java/${_libname}-$pkgver.jar" \
+    "$pkgdir/usr/share/java/${_libname}.jar"
+  ln -s "/usr/share/java/${_libname}-$pkgver.jar" \
+    "$pkgdir/usr/share/java/mysql.jar"
+
+  install -d "$pkgdir/usr/share/java/$pkgname"
+  ln -s "/usr/share/java/${_libname}-$pkgver.jar" \
+    "$pkgdir/usr/share/java/$pkgname/${_libname}.jar"
+}
diff --git a/pcr/mysql-jdbc/mysql-connector-java-fix_build.patch b/pcr/mysql-jdbc/mysql-connector-java-fix_build.patch
new file mode 100644
index 000000000..c0fc7ff7f
--- /dev/null
+++ b/pcr/mysql-jdbc/mysql-connector-java-fix_build.patch
@@ -0,0 +1,43 @@
+--- mysql-connector-java-5.1.39.orig/build.xml	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/build.xml	2016-07-17 06:18:25.500065409 -0500
+@@ -244,13 +244,6 @@
+                 </not>
+             </condition>
+         </fail>
+-        <fail message="Hibernate libraries, required for build tasks, must be in the directory '${com.mysql.jdbc.extra.libs}/hibernate4'.">
+-            <condition>
+-                <not>
+-                    <available file="${com.mysql.jdbc.extra.libs}/hibernate4" type="dir" />
+-                </not>
+-            </condition>
+-        </fail>
+     </target>
+ 
+ 
+@@ -413,7 +406,7 @@
+ 
+ 
+     <!-- Prepares files and settings for compiling driver. -->
+-    <target name="init" depends="-compiler-check, -init-copy, -init-filter-license, -init-no-crypto">
++    <target name="init" depends="-init-copy, -init-filter-license, -init-no-crypto">
+         <!-- The following is needed for source distributions as the classpath can't be dynamically altered, and not having this directory present causes the
+              build to fail. -->
+         <available file="${com.mysql.jdbc.docs.sourceDir}" property="com.mysql.jdbc.docs.sourcesPresent" />
+@@ -833,7 +826,7 @@
+     <!-- Compile the driver including JDBC 3 and JDBC 4+ implementations, JUnit test suite and 'helpers' for third-party software. -->
+     <target name="compile"
+             description="Compiles driver including JDBC 3 and JDBC 4+ implementations, JUnit test suite and integration 'helpers' for third-party software."
+-            depends="init, compile-driver, compile-testsuite, compile-integration" />
++            depends="init, compile-driver, compile-integration" />
+ 
+ 
+     <!-- Compile the driver including JDBC 3 and JDBC 4+ implementations only. -->
+@@ -887,8 +880,6 @@
+                bootclasspath="${com.mysql.jdbc.jre6.rtjar}"
+                source="1.6"
+                target="1.6">
+-            <include name="**/FabricMultiTenantConnectionProvider.java" />
+-            <include name="**/HibernateFabric.java" />
+             <include name="**/JDBC4*.java" />
+             <exclude name="**/JDBC42*.java" />
+             <include name="com/mysql/jdbc/exceptions/jdbc4/*" />
diff --git a/pcr/mysql-jdbc/mysql-connector-java-java6_compilation.patch b/pcr/mysql-jdbc/mysql-connector-java-java6_compilation.patch
new file mode 100644
index 000000000..395091d56
--- /dev/null
+++ b/pcr/mysql-jdbc/mysql-connector-java-java6_compilation.patch
@@ -0,0 +1,905 @@
+--- mysql-connector-java-5.1.39.orig/src/com/mysql/fabric/jdbc/FabricMySQLConnectionProxy.java	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/src/com/mysql/fabric/jdbc/FabricMySQLConnectionProxy.java	2016-07-17 05:15:31.917492424 -0500
+@@ -3069,4 +3069,36 @@
+ 
+     public void decachePreparedStatement(ServerPreparedStatement pstmt) throws SQLException {
+     }
++
++    public java.sql.Clob createClob() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.Blob createBlob() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.NClob createNClob() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.SQLXML createSQLXML() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setClientInfo(String name, String value) throws java.sql.SQLClientInfoException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setClientInfo(Properties properties) throws java.sql.SQLClientInfoException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.Array createArrayOf(String typeName, Object[] elements) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.Struct createStruct(String typeName, Object[] attributes) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
+ }
+--- mysql-connector-java-5.1.39.orig/src/com/mysql/fabric/jdbc/FabricMySQLDriver.java	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/src/com/mysql/fabric/jdbc/FabricMySQLDriver.java	2016-07-17 05:16:58.383499044 -0500
+@@ -103,7 +103,7 @@
+         return super.parseURL(url.replaceAll("fabric:", ""), defaults);
+     }
+ 
+-    public Logger getParentLogger() throws SQLException {
+-        throw new SQLException("no logging");
++    public Logger getParentLogger() throws java.sql.SQLFeatureNotSupportedException {
++        throw new java.sql.SQLFeatureNotSupportedException("no logging");
+     }
+ }
+--- mysql-connector-java-5.1.39.orig/src/com/mysql/jdbc/CallableStatement.java	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/src/com/mysql/jdbc/CallableStatement.java	2016-07-17 05:19:02.354440189 -0500
+@@ -2383,6 +2383,90 @@
+         }
+     }
+ 
++    public java.sql.RowId getRowId(int parameterIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.RowId getRowId(String parameterName) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setRowId(String parameterName, java.sql.RowId x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNString(String parameterName, String value) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNClob(String parameterName, java.sql.NClob value) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNClob(String parameterName, Reader reader, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.NClob getNClob(int parameterIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.NClob getNClob(String parameterName) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setSQLXML(String parameterName, java.sql.SQLXML xmlObject) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.SQLXML getSQLXML(int parameterIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.SQLXML getSQLXML(String parameterName) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public String getNString(int parameterIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public String getNString(String parameterName) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public Reader getNCharacterStream(int parameterIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public Reader getNCharacterStream(String parameterName) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public Reader getCharacterStream(int parameterIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public Reader getCharacterStream(String parameterName) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNClob(String parameterName, Reader reader) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setRowId(int parameterIndex, java.sql.RowId x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNClob(int parameterIndex, java.sql.NClob value) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
+     /**
+      * JDBC 4.2
+      */
+--- mysql-connector-java-5.1.39.orig/src/com/mysql/jdbc/ConnectionImpl.java	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/src/com/mysql/jdbc/ConnectionImpl.java	2016-07-17 05:21:55.543108244 -0500
+@@ -5550,4 +5550,56 @@
+     public void setProfilerEventHandlerInstance(ProfilerEventHandler h) {
+         this.eventSink = h;
+     }
++
++    public java.sql.Clob createClob() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.Blob createBlob() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.NClob createNClob() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.SQLXML createSQLXML() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public boolean isValid(int timeout) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setClientInfo(String name, String value) throws java.sql.SQLClientInfoException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setClientInfo(Properties properties) throws java.sql.SQLClientInfoException {
++        throw new UnsupportedOperationException();
++    }
++
++    public String getClientInfo(String name) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public Properties getClientInfo() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.Array createArrayOf(String typeName, Object[] elements) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.Struct createStruct(String typeName, Object[] attributes) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public <T> T unwrap(Class<T> iface) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public boolean isWrapperFor(Class<?> iface) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
+ }
+--- mysql-connector-java-5.1.39.orig/src/com/mysql/jdbc/DatabaseMetaData.java	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/src/com/mysql/jdbc/DatabaseMetaData.java	2016-07-17 05:23:11.529598855 -0500
+@@ -7892,6 +7892,22 @@
+         return pStmt;
+     }
+ 
++    public java.sql.RowIdLifetime getRowIdLifetime() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public boolean autoCommitFailureClosesAllResultSets() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public <T> T unwrap(Class<T> iface) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public boolean isWrapperFor(Class<?> iface) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
+     /**
+      * JDBC-4.1
+      * 
+--- mysql-connector-java-5.1.39.orig/src/com/mysql/jdbc/MultiHostMySQLConnection.java	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/src/com/mysql/jdbc/MultiHostMySQLConnection.java	2016-07-17 05:24:31.822557240 -0500
+@@ -2482,4 +2482,56 @@
+     public boolean isUseSSLExplicit() {
+         return getActiveMySQLConnection().isUseSSLExplicit();
+     }
++
++    public java.sql.Clob createClob() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.Blob createBlob() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.NClob createNClob() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.SQLXML createSQLXML() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public boolean isValid(int timeout) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setClientInfo(String name, String value) throws java.sql.SQLClientInfoException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setClientInfo(Properties properties) throws java.sql.SQLClientInfoException {
++        throw new UnsupportedOperationException();
++    }
++
++    public String getClientInfo(String name) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public Properties getClientInfo() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.Array createArrayOf(String typeName, Object[] elements) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.Struct createStruct(String typeName, Object[] attributes) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public <T> T unwrap(Class<T> iface) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public boolean isWrapperFor(Class<?> iface) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
+ }
+--- mysql-connector-java-5.1.39.orig/src/com/mysql/jdbc/NonRegisteringDriver.java	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/src/com/mysql/jdbc/NonRegisteringDriver.java	2016-07-17 05:25:09.227683283 -0500
+@@ -906,4 +906,9 @@
+             }
+         }
+     }
++
++    @Override
++    public java.util.logging.Logger getParentLogger() throws java.sql.SQLFeatureNotSupportedException {
++        throw new java.sql.SQLFeatureNotSupportedException();
++    }
+ }
+--- mysql-connector-java-5.1.39.orig/src/com/mysql/jdbc/PreparedStatement.java	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/src/com/mysql/jdbc/PreparedStatement.java	2016-07-17 05:26:06.491705246 -0500
+@@ -5090,6 +5090,18 @@
+                 && StringUtils.indexOfIgnoreCase(statementStartPos, sql, "SELECT", "\"'`", "\"'`", StringUtils.SEARCH_MODE__MRK_COM_WS) == -1;
+     }
+ 
++    public void setRowId(int parameterIndex, java.sql.RowId x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNClob(int parameterIndex, java.sql.NClob value) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
+     /**
+      * JDBC 4.2
+      * Same as PreparedStatement.executeUpdate() but returns long instead of int.
+--- mysql-connector-java-5.1.39.orig/src/com/mysql/jdbc/ResultSetImpl.java	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/src/com/mysql/jdbc/ResultSetImpl.java	2016-07-17 05:27:49.680272879 -0500
+@@ -7918,4 +7918,200 @@
+     protected ExceptionInterceptor getExceptionInterceptor() {
+         return this.exceptionInterceptor;
+     }
++
++    public java.sql.RowId getRowId(int columnIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.RowId getRowId(String columnLabel) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateRowId(int columnIndex, java.sql.RowId x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateRowId(String columnLabel, java.sql.RowId x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public int getHoldability() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateNString(int columnIndex, String nString) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateNString(String columnLabel, String nString) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateNClob(int columnIndex, java.sql.NClob nClob) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateNClob(String columnLabel, java.sql.NClob nClob) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.NClob getNClob(int columnIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.NClob getNClob(String columnLabel) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.SQLXML getSQLXML(int columnIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.SQLXML getSQLXML(String columnLabel) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateSQLXML(String columnLabel, java.sql.SQLXML xmlObject) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public String getNString(int columnIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public String getNString(String columnLabel) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.io.Reader getNCharacterStream(int columnIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.io.Reader getNCharacterStream(String columnLabel) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateNCharacterStream(int columnIndex, java.io.Reader x, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateNCharacterStream(String columnLabel, java.io.Reader reader, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateAsciiStream(int columnIndex, InputStream x, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateBinaryStream(int columnIndex, InputStream x, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateCharacterStream(int columnIndex, java.io.Reader x, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateAsciiStream(String columnLabel, InputStream x, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateBinaryStream(String columnLabel, InputStream x, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateCharacterStream(String columnLabel, java.io.Reader reader, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateBlob(int columnIndex, InputStream inputStream, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateBlob(String columnLabel, InputStream inputStream, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateClob(int columnIndex, java.io.Reader reader, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateClob(String columnLabel, java.io.Reader reader, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateNClob(int columnIndex, java.io.Reader reader, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateNClob(String columnLabel, java.io.Reader reader, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateNCharacterStream(int columnIndex, java.io.Reader x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateNCharacterStream(String columnLabel, java.io.Reader reader) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateAsciiStream(int columnIndex, InputStream x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateBinaryStream(int columnIndex, InputStream x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateCharacterStream(int columnIndex, java.io.Reader x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateAsciiStream(String columnLabel, InputStream x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateBinaryStream(String columnLabel, InputStream x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateCharacterStream(String columnLabel, java.io.Reader reader) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateBlob(int columnIndex, InputStream inputStream) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateBlob(String columnLabel, InputStream inputStream) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateClob(int columnIndex, java.io.Reader reader) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateClob(String columnLabel, java.io.Reader reader) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateNClob(int columnIndex, java.io.Reader reader) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void updateNClob(String columnLabel, java.io.Reader reader) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public <T> T unwrap(Class<T> iface) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public boolean isWrapperFor(Class<?> iface) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
+ }
+--- mysql-connector-java-5.1.39.orig/src/com/mysql/jdbc/jdbc2/optional/CallableStatementWrapper.java	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/src/com/mysql/jdbc/jdbc2/optional/CallableStatementWrapper.java	2016-07-17 05:30:32.052773805 -0500
+@@ -1498,6 +1498,142 @@
+ 
+         return null;
+     }
++
++    public java.sql.RowId getRowId(int parameterIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.RowId getRowId(String parameterName) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setRowId(String parameterName, java.sql.RowId x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNString(String parameterName, String value) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNCharacterStream(String parameterName, Reader value, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNClob(String parameterName, java.sql.NClob value) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setClob(String parameterName, Reader reader, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setBlob(String parameterName, InputStream inputStream, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNClob(String parameterName, Reader reader, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.NClob getNClob(int parameterIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.NClob getNClob(String parameterName) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setSQLXML(String parameterName, java.sql.SQLXML xmlObject) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.SQLXML getSQLXML(int parameterIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.SQLXML getSQLXML(String parameterName) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public String getNString(int parameterIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public String getNString(String parameterName) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public Reader getNCharacterStream(int parameterIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public Reader getNCharacterStream(String parameterName) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public Reader getCharacterStream(int parameterIndex) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public Reader getCharacterStream(String parameterName) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setBlob(String parameterName, Blob x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setClob(String parameterName, Clob x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setAsciiStream(String parameterName, InputStream x, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setBinaryStream(String parameterName, InputStream x, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setCharacterStream(String parameterName, Reader reader, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setAsciiStream(String parameterName, InputStream x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setBinaryStream(String parameterName, InputStream x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setCharacterStream(String parameterName, Reader reader) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNCharacterStream(String parameterName, Reader value) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setClob(String parameterName, Reader reader) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setBlob(String parameterName, InputStream inputStream) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNClob(String parameterName, Reader reader) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public <T> T getObject(int parameterIndex, Class<T> type) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public <T> T getObject(String parameterName, Class<T> type) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
+     //
+     //	public Reader getCharacterStream(int parameterIndex) throws SQLException {
+     //		try {
+--- mysql-connector-java-5.1.39.orig/src/com/mysql/jdbc/jdbc2/optional/ConnectionWrapper.java	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/src/com/mysql/jdbc/jdbc2/optional/ConnectionWrapper.java	2016-07-17 05:31:56.025562240 -0500
+@@ -2885,4 +2885,56 @@
+     public boolean isUseSSLExplicit() {
+         return this.mc.isUseSSLExplicit();
+     }
++
++    public java.sql.Clob createClob() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.Blob createBlob() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.NClob createNClob() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.SQLXML createSQLXML() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public boolean isValid(int timeout) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setClientInfo(String name, String value) throws java.sql.SQLClientInfoException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setClientInfo(Properties properties) throws java.sql.SQLClientInfoException {
++        throw new UnsupportedOperationException();
++    }
++
++    public String getClientInfo(String name) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public Properties getClientInfo() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.Array createArrayOf(String typeName, Object[] elements) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public java.sql.Struct createStruct(String typeName, Object[] attributes) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public <T> T unwrap(Class<T> iface) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public boolean isWrapperFor(Class<?> iface) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
+ }
+--- mysql-connector-java-5.1.39.orig/src/com/mysql/jdbc/jdbc2/optional/MysqlDataSource.java	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/src/com/mysql/jdbc/jdbc2/optional/MysqlDataSource.java	2016-07-17 05:33:16.355185599 -0500
+@@ -429,4 +429,16 @@
+     //	public <T> T unwrap(Class<T> iface) throws SQLException {
+     //		throw SQLError.createSQLFeatureNotSupportedException();
+     //	}
++
++    public java.util.logging.Logger getParentLogger() throws java.sql.SQLFeatureNotSupportedException {
++        throw new java.sql.SQLFeatureNotSupportedException();
++    }
++
++    public <T> T unwrap(Class<T> iface) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public boolean isWrapperFor(Class<?> iface) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
+ }
+--- mysql-connector-java-5.1.39.orig/src/com/mysql/jdbc/jdbc2/optional/MysqlPooledConnection.java	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/src/com/mysql/jdbc/jdbc2/optional/MysqlPooledConnection.java	2016-07-17 05:34:48.497596725 -0500
+@@ -33,6 +33,7 @@
+ import javax.sql.ConnectionEvent;
+ import javax.sql.ConnectionEventListener;
+ import javax.sql.PooledConnection;
++import javax.sql.StatementEventListener;
+ 
+ import com.mysql.jdbc.ExceptionInterceptor;
+ import com.mysql.jdbc.SQLError;
+@@ -230,4 +231,14 @@
+     protected ExceptionInterceptor getExceptionInterceptor() {
+         return this.exceptionInterceptor;
+     }
++
++    @Override
++    public void addStatementEventListener(javax.sql.StatementEventListener listener) {
++        throw new UnsupportedOperationException();
++    }
++
++    @Override
++    public void removeStatementEventListener(javax.sql.StatementEventListener listener) {
++        throw new UnsupportedOperationException();
++    }
+ }
+\ No newline at end of file
+--- mysql-connector-java-5.1.39.orig/src/com/mysql/jdbc/jdbc2/optional/PreparedStatementWrapper.java	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/src/com/mysql/jdbc/jdbc2/optional/PreparedStatementWrapper.java	2016-07-17 05:38:08.798345958 -0500
+@@ -567,6 +567,78 @@
+         return buf.toString();
+     }
+ 
++    public void setRowId(int parameterIndex, java.sql.RowId x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNString(int parameterIndex, String value) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNCharacterStream(int parameterIndex, Reader value, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNClob(int parameterIndex, java.sql.NClob value) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setClob(int parameterIndex, Reader reader, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setBlob(int parameterIndex, InputStream inputStream, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNClob(int parameterIndex, Reader reader, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setAsciiStream(int parameterIndex, InputStream x, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setBinaryStream(int parameterIndex, InputStream x, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setAsciiStream(int parameterIndex, InputStream x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setBinaryStream(int parameterIndex, InputStream x) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setCharacterStream(int parameterIndex, Reader reader) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNCharacterStream(int parameterIndex, Reader value) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setClob(int parameterIndex, Reader reader) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setBlob(int parameterIndex, InputStream inputStream) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setNClob(int parameterIndex, Reader reader) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
+     //
+     //	public void setAsciiStream(int parameterIndex, InputStream x)
+     //			throws SQLException {
+--- mysql-connector-java-5.1.39.orig/src/com/mysql/jdbc/jdbc2/optional/StatementWrapper.java	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/src/com/mysql/jdbc/jdbc2/optional/StatementWrapper.java	2016-07-17 05:39:28.971309886 -0500
+@@ -581,6 +581,34 @@
+         }
+     }
+ 
++    public void closeOnCompletion() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public boolean isCloseOnCompletion() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public boolean isClosed() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public void setPoolable(boolean poolable) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public boolean isPoolable() throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public <T> T unwrap(Class<T> iface) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
++    public boolean isWrapperFor(Class<?> iface) throws SQLException {
++        throw new UnsupportedOperationException();
++    }
++
+     /**
+      * JDBC 4.2
+      * Same as {@link #executeBatch()} but returns long[] instead of int[].
+--- mysql-connector-java-5.1.39.orig/src/com/mysql/jdbc/jdbc2/optional/SuspendableXAConnection.java	2016-05-04 06:11:40.000000000 -0500
++++ mysql-connector-java-5.1.39/src/com/mysql/jdbc/jdbc2/optional/SuspendableXAConnection.java	2016-07-17 05:40:38.431435246 -0500
+@@ -199,4 +199,12 @@
+             this.currentXAConnection.close();
+         }
+     }
++
++    public void addStatementEventListener(javax.sql.StatementEventListener listener) {
++        throw new UnsupportedOperationException();
++    }
++
++    public void removeStatementEventListener(javax.sql.StatementEventListener listener) {
++        throw new UnsupportedOperationException();
++    }
+ }
diff --git a/pcr/mysql-jdbc/mysql-jdbc.install b/pcr/mysql-jdbc/mysql-jdbc.install
new file mode 100644
index 000000000..00be3f6c7
--- /dev/null
+++ b/pcr/mysql-jdbc/mysql-jdbc.install
@@ -0,0 +1,18 @@
+post_install() {
+  cat<<EOF
+To use the mysql-jdbc with LibreOffice (OpenOffice.org) you must register the class in OO.
+
+1) Open OO by typing soffice
+2) Click on Tools -> Options then expand the OpenOffice.org tree and select java
+3) Click the button 'Class Path' and then 'Add Archive'
+4) Browse to the file mysql-connector-java.jar located in /usr/share/java/mysql-jdbc
+5) Select the file then just click OK
+6) Restart OO to activate changes
+
+Enjoy!
+EOF
+}
+
+post_upgrade() {
+  post_install
+}