Miscellaneous
このセクションでは、本プロバイダーの接続文字列で設定可能なMiscellaneous プロパティの全リストを提供します。
| プロパティ | 説明 |
| BatchSize | 送信する各バッチ処理の最大サイズ。 |
| Charset | Specifies the session character set for encoding and decoding character data transferred to and from the Teradata Database. The default value is ASCII. |
| ClientCharset | Specifies the Java character set for encoding and decoding character data transferred to and from the Teradata Database. |
| ColumnName | Controls the behavior of the ResultSetMetaData getColumnName and getColumnLabel methods. |
| ConnectionLifeTime | 接続の最大有効期間（秒単位）。その時間が経過すると、接続オブジェクトは削除されます。 |
| ConnectOnOpen | このプロパティは、接続が開かれたときにTeradata に接続するかどうかを指定します。 |
| Cop | Specifies whether COP Discovery is performed. |
| CopLast | Specifies how COP Discovery determines the last COP hostname. |
| Ddstats | Specify the value for DDSTATS. |
| DisableAutoCommitInBatch | Specifies whether or not disable the autocommit when executing the batch operation. |
| EncryptData | Specify the EncryptData value, ON or OFF. |
| ErrorQueryCount | Specifies the maximum number of times that JDBC FastLoad will attempt to query FastLoad Error Table 1 after a JDBC FastLoad operation. |
| ErrorQueryInterval | Specifies the number of milliseconds that JDBC FastLoad will wait in between attempts to query FastLoad Error Table 1 after a JDBC FastLoad operation. |
| ErrorTable1Suffix | Specifies the suffix for the name of FastLoad Error Table 1 created by JDBC FastLoad and JDBC FastLoad CSV. |
| ErrorTable2Suffix | Specifies the suffix for the name of FastLoad Error Table 2 created by JDBC FastLoad and JDBC FastLoad CSV. |
| ErrorTableDatabase | Specifies the database name for the FastLoad error tables created by JDBC FastLoad and JDBC FastLoad CSV. |
| FieldSep | Specifies a field separator for use with JDBC FastLoad CSV only. The default separator is ',' (comma). |
| FinalizeAutoClose | Specify the value for FinalizeAutoClose, ON or OFF. |
| GeturlCredentials | Specify the value for GeturlCredentials, ON or OFF. |
| Govern | Specify the value for GOVERN, ON or OFF. |
| HttpsPort | Connects to the database on the Transmission Control Protocol/Internet Protocol (TCP/IP) port specified for HTTPS/TLS connections. |
| LiteralUnderscore | Automatically escape LIKE-predicate patterns in DatabaseMetaData calls, such as schemPattern and tableNamePattern. |
| LobSupport | Specify the value for LobSupport, ON or OFF. |
| LobTempTable | Specifies the name of a table with the following columns: id integer, bval blob, cval clob. |
| LogData | Specifies additional data needed by a logon mechanism, such as a secure token, Distinguished Name, or a domain/realm name. |
| LogonSequenceNumber | Specifies an existing Logon Sequence Number (LSN) to associate this session with. |
| MaxMessageBody | Specifies the maximum Response Message size in bytes. |
| MaxRows | クエリで集計またはGROUP BY を使用しない場合に返される行数を制限します。これはLIMIT 句よりも優先されます。 |
| MaybeNull | Controls the behavior of the ResultSetMetaData.isNullable method. |
| Other | これらの隠しプロパティは特定のユースケースでのみ使用されます。 |
| Partition | Specifies the Teradata Database partition for the Connection. |
| PoolIdleTimeout | 接続が閉じられる前に許容されたアイドル時間。 |
| PoolMaxSize | プールの最大接続数。 |
| PoolMinSize | プール内の最小接続数。 |
| PoolWaitTime | 使用可能な接続を待機する最大秒数。 |
| PrepSupport | Specifies whether the Teradata Database performs a prepare operation when a PreparedStatement or CallableStatement is created. |
| QueryPassthrough | このオプションは、クエリをTeradata サーバーにas-is で渡します。 |
| Readonly | このプロパティを使用して、provider からTeradata へのアクセスを読み取り専用に設定できます。 |
| ReconnectCount | Enables Teradata Session Reconnect. Specifies the maximum number of times that the Teradata JDBC Driver will attempt to reconnect the session. |
| ReconnectInterval | Enables Teradata Session Reconnect. Specifies the number of seconds that the Teradata JDBC Driver will wait in between attempts to reconnect the session. |
| Redrive | Enables Teradata Session Reconnect, and also enables automatic redriving of SQL requests interrupted by database restart. |
| RTK | ライセンス供与で使用されるランタイムキー。 |
| RunStartup | Specify the value for RunStartup, ON or OFF. |
| Sessions | Specifies the number of FastLoad or FastExport connections to be created, where 1 <= number of FastLoad or FastExport connections <= number of AMPs. |
| SipSupport | Controls whether the Teradata Database and Teradata JDBC Driver use StatementInfo Parcel (SIP) to convey metadata. |
| SlobReceiveThreshold | Controls how small LOB values are received from the Teradata Database. Small LOB values are pre-fetched from the Teradata Database before the application explicitly reads data from Blob/Clob objects. |
| SlobTransmitThreshold | Controls how small LOB values are transmitted to the Teradata Database. |
| SpSpl | Specifies behavior for creating or replacing Teradata stored procedures. |
| SslCa | Specifies the file name of a PEM file that contains Certificate Authority (CA) certificates for use with SSLMODE=VERIFY-CA or VERIFY-FULL. |
| SslCaPath | Specifies a directory of PEM files that contain Certificate Authority (CA) certificates for use with SSLMODE=VERIFY-CA or VERIFY-FULL. |
| SslMode | Specifies the mode for connections to the database. |
| SslProtocol | Specifies the TLS protocol for HTTPS/TLS connections. |
| StrictEncode | Specifies behavior for encoding character data to transmit to the Teradata Database. |
| Tcp | Specifies one or more TCP socket settings, separated by plus signs ("+"). |
| Timeout | タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。 |
| TMode | Specifies the transaction mode for the connection. |
| TNano | Specifies the fractional seconds precision for all java.sql.Time values bound to a PreparedStatement or CallableStatement and transmitted to the Teradata Database as TIME or TIME WITH TIME ZONE values. |
| TrustedSql | Specify the value for TrustedSql. |
| TSNano | Specifies the fractional seconds precision for all java.sql.Timestamp values bound to a PreparedStatement or CallableStatement and transmitted to the Teradata Database as TIMESTAMP or TIMESTAMP WITH TIME ZONE values. |
| Type | Specifies the type of protocol to be used with the Teradata Database for SQL statements. |
| UpperCaseIdentifiers | This property reports all identifiers in uppercase. This is the default for Oracle databases and thus allows better integration with Oracle tools such as the Oracle Database Gateway. |
| UseConnectionPooling | このプロパティは、コネクションプーリングを有効にします。 |
| UseXViews | Specifies which Data Dictionary views should be queried to return result sets from DatabaseMetaData methods. |