PostgreSQL JDBC Driver 接続プロパティ
【PR】当サイトはプロモーションが含まれています。
PostgreSQL JDBC Driver 42.7
| name | description | required | choices |
|---|---|---|---|
| adaptiveFetch | Specifies if number of rows fetched in ResultSet should be adaptive to maxResultBuffer and max row size. | false | |
| adaptiveFetchMaximum | Specifies maximum number of rows used by adaptive fetch. | false | |
| adaptiveFetchMinimum | Specifies minimum number of rows used by adaptive fetch. | false | |
| allowEncodingChanges | Allow for changes in client_encoding | false | |
| ApplicationName | Name of the Application (backend >= 9.0) | false | |
| assumeMinServerVersion | Assume the server is at least that version | false | |
| authenticationPluginClassName | Name of class which implements AuthenticationPlugin | false | |
| autosave | Specifies what the driver should do if a query fails. In autosave=always mode, JDBC driver sets a savepoint before each query, and rolls back to that savepoint in case of failure. In autosave=never mode (default), no savepoint dance is made ever. In autosave=conservative mode, safepoint is set for each query, however the rollback is done only for rare cases like 'cached statement cannot change return type' or 'statement XXX is not valid' so JDBC driver rollsback and retries | false | always,never,conservative |
| binaryTransfer | Use binary format for sending and receiving data if possible | false | |
| binaryTransferDisable | Comma separated list of types to disable binary transfer. Either OID numbers or names. Overrides values in the driver default set and values set with binaryTransferEnable. | false | |
| binaryTransferEnable | Comma separated list of types to enable binary transfer. Either OID numbers or names | false | |
| cancelSignalTimeout | The timeout that is used for sending cancel command. | false | |
| cleanupSavepoints | Determine whether SAVEPOINTS used in AUTOSAVE will be released per query or not | false | true,false |
| connectTimeout | The timeout value in seconds used for socket connect operations. | false | |
| currentSchema | Specify the schema (or several schema separated by commas) to be set in the search-path | false | |
| databaseMetadataCacheFields | Specifies the maximum number of fields to be cached per connection. A value of {@code 0} disables the cache. | false | |
| databaseMetadataCacheFieldsMiB | Specifies the maximum size (in megabytes) of fields to be cached per connection. A value of {@code 0} disables the cache. | false | |
| defaultRowFetchSize | Positive number of rows that should be fetched from the database when more rows are needed for ResultSet by each fetch iteration | false | |
| disableColumnSanitiser | Enable optimization that disables column name sanitiser | false | |
| escapeSyntaxCallMode | Specifies how the driver transforms JDBC escape call syntax into underlying SQL, for invoking procedures or functions. (backend >= 11)In escapeSyntaxCallMode=select mode (the default), the driver always uses a SELECT statement (allowing function invocation only).In escapeSyntaxCallMode=callIfNoReturn mode, the driver uses a CALL statement (allowing procedure invocation) if there is no return parameter specified, otherwise the driver uses a SELECT statement.In escapeSyntaxCallMode=call mode, the driver always uses a CALL statement (allowing procedure invocation only). | false | select,callIfNoReturn,call |
| groupStartupParameters | This is important in pool-by-transaction scenarios in order to make sure that all the statements reaches the same connection that is being initialized. | false | |
| gssEncMode | Force Encoded GSS Mode | false | disable,allow,prefer,require |
| gsslib | Force SSSPI or GSSAPI | false | auto,sspi,gssapi |
| gssResponseTimeout | Time in milliseconds we wait for a response from the server after requesting a GSS upgrade | false | |
| hideUnprivilegedObjects | Enable hiding of database objects for which the current user has no privileges granted from the DatabaseMetaData | false | |
| hostRecheckSeconds | Specifies period (seconds) after which the host status is checked again in case it has changed | false | |
| jaasApplicationName | Specifies the name of the JAAS system or application login configuration. | false | |
| jaasLogin | Login with JAAS before doing GSSAPI authentication | false | |
| kerberosServerName | The Kerberos service name to use when authenticating with GSSAPI. | false | |
| loadBalanceHosts | If disabled hosts are connected in the given order. If enabled hosts are chosen randomly from the set of suitable candidates | false | |
| localSocketAddress | Local Socket address, if set bind the client side of the socket to this address | false | |
| loggerFile | File name output of the Logger | false | |
| loggerLevel | Logger level of the driver | false | OFF,DEBUG,TRACE |
| loginTimeout | Specify how long in seconds to wait for establishment of a database connection. | false | |
| logServerErrorDetail | Include full server error detail in exception messages. If disabled then only the error itself will be included. | false | |
| logUnclosedConnections | When connections that are not explicitly closed are garbage collected, log the stacktrace from the opening of the connection to trace the leak source | false | |
| maxResultBuffer | Specifies size of buffer during fetching result set. Can be specified as specified size or percent of heap memory. | false | |
| options | Specify 'options' connection initialization parameter. | false | |
| password | Password to use when authenticating. | false | |
| PGDBNAME | Database name to connect to (may be specified directly in the JDBC URL) | true | |
| PGHOST | Hostname of the PostgreSQL server (may be specified directly in the JDBC URL) | false | |
| PGPORT | Port of the PostgreSQL server (may be specified directly in the JDBC URL) | false | |
| preferQueryMode | Specifies which mode is used to execute queries to database: simple means ('Q' execute, no parse, no bind, text mode only), extended means always use bind/execute messages, extendedForPrepared means extended for prepared statements only, extendedCacheEverything means use extended protocol and try cache every statement (including Statement.execute(String sql)) in a query cache. | false | extended,extendedForPrepared,extendedCacheEverything,simple |
| preparedStatementCacheQueries | Specifies the maximum number of entries in per-connection cache of prepared statements. A value of {@code 0} disables the cache. | false | |
| preparedStatementCacheSizeMiB | Specifies the maximum size (in megabytes) of a per-connection prepared statement cache. A value of {@code 0} disables the cache. | false | |
| prepareThreshold | Statement prepare threshold. A value of {@code -1} stands for forceBinary | false | |
| protocolVersion | Force use of a particular protocol version when connecting, currently only version 3 is supported. | false | 3 |
| quoteReturningIdentifiers | Quote identifiers provided in returning array | false | |
| readOnly | Puts this connection in read-only mode | false | |
| readOnlyMode | Controls the behavior when a connection is set to be read only, one of 'ignore', 'transaction', or 'always' When 'ignore', setting readOnly has no effect. When 'transaction' setting readOnly to 'true' will cause transactions to BEGIN READ ONLY if autocommit is 'false'. When 'always' setting readOnly to 'true' will set the session to READ ONLY if autoCommit is 'true' and the transaction to BEGIN READ ONLY if autocommit is 'false'. | false | ignore,transaction,always |
| receiveBufferSize | Socket read buffer size | false | |
| replication | Connection parameter passed in startup message, one of 'true' or 'database' Passing 'true' tells the backend to go into walsender mode, wherein a small set of replication commands can be issued instead of SQL statements. Only the simple query protocol can be used in walsender mode. Passing 'database' as the value instructs walsender to connect to the database specified in the dbname parameter, which will allow the connection to be used for logical replication from that database. (backend >= 9.4) | false | |
| reWriteBatchedInserts | Enable optimization to rewrite and collapse compatible INSERT statements that are batched. | false | |
| sendBufferSize | Socket write buffer size | false | |
| service | Service name to be searched in pg_service.conf resource | false | |
| socketFactory | Specify a socket factory for socket creation | false | |
| socketFactoryArg | Argument forwarded to constructor of SocketFactory class. | false | |
| socketTimeout | The timeout value in seconds max(2147484) used for socket read operations. | false | |
| ssl | Control use of SSL (any non-null value causes SSL to be required) | false | |
| sslcert | The location of the client's SSL certificate | false | |
| sslfactory | Provide a SSLSocketFactory class when using SSL. | false | |
| sslfactoryarg | Argument forwarded to constructor of SSLSocketFactory class. | false | |
| sslhostnameverifier | A class, implementing javax.net.ssl.HostnameVerifier that can verify the server | false | |
| sslkey | The location of the client's PKCS#8 SSL key | false | |
| sslmode | Parameter governing the use of SSL | false | disable,allow,prefer,require,verify-ca,verify-full |
| sslpassword | The password for the client's ssl key (ignored if sslpasswordcallback is set) | false | |
| sslpasswordcallback | A class, implementing javax.security.auth.callback.CallbackHandler that can handle PasswordCallback for the ssl password. | false | |
| sslResponseTimeout | Time in milliseconds we wait for a response from the server after requesting SSL upgrade | false | |
| sslrootcert | The location of the root certificate for authenticating the server. | false | |
| sspiServiceClass | The Windows SSPI service class for SPN | false | |
| stringtype | The type to bind String parameters as (usually 'varchar', 'unspecified' allows implicit casting to other types) | false | unspecified,varchar |
| targetServerType | Specifies what kind of server to connect | false | any,primary,master,slave,secondary,preferSlave,preferSecondary,preferPrimary |
| tcpKeepAlive | Enable or disable TCP keep-alive. The default is {@code false}. | false | |
| tcpNoDelay | Enable or disable TCP no delay. The default is (@code true}. | false | |
| unknownLength | Specifies the length to return for types of unknown length | false | |
| user | Username to connect to the database as. | true | |
| useSpnego | Use SPNEGO in SSPI authentication requests | false | |
| xmlFactoryFactory | Factory class to instantiate factories for XML processing | false |
