JDBC Connector 입니다...
====================================================================
Hi,
MySQL Connector/J 3.1.9, a new version of the Type-IV all-Java
JDBC
driver for MySQL has been released.
Version 3.1.9 is the latest production release of the 3.1 series
that is
suitable for use with all versions of MySQL, including MySQL-4.1
or
MySQL-5.0. Connector/J 3.1.9 is required if you want to use
server-side
prepared statements with MySQL-4.1.2 or newer, or
CallableStatements
with MySQL-5.0.
Sources and binaries are now available from the Connector/J
download pages at http://dev.mysql.com/downloads/connector/j/3.1.html
as well as 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.)
If you are upgrading from Connector/J 3.0, or are upgrading
from
MySQL-4.0 to MySQL-4.1 or 5.0, please make sure to check out
the
'Upgrades' section in the documentation that comes with the driver,
or
available on the web site at
http://dev.mysql.com/doc/connector/j/en/cj-upgrading-3-0-to-3-1.html
-Mark
- From the changelog:
06-22-05 - Version 3.1.9-stable
- Overhaul of character set configuration, everything now
lives in a properties file.
- Driver now correctly uses CP932 if available on the server
for Windows-31J, CP932 and MS932 java encoding names,
otherwise it resorts to SJIS, which is only a close
approximation. Currently only MySQL-5.0.3 and newer (and
MySQL-4.1.12 or .13, depending on when the character set
gets backported) can reliably support any variant of CP932.
- Fixed BUG#9064 - com.mysql.jdbc.PreparedStatement.ParseInfo
does unnecessary call to toCharArray().
- Fixed Bug#10144 - Memory leak in ServerPreparedStatement if
serverPrepare() fails.
- Actually write manifest file to correct place so it ends up
in the binary jar file.
- Added "createDatabaseIfNotExist" property (default is
"false"),
which will cause the driver to ask the server to create the
database specified in the URL if it doesn't exist. You must
have
the appropriate privileges for database creation for this
to
work.
- Fixed BUG#10156 - Unsigned SMALLINT treated as signed for
ResultSet.getInt(), fixed all cases for UNSIGNED integer values
and
server-side prepared statements, as well as ResultSet.getObject()
for
UNSIGNED TINYINT.
- Fixed BUG#10155, double quotes not recognized when parsing
client-side prepared statements.
- Made enableStreamingResults() visible on
com.mysql.jdbc.jdbc2.optional.StatementWrapper.
- Made ServerPreparedStatement.asSql() work correctly so
auto-explain
functionality would work with server-side prepared
statements.
- Made JDBC2-compliant wrappers public in order to allow access
to
vendor extensions.
- Cleaned up logging of profiler events, moved code to dump a
profiler
event as a string to com.mysql.jdbc.log.LogUtils so that
third
parties can use it.
- DatabaseMetaData.supportsMultipleOpenResults() now returns true.
The
driver has supported this for some time, DBMD just missed that
fact.
- Fixed BUG#10310 - Driver doesn't support {?=CALL(...)} for
calling
stored functions. This involved adding support for function
retrieval to
DatabaseMetaData.getProcedures() and getProcedureColumns() as
well.
- Fixed BUG#10485, SQLException thrown when retrieving
YEAR(2)
with ResultSet.getString(). The driver will now always treat YEAR
types
as java.sql.Dates and return the correct values for
getString().
Alternatively, the "yearIsDateType" connection property can be set
to
"false" and the values will be treated as SHORTs.
- The datatype returned for TINYINT(1) columns when
"tinyInt1isBit=true" (the default) can be switched between
Types.BOOLEAN
and Types.BIT using the new configuration property
"transformedBitIsBoolean", which defaults to "false". If set to
"false"
(the default), DatabaseMetaData.getColumns() and
ResultSetMetaData.getColumnType() will return Types.BOOLEAN
for
TINYINT(1) columns. If "true", Types.BOOLEAN will be returned
instead.
Irregardless of this configuration property, if "tinyInt1isBit"
is
enabled, columns with the type TINYINT(1) will be returned as
java.lang.Boolean instances from ResultSet.getObject(..),
and
ResultSetMetaData.getColumnClassName() will return
"java.lang.Boolean".
- Fixed BUG#10496 - SQLException is thrown when using
property
"characterSetResults" with cp932 or eucjpms.
- Reorganized directory layout, sources now in "src" folder,
don't pollute parent directory when building, now output goes
to
"./build", distribution goes to "./dist".
- Added support/bug hunting feature that generates .sql test
scripts to STDERR when "autoGenerateTestcaseScript" is set
to "true".
- Fixed BUG#10850 - 0-length streams not sent to server when
using server-side prepared statements.
- Setting "cachePrepStmts=true" now causes the Connection to also
cache
the check the driver performs to determine if a prepared statement
can
be server-side or not, as well as caches server-side
prepared statements for the lifetime of a connection. As before,
the
"prepStmtCacheSize" parameter controls the size of these
caches.
- Try to handle OutOfMemoryErrors more gracefully. Although
not
much can be done, they will in most cases close the connection
they
happened on so that further operations don't run into a connection
in
some unknown state. When an OOM has happened, any further
operations on
the connection will fail with a "Connection closed" exception that
will
also list the OOM exception as the reason for the implicit
connection
close event.
- Don't send COM_RESET_STMT for each execution of a
server-side
prepared statement if it isn't required.
- Driver detects if you're running MySQL-5.0.7 or later, and does
not
scan for "LIMIT ?[,?]" in statements being prepared, as the
server supports those types of queries now.
- Fixed BUG#11115, Varbinary data corrupted when using
server-side
prepared statements and ResultSet.getBytes().
- Connection.setCatalog() is now aware of the
"useLocalSessionState"
configuration property, which when set to true will prevent the
driver
from sending "USE ..." to the server if the requested catalog is
the
same as the current catalog.
- Added the following configuration bundles, use one or many
via
the "useConfigs" configuration property:
* maxPerformance -- maximum performance without being
reckless
* solarisMaxPerformance -- maximum performance for
Solaris,
avoids syscalls where it can
* 3-0-Compat -- Compatibility with Connector/J 3.0.x
functionality
- Added "maintainTimeStats" configuration property (defaults
to
"true"), which tells the driver whether or not to keep track of the
last
query time and the last successful packet sent to the server's
time. If
set to false, removes two syscalls per query.
- Fixed BUG#11259, autoReconnect ping causes exception on
connection
startup.
- Fixed BUG#11360 Connector/J dumping query into SQLException
twice
- Fixed PreparedStatement.setClob() not accepting null as a
parameter.
- Fixed BUG#11411 - Production package doesn't include JBoss
integration classes.
- Removed nonsensical "costly type conversion" warnings when
using
usage advisor.
|