IBM Toolbox for Java JDBC Driver Connection Property / Datasource Property Conversion Chart

Troubleshooting

Problem

This document lists all of the available connection properties in the IBM Toolbox for Java JDBC driver and the data source property name and connection string keywords for them.

Resolving The Problem

This table lists all of the available connection properties in the IBM Toolbox for Java JDBC driver and the data source property name and connection string keywords for them.

Connection String Property	Datasource Property Name
`access`	`access`
`autocommit exception`	`autocommitException`
`behavior override`	`behaviorOverride`
`bidi implicit reordering`	`bidiImplicitReordering`
`bidi numeric ordering`	`bidiNumericOrdering`
`bidi string type`	`bidiStringType`
`big decimal`	`bigDecimal`
`block criteria`	`blockCriteria`
`block size`	`blockSize`
`concurrent access resolution`	`concurrentAccessResolution`
`cursor hold`	`cursorHold`
`cursor sensitivity`	`cursorSensitivity`
`data compression`	`dataCompression`
`data truncation`	`dataTruncation`
`database name`	`databaseName`
`date format`	`dateFormat`
`date separator`	`dateSeparator`
`decfloat rounding mode`	`decfloatRoundingMode`
`decimal separator`	`decimalSeparator`
`driver`	`driver`
`errors`	`errors`
`extended dynamic`	`extendedDynamic`
`extended metadata`	`extendedMetaData`
`full open`	`fullOpen`
`hold input locators`	`holdInputLocators`
`hold statements`	`holdStatements`
`ignore warnings`	`ignoreWarnings`
`keep alive`	`keepAlive`
`lazy close`	`lazyClose`
`libraries`	`libraries`
`lob threshold`	`lobThreshold`
`login timeout`	`loginTimeout`
`maximum blocked input rows`	`maximumBlockedInputRows`
`maximum precision`	`maximumPrecision`
`maximum scale`	`maximumScale`
`metadata source`	`metaDataSource`
`minimum divide scale`	`mininumDivideScale`
`naming`	`naming`
`package`	`package`
`package add`	`packageAdd`
`package cache`	`packageCache`
`package ccsid`	`packageCCSID`
`package clear`	`packageClear`
`package criteria`	`packageCriteria`
`package error`	`packageError`
`package library`	`packageLibrary`
`prefetch`	`prefetch`
`prompt`	`prompt`
`proxy server`	`proxyServer`
`qaqqinilib`	`qaqqiniLibrary`
`query optimize goal`	`queryOptimizeGoal`
`query storage limit`	`queryStorageLimit`
`receive buffer size`	`receiveBufferSize`
`remarks`	`remarks`
`rollback cursor hold`	`rollbackCursorHold`
`secondary URL`	`secondaryUrl`
`secure`	`secure`
`secure current user`	`secureCurrentUser`
`send buffer size`	`sendBufferSize`
`server trace`	`serverTraceCategories`
`socket timeout`	`socketTimeout`
`sort`	`sort`
`sort language`	`sortLanguage`
`sort table`	`sortTable`
`sort weight`	`sortWeight`
`thread used`	`threadUsed`
`time format`	`timeFormat`
`time separator`	`timeSeparator`
`toolbox trace`	`toolboxTrace`
`trace`	`trace`
`translate binary`	`translateBinary`
`translate boolean`	`translateBoolean`
`translate hex`	`translateHex`
`true autocommit`	`trueAutoCommit`
`use block update`	`useBlockUpdate`
`variable field compression`	`variableFieldCompression`
`XA loosely coupled support`	`xaLooselyCoupledSupport`

[{"Product":{"code":"SWG60","label":"IBM i"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Data Access","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Historical Number

486918967

Was this topic helpful?

Document Information

Modified date:
07 July 2021

UID

nas8N1013685

Tips