1007 lines
60 KiB
HTML
1007 lines
60 KiB
HTML
<?xml version="1.0" encoding="UTF-8"?>
|
|
<!DOCTYPE html
|
|
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
|
<html lang="en-us" xml:lang="en-us">
|
|
<head>
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
|
<meta name="security" content="public" />
|
|
<meta name="Robots" content="index,follow" />
|
|
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
|
|
<meta name="DC.Type" content="reference" />
|
|
<meta name="DC.Title" content="IBM Toolbox for Java JDBC properties" />
|
|
<meta name="abstract" content="Many properties can be specified when connecting to a server database using JDBC. All properties are optional and can be specified either as part of the URL or in a java.util.Properties object. If a property is set in both the URL and a Properties object, the value in the URL will be used." />
|
|
<meta name="description" content="Many properties can be specified when connecting to a server database using JDBC. All properties are optional and can be specified either as part of the URL or in a java.util.Properties object. If a property is set in both the URL and a Properties object, the value in the URL will be used." />
|
|
<meta name="DC.Relation" scheme="URI" content="jdbc2.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="jdbcliblistproperty.htm" />
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 2006" />
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 2006" />
|
|
<meta name="DC.Format" content="XHTML" />
|
|
<meta name="DC.Identifier" content="jdbcproperties" />
|
|
<meta name="DC.Language" content="en-us" />
|
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
|
<!-- US Government Users Restricted Rights -->
|
|
<!-- Use, duplication or disclosure restricted by -->
|
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
|
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
|
|
<link rel="stylesheet" type="text/css" href="./ic.css" />
|
|
<title>IBM Toolbox
|
|
for Java JDBC
|
|
properties</title>
|
|
</head>
|
|
<body id="jdbcproperties"><a name="jdbcproperties"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">IBM Toolbox
|
|
for Java JDBC
|
|
properties</h1>
|
|
<div><p>Many properties can be specified when connecting to a server database
|
|
using JDBC. All properties are optional and can be specified either as part
|
|
of the URL or in a java.util.Properties object. If a property is set in both
|
|
the URL and a Properties object, the value in the URL will be used.</p>
|
|
<div class="section"><div class="note"><span class="notetitle">Note:</span> The following list does not include DataSource properties.</div>
|
|
<p>The
|
|
following tables list the different connection properties that are recognized
|
|
by this driver. Some of these properties affect performance and others are
|
|
server job attributes. The tables organize the properties into the following
|
|
categories:</p>
|
|
<ul><li> <a href="#jdbcproperties__general">General properties</a></li>
|
|
<li> <a href="#jdbcproperties__server">Server properties</a></li>
|
|
<li> <a href="#jdbcproperties__format">Format properties</a></li>
|
|
<li> <a href="#jdbcproperties__performance">Performance properties</a></li>
|
|
<li> <a href="#jdbcproperties__sort">Sort properties</a></li>
|
|
<li> <a href="#jdbcproperties__other">Other properties</a></li>
|
|
</ul>
|
|
</div>
|
|
<div class="section" id="jdbcproperties__general"><a name="jdbcproperties__general"><!-- --></a><h4 class="sectiontitle">General properties</h4><p>General properties
|
|
are system attributes that specify the user, password, and whether a prompt
|
|
is necessary to connect to the server.</p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="border" border="1" rules="all"><thead align="left"><tr class="tablemainheaderbar"><th valign="top" width="14.437367303609342%" id="d0e61">General property</th>
|
|
<th valign="top" width="49.25690021231423%" id="d0e63">Description</th>
|
|
<th valign="top" width="8.70488322717622%" id="d0e65">Required</th>
|
|
<th valign="top" width="14.012738853503185%" id="d0e67">Choices</th>
|
|
<th valign="top" width="13.588110403397028%" id="d0e69">Default</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr><td valign="top" width="14.437367303609342%" headers="d0e61 ">"password"</td>
|
|
<td valign="top" width="49.25690021231423%" headers="d0e63 ">Specifies the password for connecting to the server. If none is specified,
|
|
then the user will be prompted, unless the "prompt" property is set to "false",
|
|
in which case an attempt to connect will fail.</td>
|
|
<td align="center" valign="top" width="8.70488322717622%" headers="d0e65 ">no</td>
|
|
<td valign="top" width="14.012738853503185%" headers="d0e67 ">server password</td>
|
|
<td valign="top" width="13.588110403397028%" headers="d0e69 ">(user will be prompted)</td>
|
|
</tr>
|
|
<tr><td valign="top" width="14.437367303609342%" headers="d0e61 ">"prompt"</td>
|
|
<td valign="top" width="49.25690021231423%" headers="d0e63 ">Specifies whether the user is prompted if a user name or password
|
|
is needed to connect to the server. If a connection cannot be made without
|
|
prompting the user, and this property is set to "false", then an attempt
|
|
to connect will fail.</td>
|
|
<td align="center" valign="top" width="8.70488322717622%" headers="d0e65 ">no</td>
|
|
<td valign="top" width="14.012738853503185%" headers="d0e67 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="13.588110403397028%" headers="d0e69 ">"true"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="14.437367303609342%" headers="d0e61 ">"user"</td>
|
|
<td valign="top" width="49.25690021231423%" headers="d0e63 ">Specifies the user name for connecting to the server. If none is specified,
|
|
then the user will be prompted, unless the "prompt" property is set to "false",
|
|
in which case an attempt to connect will fail.</td>
|
|
<td align="center" valign="top" width="8.70488322717622%" headers="d0e65 ">no</td>
|
|
<td valign="top" width="14.012738853503185%" headers="d0e67 ">server user</td>
|
|
<td valign="top" width="13.588110403397028%" headers="d0e69 ">(user will be prompted)</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div class="section" id="jdbcproperties__server"><a name="jdbcproperties__server"><!-- --></a><h4 class="sectiontitle">Server properties</h4><p>Server properties
|
|
specify attributes that govern transactions, libraries, and databases.</p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="border" border="1" rules="all"><thead align="left"><tr class="tablemainheaderbar"><th valign="top" width="12.195121951219512%" id="d0e123">Server property</th>
|
|
<th valign="top" width="49.51219512195122%" id="d0e125">Description</th>
|
|
<th valign="top" width="9.268292682926829%" id="d0e127">Required</th>
|
|
<th valign="top" width="12.926829268292684%" id="d0e129">Choices</th>
|
|
<th valign="top" width="16.097560975609756%" id="d0e131">Default</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr><td valign="top" width="12.195121951219512%" headers="d0e123 ">"cursor hold"</td>
|
|
<td valign="top" width="49.51219512195122%" headers="d0e125 "> Specifies whether to hold the cursor across transactions. If this
|
|
property is set to "true", cursors are not closed when a transaction is committed
|
|
or rolled back. All resources acquired during the unit of work are held,
|
|
but locks on specific rows and objects implicitly acquired during the unit
|
|
of work are released.</td>
|
|
<td align="center" valign="top" width="9.268292682926829%" headers="d0e127 ">no</td>
|
|
<td valign="top" width="12.926829268292684%" headers="d0e129 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="16.097560975609756%" headers="d0e131 ">"true"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="12.195121951219512%" headers="d0e123 ">"cursor sensitivity"</td>
|
|
<td valign="top" width="49.51219512195122%" headers="d0e125 "><p>Specifies the cursor sensitivity to request from the database. The
|
|
behavior depends on the resultSetType:</p>
|
|
<ul><li>ResultSet.TYPE_FORWARD_ONLY or ResultSet.TYPE_SCROLL_SENSITIVE means that
|
|
the value of this property controls what cursor sensitivity the Java™ program
|
|
requests from the database.</li>
|
|
<li>ResultSet.TYPE_SCROLL_INSENSITIVE causes this property to be ignored.</li>
|
|
</ul>
|
|
<p>This property is ignored when connecting to systems running V5R1
|
|
and earlier versions of i5/OS™.</p>
|
|
</td>
|
|
<td align="center" valign="top" width="9.268292682926829%" headers="d0e127 ">no</td>
|
|
<td valign="top" width="12.926829268292684%" headers="d0e129 "><ul class="simple"><li>"" (Use the ResultSet Type to determine the cursor sensitivity)</li>
|
|
<li>"asensitive"</li>
|
|
<li>"sensitive"</li>
|
|
<li>"insensitive"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="16.097560975609756%" headers="d0e131 ">""</td>
|
|
</tr>
|
|
<tr><td valign="top" width="12.195121951219512%" headers="d0e123 ">"database name"</td>
|
|
<td valign="top" width="49.51219512195122%" headers="d0e125 "><p>Specifies the database to use for the connection, including one
|
|
stored in an <a href="iasp.htm#iasp">independent auxiliary storage pool</a>.
|
|
This property applies only when connecting to a V5R2 or later version of i5/OS.
|
|
When you specify a database name, the name must exist in the relational
|
|
database directory on the server. The following criteria determine which
|
|
database is accessed:</p>
|
|
<ul><li>When this property is used to specify a database, the specified database
|
|
is used. When the specified database does not exist, the connection fails.</li>
|
|
<li>When this property is used to specify *SYSBAS as the database name, the
|
|
system default database is used.</li>
|
|
<li>When this property is omitted, the database name specified in the job
|
|
description for the user profile is used. When the job description does not
|
|
specify a database name, the system default database is used. </li>
|
|
</ul>
|
|
</td>
|
|
<td align="center" valign="top" width="9.268292682926829%" headers="d0e127 ">no</td>
|
|
<td valign="top" width="12.926829268292684%" headers="d0e129 ">Database name "*SYSBAS"</td>
|
|
<td valign="top" width="16.097560975609756%" headers="d0e131 ">The database name specified in the job description for the user profile
|
|
is used. When the job description does not specify a database name, the system
|
|
default database is used.</td>
|
|
</tr>
|
|
<tr><td valign="top" width="12.195121951219512%" headers="d0e123 ">"libraries"</td>
|
|
<td valign="top" width="49.51219512195122%" headers="d0e125 "><p>Specifies one or more libraries that you want to add to or replace
|
|
the library list of the server job, and optionally sets the default library
|
|
(default schema). </p>
|
|
<p><strong>Library list</strong> The server uses specified libraries
|
|
to resolve unqualified stored procedure names, and stored procedures use
|
|
them to resolve unqualified names. To specify multiple libraries, use commas
|
|
or spaces to separate individual entries. You can use *LIBL as a placeholder
|
|
for the current library list of the server job: </p>
|
|
<ul><li>When the first entry is *LIBL, the specified libraries are added to the
|
|
current library list of the server job </li>
|
|
<li>When you do not use *LIBL, the specified libraries replace the current
|
|
library list of the server job </li>
|
|
</ul>
|
|
<p>For more information about library list properties, see <a href="jdbcliblistproperty.htm#jdbcliblistproperty">JDBC LibraryList property</a>.</p>
|
|
<p><strong>Default
|
|
schema</strong> The server uses the default schema to resolve unqualified names
|
|
in SQL statements. For example, in the statement "SELECT * FROM MYTABLE",
|
|
the server looks only in the default schema for MYTABLE. You can specify
|
|
the default schema on the connection URL. When you do not specify the default
|
|
schema on the connection URL, the following conditions apply, depending
|
|
on whether you use SQL Naming or System Naming. </p>
|
|
<ul><li><strong>SQL Naming</strong> When you do not specify the default schema on the connection
|
|
URL: <ul><li>The first entry (unless it is *LIBL) becomes the default schema</li>
|
|
<li>When the first entry is *LIBL, the second entry becomes the default schema</li>
|
|
<li>When you do not set this property or when it contains only *LIBL, the
|
|
user profile becomes the default schema</li>
|
|
</ul>
|
|
</li>
|
|
<li><strong>System Naming</strong> When you do not specify the default schema on the
|
|
connection URL: <ul><li>No default schema is set, and the server uses the specified libraries
|
|
to search for unqualified names</li>
|
|
<li>When you do not set this property or when it contains only *LIBL, the
|
|
server uses the current library list of the server job to search for unqualified
|
|
names </li>
|
|
</ul>
|
|
</li>
|
|
</ul>
|
|
</td>
|
|
<td align="center" valign="top" width="9.268292682926829%" headers="d0e127 ">no</td>
|
|
<td valign="top" width="12.926829268292684%" headers="d0e129 ">List of server libraries, separated by commas or spaces</td>
|
|
<td valign="top" width="16.097560975609756%" headers="d0e131 ">"*LIBL"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="12.195121951219512%" headers="d0e123 ">"maximum precision"</td>
|
|
<td valign="top" width="49.51219512195122%" headers="d0e125 ">Specifies the maximum decimal precision the database
|
|
might use.</td>
|
|
<td align="center" valign="top" width="9.268292682926829%" headers="d0e127 ">no</td>
|
|
<td valign="top" width="12.926829268292684%" headers="d0e129 "><ul class="simple"><li>"31"</li>
|
|
<li>"63"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="16.097560975609756%" headers="d0e131 ">"31"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="12.195121951219512%" headers="d0e123 ">"maximum scale"</td>
|
|
<td valign="top" width="49.51219512195122%" headers="d0e125 ">Specifies the maximum scale the database might use.</td>
|
|
<td align="center" valign="top" width="9.268292682926829%" headers="d0e127 ">no</td>
|
|
<td valign="top" width="12.926829268292684%" headers="d0e129 ">"0"-"63" </td>
|
|
<td valign="top" width="16.097560975609756%" headers="d0e131 ">"31"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="12.195121951219512%" headers="d0e123 ">"minimum divide scale"</td>
|
|
<td valign="top" width="49.51219512195122%" headers="d0e125 ">Specifies the minimum scale value for the result of
|
|
decimal division.</td>
|
|
<td align="center" valign="top" width="9.268292682926829%" headers="d0e127 ">no</td>
|
|
<td valign="top" width="12.926829268292684%" headers="d0e129 "><ul class="simple"><li>"0"</li>
|
|
<li>"1"</li>
|
|
<li>"2"</li>
|
|
<li>"3"</li>
|
|
<li>"4"</li>
|
|
<li>"5"</li>
|
|
<li>"6"</li>
|
|
<li>"7"</li>
|
|
<li>"8"</li>
|
|
<li>"9"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="16.097560975609756%" headers="d0e131 ">"0"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="12.195121951219512%" headers="d0e123 ">"package ccsid"</td>
|
|
<td valign="top" width="49.51219512195122%" headers="d0e125 ">Specifies the character encoding to use for the SQL
|
|
package and any statements sent to the server.</td>
|
|
<td align="center" valign="top" width="9.268292682926829%" headers="d0e127 ">no</td>
|
|
<td valign="top" width="12.926829268292684%" headers="d0e129 "><ul class="simple"><li>"1200" (UCS-2)</li>
|
|
<li>"13488" (UTF-16)</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="16.097560975609756%" headers="d0e131 ">"13488"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="12.195121951219512%" headers="d0e123 "><img src="./delta.gif" alt="Start of change" />"rollback cursor hold"<img src="./deltaend.gif" alt="End of change" /></td>
|
|
<td valign="top" width="49.51219512195122%" headers="d0e125 "><img src="./delta.gif" alt="Start of change" />Specifies whether to hold the cursor after a rollback.
|
|
If this property is set to "true", cursors are held after a transaction is
|
|
rolled back.<img src="./deltaend.gif" alt="End of change" /></td>
|
|
<td align="center" valign="top" width="9.268292682926829%" headers="d0e127 "><img src="./delta.gif" alt="Start of change" />no<img src="./deltaend.gif" alt="End of change" /></td>
|
|
<td valign="top" width="12.926829268292684%" headers="d0e129 "><img src="./delta.gif" alt="Start of change" /><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
<img src="./deltaend.gif" alt="End of change" /></td>
|
|
<td valign="top" width="16.097560975609756%" headers="d0e131 "><img src="./delta.gif" alt="Start of change" />"false"<img src="./deltaend.gif" alt="End of change" /></td>
|
|
</tr>
|
|
<tr><td valign="top" width="12.195121951219512%" headers="d0e123 ">"transaction isolation"</td>
|
|
<td valign="top" width="49.51219512195122%" headers="d0e125 ">Specifies the default transaction isolation.</td>
|
|
<td align="center" valign="top" width="9.268292682926829%" headers="d0e127 ">no</td>
|
|
<td valign="top" width="12.926829268292684%" headers="d0e129 "><ul class="simple"><li>"none</li>
|
|
<li>"read uncom- mitted"</li>
|
|
<li> "read commit- ted"</li>
|
|
<li>"repeatable read"</li>
|
|
<li> "serializable"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="16.097560975609756%" headers="d0e131 ">"read uncommitted"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="12.195121951219512%" headers="d0e123 ">"translate hex"</td>
|
|
<td valign="top" width="49.51219512195122%" headers="d0e125 ">Specifies how hexadecimal literals are interpreted.</td>
|
|
<td align="center" valign="top" width="9.268292682926829%" headers="d0e127 ">no</td>
|
|
<td valign="top" width="12.926829268292684%" headers="d0e129 "><ul class="simple"><li>"char- acter" (Interpret hexa- decimal literals as character data) </li>
|
|
<li>"binary" (Interpret hexa- decimal literals as binary data)</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="16.097560975609756%" headers="d0e131 ">"character"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="12.195121951219512%" headers="d0e123 ">"true autocommit"</td>
|
|
<td valign="top" width="49.51219512195122%" headers="d0e125 ">Specifies whether the connection should use true auto
|
|
commit support. True autocommit means that autocommit is on and is running
|
|
under a isolation level other than *NONE. By default, the driver handles autocommit
|
|
by running under the server isolation level of *NONE.</td>
|
|
<td align="center" valign="top" width="9.268292682926829%" headers="d0e127 ">no</td>
|
|
<td valign="top" width="12.926829268292684%" headers="d0e129 "><ul class="simple"><li>"true" (Use true autocom-mit.)</li>
|
|
<li>"false" (Do not use true autocom-mit.)</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="16.097560975609756%" headers="d0e131 ">"false"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="12.195121951219512%" headers="d0e123 "><img src="./delta.gif" alt="Start of change" />"xa loosely coupled support"<img src="./deltaend.gif" alt="End of change" /></td>
|
|
<td valign="top" width="49.51219512195122%" headers="d0e125 "><img src="./delta.gif" alt="Start of change" />Specifies whether lock sharing is allowed for loosely
|
|
coupled transaction branches. <div class="note"><span class="notetitle">Note:</span> This setting is ignored when running to i5/OS V5R3
|
|
or earlier.</div>
|
|
<img src="./deltaend.gif" alt="End of change" /></td>
|
|
<td align="center" valign="top" width="9.268292682926829%" headers="d0e127 "><img src="./delta.gif" alt="Start of change" />no<img src="./deltaend.gif" alt="End of change" /></td>
|
|
<td valign="top" width="12.926829268292684%" headers="d0e129 "><img src="./delta.gif" alt="Start of change" /><ul class="simple"><li>"0" = Locks cannot be shared</li>
|
|
<li>"1" = Locks can be shared</li>
|
|
</ul>
|
|
<img src="./deltaend.gif" alt="End of change" /></td>
|
|
<td valign="top" width="16.097560975609756%" headers="d0e131 "><img src="./delta.gif" alt="Start of change" />"0"<img src="./deltaend.gif" alt="End of change" /></td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div class="section" id="jdbcproperties__format"><a name="jdbcproperties__format"><!-- --></a><h4 class="sectiontitle">Format properties</h4><p>Format properties
|
|
specify date and time formats, date and decimal separators, and table naming
|
|
conventions used within SQL statements.</p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="border" border="1" rules="all"><thead align="left"><tr class="tablemainheaderbar"><th valign="top" width="20.79002079002079%" id="d0e437">Format property</th>
|
|
<th valign="top" width="41.16424116424117%" id="d0e439">Description</th>
|
|
<th valign="top" width="9.563409563409564%" id="d0e441">Required</th>
|
|
<th valign="top" width="12.889812889812891%" id="d0e443">Choices</th>
|
|
<th valign="top" width="15.592515592515593%" id="d0e445">Default</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr><td valign="top" width="20.79002079002079%" headers="d0e437 ">"date format"</td>
|
|
<td valign="top" width="41.16424116424117%" headers="d0e439 ">Specifies the date format used in date literals within SQL statements.</td>
|
|
<td align="center" valign="top" width="9.563409563409564%" headers="d0e441 ">no</td>
|
|
<td valign="top" width="12.889812889812891%" headers="d0e443 "><ul class="simple"><li> "mdy"</li>
|
|
<li>"dmy"</li>
|
|
<li>"ymd"</li>
|
|
<li>"usa"</li>
|
|
<li>"iso"</li>
|
|
<li>"eur"</li>
|
|
<li>"jis"</li>
|
|
<li>"julian"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="15.592515592515593%" headers="d0e445 ">(server job)</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20.79002079002079%" headers="d0e437 ">"date separator"</td>
|
|
<td valign="top" width="41.16424116424117%" headers="d0e439 ">Specifies the date separator used in date literals within SQL statements.
|
|
This property has no effect unless the "date format" property is set to "julian",
|
|
"mdy", "dmy" or "ymd".</td>
|
|
<td align="center" valign="top" width="9.563409563409564%" headers="d0e441 ">no</td>
|
|
<td valign="top" width="12.889812889812891%" headers="d0e443 "><ul class="simple"><li>"/" (slash)</li>
|
|
<li>"-" (dash)</li>
|
|
<li>"." (period)</li>
|
|
<li> "," (comma)</li>
|
|
<li>"b" (space)</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="15.592515592515593%" headers="d0e445 ">(server job)</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20.79002079002079%" headers="d0e437 ">"decimal separator"</td>
|
|
<td valign="top" width="41.16424116424117%" headers="d0e439 ">Specifies the decimal separator used in numeric literals within SQL
|
|
statements.</td>
|
|
<td align="center" valign="top" width="9.563409563409564%" headers="d0e441 ">no</td>
|
|
<td valign="top" width="12.889812889812891%" headers="d0e443 "><ul class="simple"><li> "." (period)</li>
|
|
<li>"," (comma)</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="15.592515592515593%" headers="d0e445 ">(server job)</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20.79002079002079%" headers="d0e437 ">"naming"</td>
|
|
<td valign="top" width="41.16424116424117%" headers="d0e439 ">Specifies the naming convention used when referring to tables.</td>
|
|
<td align="center" valign="top" width="9.563409563409564%" headers="d0e441 ">no</td>
|
|
<td valign="top" width="12.889812889812891%" headers="d0e443 "> "sql" (as in <tt><span>schema</span>.<span>table</span></tt>) "system" (as
|
|
in <tt><span>schema</span>/<span>table</span></tt>)</td>
|
|
<td valign="top" width="15.592515592515593%" headers="d0e445 ">"sql"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20.79002079002079%" headers="d0e437 ">"time format"</td>
|
|
<td valign="top" width="41.16424116424117%" headers="d0e439 ">Specifies the time format used in time literals within SQL statements.</td>
|
|
<td align="center" valign="top" width="9.563409563409564%" headers="d0e441 ">no</td>
|
|
<td valign="top" width="12.889812889812891%" headers="d0e443 "><ul class="simple"><li>"hms"</li>
|
|
<li>"usa"</li>
|
|
<li>"iso"</li>
|
|
<li>"eur"</li>
|
|
<li>"jis"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="15.592515592515593%" headers="d0e445 ">(server job)</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20.79002079002079%" headers="d0e437 ">"time separator"</td>
|
|
<td valign="top" width="41.16424116424117%" headers="d0e439 ">Specifies the time separator used in time literals within SQL statements.
|
|
This property has no effect unless the "time format" property is set to "hms".</td>
|
|
<td align="center" valign="top" width="9.563409563409564%" headers="d0e441 ">no</td>
|
|
<td valign="top" width="12.889812889812891%" headers="d0e443 "><ul class="simple"><li>":" (colon)</li>
|
|
<li>"." (period)</li>
|
|
<li>"," (comma)</li>
|
|
<li>"b" (space)</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="15.592515592515593%" headers="d0e445 ">(server job)</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div class="section" id="jdbcproperties__performance"><a name="jdbcproperties__performance"><!-- --></a><h4 class="sectiontitle">Performance properties</h4><p>Performance
|
|
properties are attributes that include caching, data conversion, data compression,
|
|
and prefetching that affect performance.</p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="border" border="1" rules="all"><thead align="left"><tr class="tablemainheaderbar"><th valign="top" width="20%" id="d0e590">Performance property</th>
|
|
<th valign="top" width="39.325842696629216%" id="d0e592">Description</th>
|
|
<th valign="top" width="8.98876404494382%" id="d0e594">Required</th>
|
|
<th valign="top" width="17.078651685393258%" id="d0e596">Choices</th>
|
|
<th valign="top" width="14.606741573033707%" id="d0e598">Default</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr><td valign="top" width="20%" headers="d0e590 ">"big decimal"</td>
|
|
<td valign="top" width="39.325842696629216%" headers="d0e592 ">Specifies whether an intermediate java.math.BigDecimal object is used
|
|
for packed and zoned decimal conversions. If this property is set to "true",
|
|
an intermediate java.math.BigDecimal object is used for packed and zoned
|
|
decimal conversions as described by the JDBC specification. If this property
|
|
is set to "false", no intermediate objects are used for packed and zoned
|
|
decimal conversions. Instead, such values are converted directly to and from Java double
|
|
values. Such conversions will be faster but may not follow all conversion
|
|
and data truncation rules documented by the JDBC specification.</td>
|
|
<td align="center" valign="top" width="8.98876404494382%" headers="d0e594 ">no</td>
|
|
<td valign="top" width="17.078651685393258%" headers="d0e596 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="14.606741573033707%" headers="d0e598 ">"true"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20%" headers="d0e590 ">"block criteria"</td>
|
|
<td valign="top" width="39.325842696629216%" headers="d0e592 ">Specifies the criteria for retrieving data from the server in blocks
|
|
of records. Specifying a non-zero value for this property will reduce the
|
|
frequency of communication to the server, and therefore improve performance.
|
|
<p>Ensure that record blocking is off if the cursor is going to be used
|
|
for subsequent UPDATEs, or else the row that is updated will not necessarily
|
|
be the current row.</p>
|
|
</td>
|
|
<td align="center" valign="top" width="8.98876404494382%" headers="d0e594 ">no</td>
|
|
<td valign="top" width="17.078651685393258%" headers="d0e596 "><ul class="simple"><li>"0" (no record blocking)</li>
|
|
<li>"1" (block if FOR FETCH ONLY is specified)</li>
|
|
<li>"2" (block unless FOR UPDATE is specified)</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="14.606741573033707%" headers="d0e598 ">"2"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20%" headers="d0e590 ">"block size"</td>
|
|
<td valign="top" width="39.325842696629216%" headers="d0e592 ">Specifies the block size (in kilobytes) to retrieve from the server
|
|
and cache on the client. This property has no effect unless the "block criteria"
|
|
property is non-zero. Larger block sizes reduce the frequency of communication
|
|
to the server, and therefore may improve performance.</td>
|
|
<td align="center" valign="top" width="8.98876404494382%" headers="d0e594 ">no</td>
|
|
<td valign="top" width="17.078651685393258%" headers="d0e596 "><ul class="simple"><li>"0"</li>
|
|
<li>"8"</li>
|
|
<li>"16"</li>
|
|
<li>"32"</li>
|
|
<li>"64"</li>
|
|
<li>"128"</li>
|
|
<li>"256"</li>
|
|
<li>"512"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="14.606741573033707%" headers="d0e598 ">"32"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20%" headers="d0e590 ">"data compression"</td>
|
|
<td valign="top" width="39.325842696629216%" headers="d0e592 ">Specifies whether result set data is compressed. If this property
|
|
is set to "true", then result set data is compressed. If this property is
|
|
set to "false", then result set data is not compressed. Data compression
|
|
may improve performance when retrieving large result sets.</td>
|
|
<td align="center" valign="top" width="8.98876404494382%" headers="d0e594 ">no</td>
|
|
<td valign="top" width="17.078651685393258%" headers="d0e596 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="14.606741573033707%" headers="d0e598 ">"true"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20%" headers="d0e590 ">"extended dynamic"</td>
|
|
<td valign="top" width="39.325842696629216%" headers="d0e592 ">Specifies whether to use extended dynamic support. Extended dynamic
|
|
support provides a mechanism for caching dynamic SQL statements on the server.
|
|
The first time a particular SQL statement is prepared, it is stored in a
|
|
SQL package on the server. If the package does not exist, it is automatically
|
|
created. On subsequent prepares of the same SQL statement, the server can
|
|
skip a significant part of the processing by using information stored in
|
|
the SQL package. If this is set to "true", then a package name must be set
|
|
using the "package" property.</td>
|
|
<td align="center" valign="top" width="8.98876404494382%" headers="d0e594 ">no</td>
|
|
<td valign="top" width="17.078651685393258%" headers="d0e596 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="14.606741573033707%" headers="d0e598 ">"false"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20%" headers="d0e590 ">"lazy close"</td>
|
|
<td valign="top" width="39.325842696629216%" headers="d0e592 ">Specifies whether to delay closing cursors until subsequent requests.
|
|
This will improve overall performance by reducing the total number of requests.</td>
|
|
<td align="center" valign="top" width="8.98876404494382%" headers="d0e594 ">no</td>
|
|
<td valign="top" width="17.078651685393258%" headers="d0e596 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="14.606741573033707%" headers="d0e598 ">"false"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20%" headers="d0e590 ">"lob threshold"</td>
|
|
<td valign="top" width="39.325842696629216%" headers="d0e592 ">Specifies the maximum LOB (large object) size (in bytes) that can
|
|
be retrieved as part of a result set. LOBs that are larger than this threshold
|
|
will be retrieved in pieces using extra communication to the server. Larger
|
|
LOB thresholds will reduce the frequency of communication to the server,
|
|
but will download more LOB data, even if it is not used. Smaller LOB thresholds
|
|
may increase frequency of communication to the server, but will only download
|
|
LOB data as it is needed.</td>
|
|
<td align="center" valign="top" width="8.98876404494382%" headers="d0e594 ">no</td>
|
|
<td valign="top" width="17.078651685393258%" headers="d0e596 ">"0" - "16777216"</td>
|
|
<td valign="top" width="14.606741573033707%" headers="d0e598 ">"32768"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20%" headers="d0e590 ">"package"</td>
|
|
<td valign="top" width="39.325842696629216%" headers="d0e592 ">Specifies the base name of the SQL package. Note that only the first
|
|
seven characters are used to generate the name of the SQL package on the
|
|
server. This property has no effect unless the "extended dynamic" property
|
|
is set to "true". In addition, this property must be set if the "extended
|
|
dynamic" property is set to "true".</td>
|
|
<td align="center" valign="top" width="8.98876404494382%" headers="d0e594 ">no</td>
|
|
<td valign="top" width="17.078651685393258%" headers="d0e596 ">SQL package</td>
|
|
<td valign="top" width="14.606741573033707%" headers="d0e598 ">""</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20%" headers="d0e590 ">"package add"</td>
|
|
<td valign="top" width="39.325842696629216%" headers="d0e592 ">Specifies whether to add newly prepared statements to the SQL package
|
|
specified on the "package" property. This property has no effect unless the
|
|
"extended dynamic" property is set to "true".</td>
|
|
<td align="center" valign="top" width="8.98876404494382%" headers="d0e594 ">no</td>
|
|
<td valign="top" width="17.078651685393258%" headers="d0e596 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="14.606741573033707%" headers="d0e598 ">"true"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20%" headers="d0e590 ">"package cache"</td>
|
|
<td valign="top" width="39.325842696629216%" headers="d0e592 ">Specifies whether to cache a subset of the SQL package information
|
|
in client memory. Caching SQL packages locally reduces the amount of communication
|
|
to the server for prepares and describes. This property has no effect unless
|
|
the "extended dynamic" property is set to "true".</td>
|
|
<td align="center" valign="top" width="8.98876404494382%" headers="d0e594 ">no</td>
|
|
<td valign="top" width="17.078651685393258%" headers="d0e596 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="14.606741573033707%" headers="d0e598 ">"false"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20%" headers="d0e590 ">"package criteria"</td>
|
|
<td valign="top" width="39.325842696629216%" headers="d0e592 ">Specifies the type of SQL statements to be stored in the SQL package.
|
|
This can be useful to improve the performance of complex join conditions.
|
|
This property has no effect unless the "extended dynamic" property is set
|
|
to "true".</td>
|
|
<td align="center" valign="top" width="8.98876404494382%" headers="d0e594 ">no</td>
|
|
<td valign="top" width="17.078651685393258%" headers="d0e596 "><ul class="simple"><li>"default" (only store SQL statements with parameter markers in the package)</li>
|
|
<li>"select" (store all SQL SELECT statements in the package)</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="14.606741573033707%" headers="d0e598 ">"default"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20%" headers="d0e590 ">"package error"</td>
|
|
<td valign="top" width="39.325842696629216%" headers="d0e592 ">Specifies the action to take when SQL package errors occur. When a
|
|
SQL package error occurs, the driver will optionally throw a SQLException
|
|
or post a notice to the Connection, based on the value of this property.
|
|
This property has no effect unless the "extended dynamic" property is set
|
|
to "true".</td>
|
|
<td align="center" valign="top" width="8.98876404494382%" headers="d0e594 ">no</td>
|
|
<td valign="top" width="17.078651685393258%" headers="d0e596 "><ul class="simple"><li>"exception"</li>
|
|
<li>"warning"</li>
|
|
<li>"none"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="14.606741573033707%" headers="d0e598 ">"warning"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20%" headers="d0e590 ">"package library"</td>
|
|
<td valign="top" width="39.325842696629216%" headers="d0e592 ">Specifies the library for the SQL package. This property has no effect
|
|
unless the "extended dynamic" property is set to "true".</td>
|
|
<td align="center" valign="top" width="8.98876404494382%" headers="d0e594 ">no</td>
|
|
<td valign="top" width="17.078651685393258%" headers="d0e596 ">Library for SQL package</td>
|
|
<td valign="top" width="14.606741573033707%" headers="d0e598 ">"QGPL"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20%" headers="d0e590 ">"prefetch"</td>
|
|
<td valign="top" width="39.325842696629216%" headers="d0e592 ">Specifies whether to prefetch data upon executing a SELECT statement.
|
|
This will improve performance when accessing the initial rows in the ResultSet.</td>
|
|
<td align="center" valign="top" width="8.98876404494382%" headers="d0e594 ">no</td>
|
|
<td valign="top" width="17.078651685393258%" headers="d0e596 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="14.606741573033707%" headers="d0e598 ">"true"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20%" headers="d0e590 ">"qaqqinilib"</td>
|
|
<td valign="top" width="39.325842696629216%" headers="d0e592 ">Specifies a QAQQINI library name. Used to specify the
|
|
library that contains the qaqqini file to use. A qaqqini file contains all
|
|
of the attributes that can potentially impact the performance of the DB2<sup>®</sup> UDB for iSeries™ database
|
|
engine.</td>
|
|
<td align="center" valign="top" width="8.98876404494382%" headers="d0e594 ">no</td>
|
|
<td valign="top" width="17.078651685393258%" headers="d0e596 ">"QAQQINI library name"</td>
|
|
<td valign="top" width="14.606741573033707%" headers="d0e598 ">(server default)</td>
|
|
</tr>
|
|
<tr><td valign="top" width="20%" headers="d0e590 "><img src="./delta.gif" alt="Start of change" />"query optimize goal"<img src="./deltaend.gif" alt="End of change" /></td>
|
|
<td valign="top" width="39.325842696629216%" headers="d0e592 "><img src="./delta.gif" alt="Start of change" />Specifies the goal the server should use with optimization
|
|
of queries. This setting corresponds to the server's QAQQINI option called
|
|
OPTIMIZATION_GOAL. <div class="note"><span class="notetitle">Note:</span> This property is ignored when connecting to systems
|
|
running to i5/OS V5R3
|
|
and earlier.</div>
|
|
<img src="./deltaend.gif" alt="End of change" /></td>
|
|
<td align="center" valign="top" width="8.98876404494382%" headers="d0e594 "><img src="./delta.gif" alt="Start of change" />no<img src="./deltaend.gif" alt="End of change" /></td>
|
|
<td valign="top" width="17.078651685393258%" headers="d0e596 "><img src="./delta.gif" alt="Start of change" /><ul class="simple"><li>"0" = Optimize query for first block of data (*FIRSTIO) when extended
|
|
dynamic packages are used; Optimize query for entire result set (*ALLIO) when
|
|
packages are not used</li>
|
|
<li>"1" = Optimize query for first block of data (*FIRSTIO)</li>
|
|
<li>"2" = Optimize query for entire result set (*ALLIO)</li>
|
|
</ul>
|
|
<img src="./deltaend.gif" alt="End of change" /></td>
|
|
<td valign="top" width="14.606741573033707%" headers="d0e598 "><img src="./delta.gif" alt="Start of change" />"0"<img src="./deltaend.gif" alt="End of change" /></td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div class="section" id="jdbcproperties__sort"><a name="jdbcproperties__sort"><!-- --></a><h4 class="sectiontitle">Sort properties</h4><p>Sort properties specify
|
|
how the server performs stores and performs sorts.</p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="border" border="1" rules="all"><thead align="left"><tr class="tablemainheaderbar"><th valign="top" width="21.193415637860085%" id="d0e873">Sort property</th>
|
|
<th valign="top" width="40.123456790123456%" id="d0e875">Description</th>
|
|
<th valign="top" width="9.25925925925926%" id="d0e877">Required</th>
|
|
<th valign="top" width="14.814814814814813%" id="d0e879">Choices</th>
|
|
<th valign="top" width="14.609053497942387%" id="d0e881">Default</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr><td valign="top" width="21.193415637860085%" headers="d0e873 ">"sort"</td>
|
|
<td valign="top" width="40.123456790123456%" headers="d0e875 ">Specifies how the server sorts records before sending them to the client.</td>
|
|
<td align="center" valign="top" width="9.25925925925926%" headers="d0e877 ">no</td>
|
|
<td valign="top" width="14.814814814814813%" headers="d0e879 "> <ul class="simple"><li>"hex" (base the sort on hexadecimal values)</li>
|
|
<li>"job" (base the sort on the setting for the server job)</li>
|
|
<li>"language" (base the sort on the language set in the "sort language"
|
|
property)</li>
|
|
<li>"table" (base the sort on the sort sequence table set in the "sort table"
|
|
property)</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="14.609053497942387%" headers="d0e881 ">"job"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="21.193415637860085%" headers="d0e873 ">"sort language"</td>
|
|
<td valign="top" width="40.123456790123456%" headers="d0e875 ">Specifies a 3-character language id to use for selection of a sort
|
|
sequence. This property has no effect unless the "sort" property is set to
|
|
"language".</td>
|
|
<td align="center" valign="top" width="9.25925925925926%" headers="d0e877 ">no</td>
|
|
<td valign="top" width="14.814814814814813%" headers="d0e879 ">Language id</td>
|
|
<td valign="top" width="14.609053497942387%" headers="d0e881 ">ENU</td>
|
|
</tr>
|
|
<tr><td valign="top" width="21.193415637860085%" headers="d0e873 ">"sort table"</td>
|
|
<td valign="top" width="40.123456790123456%" headers="d0e875 ">Specifies the library and file name of a sort sequence table stored
|
|
on the server. This property has no effect unless the "sort" property is
|
|
set to "table".</td>
|
|
<td align="center" valign="top" width="9.25925925925926%" headers="d0e877 ">no</td>
|
|
<td valign="top" width="14.814814814814813%" headers="d0e879 ">Qualified sort table name</td>
|
|
<td valign="top" width="14.609053497942387%" headers="d0e881 ">""</td>
|
|
</tr>
|
|
<tr><td valign="top" width="21.193415637860085%" headers="d0e873 ">"sort weight"</td>
|
|
<td valign="top" width="40.123456790123456%" headers="d0e875 ">Specifies how the server treats case while sorting records. This property
|
|
has no effect unless the "sort" property is set to "language".</td>
|
|
<td align="center" valign="top" width="9.25925925925926%" headers="d0e877 ">no</td>
|
|
<td valign="top" width="14.814814814814813%" headers="d0e879 "><ul class="simple"><li>"shared" (uppercase and lowercase characters sort as the same character)</li>
|
|
<li>"unique" (uppercase and lowercase characters sort as different characters)</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="14.609053497942387%" headers="d0e881 ">"shared"</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div class="section" id="jdbcproperties__other"><a name="jdbcproperties__other"><!-- --></a><h4 class="sectiontitle">Other properties</h4><p>Other properties are
|
|
those properties not easily categorized. These properties determine which
|
|
JDBC driver is used, and specify options related to level of database access,
|
|
bidirectional string type, data truncation and so on.</p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="border" border="1" rules="all"><thead align="left"><tr class="tablemainheaderbar"><th valign="top" width="11.981566820276496%" id="d0e955">Other property</th>
|
|
<th valign="top" width="36.405529953917046%" id="d0e957">Description</th>
|
|
<th valign="top" width="8.986175115207374%" id="d0e959">Required</th>
|
|
<th valign="top" width="31.336405529953915%" id="d0e961">Choices</th>
|
|
<th valign="top" width="11.29032258064516%" id="d0e963">Default</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"access"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies the level of database access for the connection.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"all" (all SQL statements allowed)</li>
|
|
<li>"read call" (SELECT and CALL statements allowed)</li>
|
|
<li>"read only" (SELECT statements only)</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">"all"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"behavior override"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies which IBM<sup>®</sup> Toolbox for Java JDBC driver behaviors to override.
|
|
You can change multiple behaviors in combination by adding the constants
|
|
and passing that sum on this property. Be sure that your application correctly
|
|
handles the altered behavior. </td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"" (do not override any behavior)</li>
|
|
<li>"1" (do not throw an exception but instead return null for the result
|
|
set if Statement.executeQuery() or PreparedStatement. executeQuery() do not
|
|
return a result set)</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">""</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"bidi string type"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies the output string type of bidirectional data. See <a href="javadoc/com/ibm/as400/access/BidiStringType.html#NAVBAR_TOP">BidiStringType</a>
|
|
for more information.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"" (use the CCSID to determine bidirectional string type)</li>
|
|
<li>"0" (the default string type for nonbidirectional data (LTR))</li>
|
|
<li>"4"</li>
|
|
<li>"5"</li>
|
|
<li>"6"</li>
|
|
<li>"7"</li>
|
|
<li>"8"</li>
|
|
<li>"9"</li>
|
|
<li>"10"</li>
|
|
<li>"11"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">""</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"bidi implicit reordering"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies if bidi implicit LTR-RTL reordering should
|
|
be used.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">"true"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"bidi numeric reordering"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies if the numeric ordering round trip feature
|
|
should be used.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">"false"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"data truncation"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 "><p>Specifies whether truncation of <strong>character data</strong> generates
|
|
attention notices and exceptions. When this property is "true", the following
|
|
apply:</p>
|
|
<ul><li>Writing truncated character data to the database throws an exception</li>
|
|
<li>Using truncated character data in a query posts an attention notice.</li>
|
|
</ul>
|
|
<p>When this property is "false", writing truncated data to the database
|
|
or using such data in a query generates no exception or attention notice.</p>
|
|
<p> The
|
|
default value is "true".</p>
|
|
<p>This property does not affect <strong>numeric data</strong>.
|
|
Writing truncated numeric data to the database always throws an error and
|
|
using truncated numeric data in a query always posts attention notices. </p>
|
|
</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">"true"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"driver"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies the JDBC driver implementation. The IBM Toolbox for Java JDBC driver can use different JDBC
|
|
driver implementations based on the environment. If the environment is an iSeries JVM
|
|
on the same server as the database to which the program is connecting, the
|
|
native IBM Developer
|
|
Kit for Java JDBC driver can be used. In any other environment,
|
|
the IBM
|
|
Toolbox for Java JDBC driver is used. This property has no effect
|
|
if the "secondary URL" property is set. </td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"toolbox" (use only the IBM Toolbox for Java JDBC driver)</li>
|
|
<li>"native" (use the IBM Developer Kit for Java JDBC driver if running on the server,
|
|
otherwise use the IBM Toolbox for Java JDBC driver)</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">"toolbox"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"errors"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies the amount of detail to be returned in the message for errors
|
|
that occur on the server.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"basic"</li>
|
|
<li>"full"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">"basic"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"extended metadata"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies whether the driver requests extended metadata from the server.
|
|
Setting this property to true increases the accuracy of the information returned
|
|
from the following ResultSetMetaData methods: <ul><li>getColumnLabel(int)</li>
|
|
<li>isReadOnly(int)</li>
|
|
<li>isSearchable(int)</li>
|
|
<li>isWriteable(int)</li>
|
|
</ul>
|
|
<p>Additionally, setting this property to true enables support for the
|
|
ResultSetMetaData.getSchemaName(int) method. Setting this property to true
|
|
may degrade performance because it requires retrieving more information from
|
|
the server. Leave the property as the default (false) unless you need more
|
|
specific information from the listed methods. For example, when this property
|
|
is off (false), ResultSetMetaData.isSearchable(int) always returns "true"
|
|
because because the driver does not have enough information from the server
|
|
to make a judgment. Turning on this property (true) forces the driver to
|
|
get the correct data from the server.</p>
|
|
<p>You can use extended metadata
|
|
only when connecting to a server running i5/OS V5R2 or later.</p>
|
|
</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">"false"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"full open"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies whether the server fully opens a file for each query. By
|
|
default the server optimizes open requests. This optimization improves performance
|
|
but may fail if a database monitor is active when a query is run more than
|
|
once. Set the property to true only when identical queries are issued when
|
|
monitors are active.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"true"</li>
|
|
<li> "false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">"false" </td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"hold input locators"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies whether input locators should be allocated
|
|
as type hold locators or not hold locators. If the locators are of type hold,
|
|
they will not be released when a commit is done.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"true" (type hold)</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">"true"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"hold statements"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies if statements should remain open until a transaction
|
|
boundary when autocommit is off and they are associated with a LOB locator.
|
|
By default, all the resources associated with a statement are released when
|
|
the statement is closed. Set this property to true only when access to a LOB
|
|
locator is needed after a statement has been closed.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">"false"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"key ring name"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies the key ring class name used for SSL connections with the
|
|
server. This property has no effect unless "secure" is set to true and a
|
|
key ring password is set using the "key ring password" property.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 ">"key ring name"</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">""</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"key ring password"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies the password for the key ring class used for SSL communications
|
|
with the server. This property has no effect unless "secure" is set to true
|
|
and a key ring name is set using the "key ring name" property.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 ">"key ring password"</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">""</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"proxy server"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies the host name and port of the middle-tier machine where
|
|
the proxy server is running. The format for this is <em>hostname</em>[:<em>port</em>],
|
|
where the port is optional. If this is not set, then the hostname and port
|
|
are retrieved from the <em>com.ibm.as400.access.AS400.proxyServer</em> property.
|
|
The default port is <em>3470</em> (if the connection uses SSL, the default
|
|
port is <em>3471</em>). The ProxyServer must be running on the middle-tier
|
|
machine. <p>The name of the middle-tier machine is ignored in a two-tier
|
|
environment.</p>
|
|
</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 ">Proxy server host name and port</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">(value of the proxyServer property, or none if not set)</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"remarks"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies the source of the text for REMARKS columns in ResultSets
|
|
returned by DatabaseMetaData methods.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"sql" (SQL object comment)</li>
|
|
<li>"system" (i5/OS object
|
|
description)</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">"system"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"secondary URL"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies the URL to be used for a connection on the middle-tier's
|
|
DriverManager in a multiple tier environment, if it is different than already
|
|
specified. This property allows you to use this driver to connect to databases
|
|
other than the iSeries server.
|
|
Use a backslash as an escape character before backslashes and semicolons
|
|
in the URL.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 ">JDBC URL</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">(current JDBC URL)</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"secure"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies whether a Secure Sockets Layer (SSL) connection is used
|
|
to communicate with the server. SSL connections are only available when connecting
|
|
to servers at V4R4 or later.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"true" (encrypt all client/server communication)</li>
|
|
<li>"false" (encrypt only the password)</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">"false"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"server trace"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies the level of tracing of the JDBC server job. When tracing
|
|
is enabled, tracing starts when the client connects to the server and ends
|
|
when the connection is disconnected. You must start tracing before connecting
|
|
to the server, because the client enables server tracing only at connect
|
|
time. </td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"0" (trace is not active)</li>
|
|
<li>"2" (start the database monitor on the JDBC server job)</li>
|
|
<li>"4" (start debug on the JDBC server job)</li>
|
|
<li>"8" (save the job log when the JDBC server job ends)</li>
|
|
<li>"16" (start job trace on the JDBC server job)</li>
|
|
<li>"32" (save SQL information)</li>
|
|
<li>"64" (supports the activation of database host server tracing)</li>
|
|
</ul>
|
|
<p>Multiple types of trace can be started by adding these values together.
|
|
For example, "6" starts the database monitor and starts debug. </p>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">"0"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"thread used"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies whether threads are used in communication with the host servers.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">"true"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"toolbox trace"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies what category of an IBM Toolbox for Java trace to log. Trace messages are useful
|
|
for debugging programs that call JDBC. However, there is a performance penalty
|
|
associated with logging trace messages, so this property is only set for debugging.
|
|
Trace messages are logged to System.out.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>""</li>
|
|
<li>"none"</li>
|
|
<li>"datastream" (log data flow between the local host and the remote system)</li>
|
|
<li>"diagnostic" (log object state information)</li>
|
|
<li>"error" (log errors that cause an exception)</li>
|
|
<li>"information" (used to track the flow of control through the code)</li>
|
|
<li>"warning" (log errors that are recoverable)</li>
|
|
<li>"conversion" (log character set conversions between Unicode and native
|
|
code pages)</li>
|
|
<li>"proxy" (log data flow between the client and the proxy server)</li>
|
|
<li>"pcml" (used to determine how PCML interprets the data that is sent to
|
|
and from the server)</li>
|
|
<li>"jdbc" (log jdbc information)</li>
|
|
<li>"all" (log all categories)</li>
|
|
<li>"thread" (log thread information)</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">""</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"trace"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies whether trace messages are logged. Trace messages are useful
|
|
for debugging programs that call JDBC. However, there is a performance penalty
|
|
associated with logging trace messages, so this property only set to "true"
|
|
for debugging. Trace messages are logged to System.out.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">"false"</td>
|
|
</tr>
|
|
<tr><td valign="top" width="11.981566820276496%" headers="d0e955 ">"translate binary"</td>
|
|
<td valign="top" width="36.405529953917046%" headers="d0e957 ">Specifies whether binary data is translated. If this property is set
|
|
to "true", then BINARY and VARBINARY fields are treated as CHAR and VARCHAR
|
|
fields.</td>
|
|
<td align="center" valign="top" width="8.986175115207374%" headers="d0e959 ">no</td>
|
|
<td valign="top" width="31.336405529953915%" headers="d0e961 "><ul class="simple"><li>"true"</li>
|
|
<li>"false"</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="11.29032258064516%" headers="d0e963 ">"false"</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<ul class="ullinks">
|
|
<li class="ulchildlink"><strong><a href="jdbcliblistproperty.htm">JDBC Librarylist property</a></strong><br />
|
|
The JDBC LibraryList property specifies one or more libraries that you want to add to or replace the library list of the server job, and optionally sets the default library (default schema).</li>
|
|
</ul>
|
|
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="jdbc2.htm" title="JDBC is an application programming interface (API) included in the Java platform that enables Java programs to connect to a wide range of databases.">JDBC</a></div>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html> |