Oracle 5.0, Reference Manual

Page: 2092 / 3232

Connector/J (JDBC) Reference
2072
yearIsDateType Should the JDBC driver treat the MySQL type
"YEAR" as a java.sql.Date, or as a SHORT? true 3.1.9
zeroDateTimeBehavior What should happen when the driver encounters
DATETIME values that are composed entirely
of zeros (used by MySQL to represent invalid
dates)? Valid values are "exception", "round" and
"convertToNull". exception 3.1.4
Connector/J also supports access to MySQL using named pipes on Windows NT, Windows 2000,
or Windows XP using the
NamedPipeSocketFactory
as a plugin-socket factory using the
socketFactory
property. If you do not use a
namedPipePath
property, the default of
'\\.\pipe
\MySQL'
is used. If you use the
NamedPipeSocketFactory
, the host name and port number values
in the JDBC url are ignored. To enable this feature, use:
socketFactory=com.mysql.jdbc.NamedPipeSocketFactory
Named pipes only work when connecting to a MySQL server on the same physical machine where the
JDBC driver is running. In simple performance tests, named pipe access is between 30%-50% faster
than the standard TCP/IP access. However, this varies per system, and named pipes are slower than
TCP/IP in many Windows configurations.
To create your own socket factories, follow the example code in
com.mysql.jdbc.NamedPipeSocketFactory
, or
com.mysql.jdbc.StandardSocketFactory
.
20.3.5.1.1. Properties Files for the
useConfigs
Option
The
useConfigs
connection option is a convenient shorthand for specifying combinations of options
for particular scenarios. The argument values you can use with this option correspond to the names of
.properties
files within the Connector/J
mysql-connector-java-version-bin.jar
JAR file.
For example, the Connector/J 5.1.9 driver includes the following configuration properties files:
$ unzip mysql-connector-java-5.1.19-bin.jar '*/configs/*'
Archive: mysql-connector-java-5.1.19-bin.jar
creating: com/mysql/jdbc/configs/
inflating: com/mysql/jdbc/configs/3-0-Compat.properties
inflating: com/mysql/jdbc/configs/5-0-Compat.properties
inflating: com/mysql/jdbc/configs/clusterBase.properties
inflating: com/mysql/jdbc/configs/coldFusion.properties
inflating: com/mysql/jdbc/configs/fullDebug.properties
inflating: com/mysql/jdbc/configs/maxPerformance.properties
inflating: com/mysql/jdbc/configs/solarisMaxPerformance.properties
To specify one of these combinations of options, specify
useConfigs=3-0-Compat
,
useConfigs=maxPerformance
, and so on. The following sections show the options that are part
of each
useConfigs
setting. For the details of why each one is included, see the comments in the
.properties
files.
3-0-Compat
emptyStringsConvertToZero=true
jdbcCompliantTruncation=false
noDatetimeStringSync=true
nullCatalogMeansCurrent=true
nullNamePatternMatchesAll=true
transformedBitIsBoolean=false
dontTrackOpenResources=true
zeroDateTimeBehavior=convertToNull
useServerPrepStmts=false
autoClosePStmtStreams=true
processEscapeCodesForPrepStmts=false
useFastDateParsing=false
populateInsertRowWithDefaultValues=false
useDirectRowUnpack=false