This topic describes how to view and set the database kernel and the session variables supported by the Java Database Connectivity (JDBC) driver.
View session variables
View the session.properties file in the {ob-loader-dumper}/confdirectory. Sample code:
$cd /home/admin/obloaderobdumper/ob-loader-dumper-4.2.1-RELEASE/conf
$cat session.properties
Session variables
| Session variable | Default value | Description |
|---|---|---|
| ob.timeout.for.query.metadata | 5 | The timeout period for querying metadata. Default unit: minute. |
| ob.timeout.for.exec.ddl | 1 | The timeout period for querying DDL statements. The value cannot exceed 60 minutes. Default unit: minute. |
| ob.timeout.for.exec.dml | 1 | The timeout period for querying DML statements. The value cannot exceed 24 hours. Default unit: hour. |
| ob.query.timeout.for.dump.record | 1 | The timeout period for querying exported records. The value cannot exceed 24 hours. Default unit: hour. |
| ob.trx.timeout.for.dump.record | 24 | The timeout period of a transaction for exporting records. The value cannot exceed 24 hours. Default unit: hour. |
| ob.net.read.timeout.for.dump.record | 24 | The timeout period for reading exported records. The records can be in the CSV, CUT, or SQL format. The value cannot exceed 24 hours. Default unit: hour. |
| ob.net.write.timeout.for.dump.record | 24 | The timeout period for writing exported records. The records can be in the CSV, CUT, or SQL format. The value cannot exceed 24 hours. Default unit: hour. |
| ob.proxy.route.policy | follower_first | Sets the ob_proxy_route_policy session variable. |
| jdbc.url.use.ssl | false | Sets theuse.ssl parameter of the jdbc url option. |
| jdbc.url.use.unicode | false | Sets the useUnicode parameter of the jdbc url option. |
| jdbc.url.socket.timeout | 30 | Sets the socketTimeout parameter of the jdbc url option. Default unit: minute. |
| jdbc.url.connect.timeout | 3 | Sets the connectTimeout parameter of the jdbc url option. Default unit: minute. |
| jdbc.url.character.encoding | utf8 | Sets the characterEncoding parameter of the jdbc url option. |
| jdbc.url.use.compression | true | Sets the useCompression parameter of the jdbc url option. |
| jdbc.url.cache.prep.stmts | true | Sets the cachePrepStmts parameter of the jdbc url option. |
| jdbc.url.no.datetime.string.sync | true | Sets the noDatetimeStringSync parameter of the jdbc url option. |
| jdbc.url.use.server.prep.stmts | true | Sets the useServerPrepStmts parameter of the jdbc url option. |
| jdbc.url.allow.multi.queries | true | Sets the allowMultiQueries parameter of the jdbc url option. |
| jdbc.url.rewrite.batched.statements | true | Sets the rewriteBatchedStatements parameter of the jdbc url option. |
| jdbc.url.use.local.session.state | true | Sets the useLocalSessionState parameter of the jdbc url option. |
| jdbc.url.zero.datetime.behavior | convertToNull | Sets the zeroDateTimeBehavior parameter of the jdbc url option. |
| jdbc.url.verify.server.certificate | false | Sets the verifyServerCertificate parameter of the jdbc url option. |
| jdbc.url.use.pipeline.auth | false | Sets the usePipelineAuth parameter of the jdbc url option. |
| jdbc.url.socks.proxy.host | null | Sets the socketProxyHost parameter of the jdbc url option. |
| jdbc.url.socks.proxy.port | null | Sets the socketProxyPort parameter of the jdbc url option. |
Set a session variable
Example: Find the ob.query.timeout.for.init.session variable in the session.properties file and change its value.
# This variable is used to initialize the session.
# The default value is 5 minutes.
ob.query.timeout.for.init.session=6