MySQL Forums
Forum List  »  Announcements

MySQL Connector/J 5.1.48 GA has been released
Posted by: Jocelyn Ramilison
Date: July 29, 2019 01:52PM

Dear MySQL Users,

MySQL Connector/J 5.1.48, a maintenance release of the production 5.1
branch has been released. Connector/J is the Type-IV pure-Java JDBC
driver for MySQL.

MySQL Connector/J is available in source and binary form from the
Connector/J download pages at
http://dev.mysql.com/downloads/connector/j/5.1.html
and mirror sites as well as Maven repositories.

MySQL Connector/J (Commercial) is available for download on the My Oracle
Support (MOS) website. This release will shortly be available on
eDelivery (OSDC).

As always, we recommend that you check the "CHANGES" file in the
download archive to be aware of changes in behavior that might affect
your application.

MySQL Connector/J 5.1.48 includes the following general bug fixes and
improvements, also available in more detail on
https://dev.mysql.com/doc/relnotes/connector-j/5.1/en/news-5-1-48.html


Changes in MySQL Connector/J 5.1.48 (2019-07-29, General Availability)

   Version 5.1.48 is a maintenance release of the production 5.1
   branch. It is suitable for use with MySQL Server versions
   5.6, 5.7, and 8.0. It supports the Java Database Connectivity
   (JDBC) 4.2 API.


Functionality Added or Changed


     * Important Change: For MySQL Server 8.0.14 and later,
       5.7.25 and later, 5.6.43 and later, and 5.5.63 and later,
       minimal permissions on named pipes are granted to clients
       that use them to connect to the server. Connector/J,
       however, can only use named pipes when granted full
       access on them. As a workaround, the MySQL Server that
       Connector/J wants to connect to must be started with the
       system variable named_pipe_full_access_group; see the
       description for the system variable for more details.
       (Bug #28971500)

     * The collation utf8mb4_zh_0900_as_cs has been added to the
       CharsetMapping class. (Bug #29244101)

     * The list of MySQL Server reserved words, stored as the
       MYSQL_KEYWORDS string in the DatabaseMetaData class, has
       been updated. (Bug #28268619, Bug #91435)

     * A number of private parameters of ProfilerEvents (for
       example, hostname) had no getters for accessing them from
       outside of the class instance. Getter methods have now
       been added for all the parameters of the class. (Bug
       #20010454, Bug #74690)

     * Added support for the utf8mb4_0900_bin collation, which
       is now supported by MySQL Server 8.0.17.

Bugs Fixed


     * When a CallableStatement was used to call a stored
       procedure or function that did not exist on the server or
       that the client had no rights to access its parameters'
       metadata, Connector/J tried to infer the parameter
       metadata from the SQL call string itself, but did so
       wrongly. It was because Connector/J did not distinguish
       between a stored procedure and a stored function in its
       inference, and this fix makes Connector/J do so now. (Bug
       #29907618)

     * ResultSetMetaData.getTableName() returned null when no
       applicable results could be returned for a column.
       However, the JDBC documentation specified an empty string
       to be returned in that case. This fix makes the method
       behave as documented. The same correction has been made
       for getCatalogName() and getSchemaName(). (Bug #29452669,
       Bug #94585)

     * Because the SHOW PROCESSLIST
       (https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html)
       statement might cause the server to fail sometimes,
       Connector/J now avoids using the statement, but queries
       the performance scheme instead for the information it
       needs. (Bug #29329326)

     * Enabling logSlowQueries resulted in many unnecessary
       calls of LogUtils.findCallingClassAndMethod(). With this
       fix, LogUtils.findCallingClassAndMethod() is called only
       when profileSQL is true and even in that case, the number
       of calls are reduced to a minimal to avoid the excessive
       stack trace data the function used to generate. Thanks to
       Florian Agsteiner for contributing to the fix. (Bug
       #29277648, Bug #94101, Bug #17640628, Bug #70677)

     * For an SSL connection, after a client disconnected from a
       server by calling Connection.close(), the TCP connection
       remained in the TIME_WAIT
(https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html)
       state on the server side. With this fix, the connection
       remains in the TIME_WAIT
(https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html)
       state on the client side instead, in most cases.
       (Bug #29054329, Bug #93590)

     * A memory leak occurred if Connector/J was loaded via the
       bootstrap class path instead of the main application
       classpath. It was because
       AbandonedConnectionCleanupThread failed to initialize its
       internal thread in that case, so that references for
       closed connections were not cleaned up, and their number
       kept growing. This fix repairs the clean up process for
       closed connections and also makes the process thread
       safe. (Bug #28747636, Bug #92508)

     * PreparedStatement.setTimestamp threw a
       NullPointerException if getParameterMetaData() was called
       before the statement was executed. This fix adds the
       missing null checks to getParameterMetaData() to avoid
       the exception. (Bug #28529781, Bug #92089)

     * Setting the connection property characterEncoding to an
       encoding that maps to the MySQL character set latin1 or
       utf8mb4 did not result in the corresponding default
       connection collation (latin1_swedish_ci or
       utf8mb4_0900_ai_ci, respectively) to be used on the
       server. With this fix, the server default is used in the
       situation. (Bug #28207422)

     * Characters returned in a ResultSet were garbled when a
       server-side PreparedStatement was used, and the query
       involved concatenation of a number and a string with
       multi-byte characters. That was due to an issue with the
       number-to-string conversion involved, which has been
       corrected by this fix. (Bug #27453692)

     * ResultSet.updateRow() failed with a
       MySQLSyntaxErrorException when the server was in
       NO_BACKSLASH_ESCAPES SQL mode and some but not all text
       columns were updated. It was because Connector/J sent the
       strings as hex literals in that case and added to them
       unnecessary quotes for escapes. This fix add checks to
       avoid quotes for being added unnecessarily. (Bug
       #22850444, Bug #80441)

     * PreparedStatement.executeUpdate() failed with a
       MySQLSyntaxErrorException when the server was in
       NO_BACKSLASH_ESCAPES SQL mode and BLOB data types were
       involved in the statement. It was because Connector/J did
       not escape single quotes in BLOB value properly in
       NO_BACKSLASH_ESCAPES mode, and the problem has been
       corrected by this fix. (Bug #20913289)

     * When a procedure and a function with the same name
       existed in a database, Connector/J retrieved parameter
       information from both at the same time by default,
       causing various errors at statement executions. This fix
       leverages the JDBC 4 DatabaseMetaData methods to return
       parameter information only from the procedure or function
       of interest, so that statements are executed without
       errors. (Bug #19531305, Bug #73774)

     * Calling ProfilerEvent.pack() resulted in an
       ArrayIndexOutOfBoundsException. It was due to a
       mishandling of data types, which has been corrected by
       this fix. (Bug #11750577, Bug #41172)

On Behalf of Oracle/MySQL Release Engineering Team,
Hery Ramilison


Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Connector/J 5.1.48 GA has been released
3402
July 29, 2019 01:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.