Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
Subject: mysql openssl Question
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
Update one field with more fields from another table
Subject: Getting Identity after INSERT
ERROR 2002: Can 't connect to local MySQL server through socket
mysql test 4 1 fails with the gis test
Subject: MySQL Cluster Software
Downgrade Mysql from 4 to 3 23
Mysql 4 0 Oracle Stored Procedure Trigger Conversion
Can 't access mysql after kernel upgrade
Executing MySQL Commands From Within C Program
Comparing and writing out BLOBS
Subject: Re: Preventing Duplicate Entries
FULLTEXT query format question
Strange behavior, Table Level Permission
Does the binary log enabling affect the MySQL performances?
mysql:it 's a db not a dbms how it 's possible?!
mysql have same function mthod as Oracle decode()
 
Subject: MySQL Connector/J 5.0.8 Has Been Released

Subject: MySQL Connector/J 5.0.8 Has Been Released

2007-10-09       - By Mark Matthews

 Back
-- --BEGIN PGP SIGNED MESSAGE-- --
Hash: SHA1

Hi,

MySQL Connector/J 5.0.8 a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.

This is a bug fix release for the current production branch of
Connector/J.

We're releasing version 5.1.5 as a GA today as well, so this is the last
planned release of the 5.0 branch unless security or data corruption
bugs are reported against 5.0.

Version 5.0.8 is suitable for use with any MySQL version including
MySQL-4 (See http://SQL-4.ora-code.com).1, MySQL-5 (See http://SQL-5.ora-code.com).0, MySQL-5 (See http://SQL-5.ora-code.com).1 RC or the MySQL-6 (See http://SQL-6.ora-code.com).0 Falcon development
releases.

It is now available in source and binary form from the Connector/J
download pages at

  http://dev.mysql.com/downloads/connector/j/5.0.html

and mirror sites (note that not all mirror sites may be up to date at
this point of time - if you can't find this version on some mirror,
please try again later or choose another download site.)

As always, we recommend that you check the change log

  http://dev.mysql.com/doc/refman/5.0/en/cj-news.html

and "Upgrading" sections

  http://dev.mysql.com/doc/refman/5.0/en/cj-upgrading.html

in the manual before upgrading to be aware of changes in behavior that
might affect your application.

We welcome and appreciate your feedback, bug reports, bug fixes, patches
etc.:

  http://forge.mysql.com/wiki/Contributing
 
- -- ---- ---- ---- ---- ---- --
Functionality added or changed
- -- ---- ---- ---- ---- ---- --

- - Added two configuration parameters (both default to "false")

 * blobsAreStrings  - Should the driver always treat BLOBs as Strings
                               specifically to work around dubious
metadata returned                                  by the server for
GROUP BY clauses?

 * functionsNeverReturnBlobs - Should the driver always treat data from
                                       functions returning BLOBs as
Strings - specifically to work around dubious metadata returned by the
server for GROUP BY clauses?

- - Specifying a "validation query" in your connection pool that starts
with "/* ping */" _exactly_ will cause the driver to instead send a ping
to the server and return a fake result set (much lighter weight), and
when using a ReplicationConnection or a LoadBalancedConnection,
will send the ping across all active connections.

- - XAConnections now start in auto-commit mode (as per JDBC-4 (See http://DBC-4.ora-code.com).0
specification clarification).

- - Driver will now fall back to sane defaults for max_allowed_packet and
net_buffer_length if the server reports them incorrectly (and will log
   this situation at WARN level, since it's actually an error condition).

- -- ---- --
Bugs Fixed
- -- ---- --

- - Fixed BUG#27182 - Connection.getServerCharacterEncoding() doesn't work
    for servers with version >= 4.1.

- - Fixed Bug#27412 - cached metadata with PreparedStatement.execute()
 throws NullPointerException.

- - Fixed BUG#27867 - Schema objects with identifiers other than the
connection character aren't retrieved correctly in      ResultSetMetadata.

- - Fixed BUG#27915 - DatabaseMetaData.getColumns() doesn't contain
SCOPE_* or IS_AUTOINCREMENT columns.

- - Fixed BUG#27916 - UNSIGNED types not reported via DBMD.getTypeInfo(),
and capitalization of type names is not consistent between
DBMD.getColumns(), RSMD.getColumnTypeName() and DBMD.getTypeInfo().

This fix also ensures that the precision of UNSIGNED MEDIUMINT and
UNSIGNED BIGINT is reported correctly via DBMD.getColumns().

- - Fixed BUG#28689 - CallableStatement.executeBatch() doesn't work when
  connection property "noAccessToProcedureBodies" has been set to "true".

The fix involves changing the behavior of "noAccessToProcedureBodies",in
    that the driver will now report all paramters as "IN" paramters but
allow callers to call registerOutParameter() on them without throwing
  an exception.

- - Fixed BUG#28972 - DatabaseMetaData.getTypeInfo() for the types DECIMAL
    and NUMERIC will return a precision of 254 for server versions
older than 5.0.3, 64 for versions 5.0.3-5.0.5 and 65 for versions newer
than 5.0.5.

- - Fixed BUG#29106 - Connection checker for JBoss didn't use same method
parameters via reflection, causing connections to always seem "bad".

- - Fixed BUG#29852 - Closing a load-balanced connection would cause a
 ClassCastException.

- - Fixed BUG#30550, executeBatch() would fail with an ArithmeticException
    and/or NullPointerException when the batch had zero members and
"rewriteBatchedStatements" was set to "true" for the connection.

- - Fixed BUG#30664 - Note that this fix only works for MySQL server
versions 5.0.25 and newer, since earlier versions didn't consistently
    return correct metadata for functions, and thus results from
subqueries and functions were indistinguishable from each other,
leading to type-related bugs.

- - Fixed BUG#30851, NPE with null column values when "padCharsWithSpace"
is set to "true".

- Fixed Bug#30892 setObject(int, Object, int, int) delegate in
PreparedStatmentWrapper delegates to wrong method.

- - Fixed BUG#31053 - Connections established using URLs of the form
"jdbc:mysql:loadbalance://" weren't doing failover if they tried to
connect to a MySQL server that was down. The driver now attempts
connections to the next "best" (depending on the load balance strategy
in use) server, and continues to attempt connecting to the next "best"
server every 250 milliseconds until one is found that is up and running
    or 5 minutes has passed.

If the driver gives up, it will throw the last-received SQLException.

Enjoy!

  - Mark

- --
Mark Matthews, Architect (Enterprise Tools)
MySQL, Inc. Chicago, USA - www.mysql.com

-- --BEGIN PGP SIGNATURE-- --
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHC51qtvXNTca6JD8RAixeAJsEsV5Fu2r7DSVZrPRiN9vun+dveQCfQiSl
qWkriTG1C6XuySqO+9PX1FY=
=t+/k
-- --END PGP SIGNATURE-- --

--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/java?unsub=mysql@(protected)