skip to main content
About the Driver : Using the Driver : Using Connection Properties : Additional Properties
  
Additional Properties
The following table summarizes additional connection properties.
Table 12. Additional Properties
Property
Characteristic
Determines the mechanism that is used to execute batch operations.
Determines which type of metadata information is included in result sets when an application calls DatabaseMetaData methods.
Specifies the name of the database to which you want to connect.
Specifies one or multiple SQL commands to be executed by the driver after it has established the connection to the database and has performed all initialization for the connection. If the execution of a SQL command fails, the connection attempt also fails and the driver throws an exception indicating which SQL command or commands failed.
Determines the amount of memory used by the driver to cache insensitive result set data.
Determines whether the driver returns table name information in the ResultSet metadata for Select statements.
Enables DataDirect Spy to log detailed information about calls issued by the driver on behalf of the application. DataDirect Spy is not enabled by default.
Enables support for catalogs. While Amazon Redshift has the notion of catalogs (or databases), you can only select from tables that reside within the catalog you specified at connect time. Catalogs cannot be changed after connecting. Therefore, most applications behave better if you do not indicate support for catalogs.
Determines how the driver handles errors that occur within a transaction. When an error occurs in a transaction, the Amazon Redshift server does not allow any operations on the connection except for rolling back the transaction. If set to none, the driver does not roll back the transaction when an error occurs. If set to RollbackTransaction, the driver rolls back the transaction when an error occurs.

See also

*Connection Property Descriptions