8.1.6 getPropertyInfo(String url, Properties info)
- Organization of this subsection
(1) Function
This method acquires information about the JDBC driver's valid properties.
(2) Format
public synchronized DriverPropertyInfo[] getPropertyInfo(String url, Properties info) throws SQLException
(3) Arguments
- String url
-
Specifies the URL to be used for connection.
For details about the specification format of the URL to be used for connection, see (a) Values to be specified in the url argument (specifying the URL for the connection) in (2) Connecting to the HADB server with the getConnection method in 7.3.1 Using the getConnection method of the DriverManager class to connect to the HADB server.
- Properties info
-
Specifies a list of property names and their values as the connection arguments.
(4) Return value
This method returns the array of the DriverPropertyInfo object for specifying valid properties. If no properties are needed, this array might be empty.
The following table lists the settings for the fields of DriverPropertyInfo.
|
Property name |
DriverPropertyInfo field |
||||
|---|---|---|---|---|---|
|
name |
value |
description |
required |
choices |
|
|
adb_clt_rpc_srv_host |
Same as the property name |
null |
"Host Name" |
true |
null |
|
adb_clt_rpc_srv_port |
null |
"Port Number" |
true |
null |
|
|
adb_clt_rpc_con_wait_time |
"300" |
"Connect Wait Time" |
false |
null |
|
|
adb_clt_rpc_sql_wait_time |
"0" |
"Sql Wait Time" |
false |
null |
|
|
adb_clt_ap_name |
"********" |
"Application Name" |
false |
null |
|
|
adb_clt_group_name |
null |
"Client Group Name" |
false |
null |
|
|
adb_clt_fetch_size |
"1024" |
"Fetch Size" |
false |
null |
|
|
adb_clt_sql_text_out |
"N" |
"Text Out" |
false |
{Y","N"} |
|
|
adb_clt_trn_iso_lv |
"READ_COMMITTED" |
"Isolation Level" |
false |
{"READ_COMMITTED","REPEATABLE_READ"} |
|
|
adb_clt_sql_order_mode |
"BYTE" |
"Order Mode" |
false |
{"BYTE","ISO"} |
|
|
adb_clt_trn_access_mode |
"READ_WRITE" |
"Access Mode" |
false |
{"READ_WRITE","READ_ONLY"} |
|
|
adb_dbbuff_wrktbl_clt_blk_num |
"256" |
"Work Table Block Number" |
false |
null |
|
|
adb_sql_prep_delrsvd_use_srvdef |
"Y" |
"Delete Reserved Word Using Server Definition" |
false |
{Y","N"} |
|
|
adb_sql_prep_dec_div_rs_prior |
"INTEGRAL_PART" |
"Decimal Division Result Prior" |
false |
{"INTEGRAL_PART","FRACTIONAL_PART"} |
|
|
adb_sql_exe_max_rthd_num |
"4" |
"Sql Execute Max Real Thread Number" |
false |
null |
|
|
adb_sql_exe_hashgrp_area_size |
"4800" |
"Hash Group Area Size" |
false |
null |
|
|
adb_sql_exe_hashtbl_area_size |
"2000" |
"Hash Table Area Size" |
false |
null |
|
|
adb_sql_exe_hashflt_area_size |
"200" |
"Hash Filter Area Size" |
false |
null |
|
|
adb_jdbc_exc_trc_out_path |
null |
"Exception Trace Out Path" |
false |
null |
|
|
adb_jdbc_info_max |
"5" |
"Exception Trace Information Max Number" |
false |
null |
|
|
adb_jdbc_cache_info_max |
"1000" |
"Exception Trace Cache Information Max Number" |
false |
null |
|
|
adb_jdbc_trc_out_lv |
"1" |
"Exception Trace Out Level" |
false |
null |
|
|
encodelang |
null |
"Encode Lang" |
false |
null |
|
|
methodtrace |
"OFF" |
"JDBC Interface Trace" |
false |
{"ON","OFF"} |
|
|
tracenum |
"500" |
"Trace Entry Number" |
false |
null |
|
|
sqlwarningkeep |
"TRUE" |
"Keeping up the Warning Objects" |
false |
{"TRUE","FALSE"} |
|
|
user |
null |
"UserID" |
true |
null |
|
|
password |
null |
"Password" |
true |
null |
|
This method analyzes the information specified in url and info and returns the information needed for connecting to the HADB server.
If the acceptsURL method returns false, this method returns null.
(5) Exceptions
None.