AS/400 Toolbox for Java \ Access classes \ JDBC \ JDBC properties

JDBC Properties

Start changeThe following table lists various JDBC properties for AS/400 Toolbox for Java. It specifies whether the property is supported by AS/400 Toolbox for Java JDBC and/or Native JDBC and offers a description of the property in question.
Property AS/400 Toolbox for Java JDBC Support Native JDBC Support Description
user X X User name for connecting to AS/400
password X X Password for connecting to AS/400
prompt X   Specifies whether the user should be prompted if a user name or password is needed to connect to the AS/400 server
libraries X X The AS/400 libraries to add to the server's job library list. For Native, only one library is allowed and it will be used as the default library
transaction isolation X X Sets the transaction isolation level for the connection. Has same affect as using Connection.setTransactionIsolation()
date format X   The date format used in date literals within SQL statements
date separator X   The date separator used in date literals within SQL statements
decimal separator X   The decimal separator used in numeric literals within SQL statements
do escape processing   X Specifies if statements under the connection must do escape processing. Using escape processing is a way to code your SQL statements so that they are generic and similar for all platforms, but then the database reads the escape clauses and substitutes the proper system specific version for the user
naming X X The naming convention used when referring to tables (sql versus system)
time format X   The time format used in time literals within SQL statements
time separator X   The time separator used in time literals within SQL statements
block criteria X   The criteria for retrieving data from the AS/400 server in blocks of records
block size X X The block size in kilobytes to retrieve from the AS/400 server and cache on the client
blocking enabled   X Specifies if the connection should use blocking on result set row retrieval
lob threshold X   Specifies the maximum LOB (large object) size in kilobytes that can be retrieved as part of a result set
prefetch X   Specifies whether to prefetch data upon executing a SELECT statement
extended dynamic X   Extended dynamic support provides a mechanism for caching dynamic SQL statements on the server
package X   Specifies the base name of the SQL package
package library X   Specifies the library for the SQL package
package criteria X   Specifies the type of SQL statements to be stored in the SQL package
package cache X   Specifies whether to cache SQL packages in memory
package clear X   Specifies whether to clear SQL packages when they become full
package add X   Specifies whether to add statements to an existing SQL package
package error X   Specifies the action to take when SQL package errors occur
sort X   Specifies how the server sorts records before sending them to the client
sort language X   Specifies a three-character language id to use for selection of a sort sequence
sort table X   Specifies the library and file name of a sort sequence table stored on the AS/400 server
sort weight X   Specifies how the server treats case while sorting records
access X X Specifies the level of database access for the connection
error X   Specifies the amount of detail to be returned in the message for errors that occur on the AS/400 server
remarks X   Specifies the source of the text for REMARKS columns in ResultSets returned by DatabaseMetaData methods
secure X   Specifies whether a SecureSockets Layer (SSL) connection is used to communicate with the server
translate binary X X Specifies whether binary data is translated
trace X X Specifies whether trace messages should be logged
JDBC Class Methods
Connection setAutoCommit()
setCatalog()
setReadOnly()
setTransactionIsolation()
setTypeMap()
Statement setCursorName()
setEscapeProcessing()
setFetchDirection()
setFetchSize()
setMaxFieldSize()
setMaxRows()
setQueryTimeout()
End change
[ Information Center Home Page | Feedback ] [ Legal | AS/400 Glossary ]