Appendix I

Setting Additional Database Connection Properties #

JDBC Connection parameters can be added to configure different aspects of the connection to the database. Configuration properties are platform specific and not common across DB platforms. For some DB platforms, JDBC connection properties can be provided as part of the connection URL (configured with the <dataSource> tag in sics-database-sources.xml).

It is also possible - for all DB platforms - to configure JDBC connection properties on the command line and/or with the <additionalJdbcConnectionProperties> tag in sics-database-sources.xml, as described in the following text.

Command Line #

The command line parameter sics.JDBC.params can be used to configure JDBC connection properties. The value of the parameter must be a key/value pair of JDBC connection properties to be set. Multiple connection properties must be separated by a semi-colon ;.

Examples:

-Dsics.JDBC.params="defaultRowPrefetch=500"
-Dsics.JDBC.params="defaultRowPrefetch=500;anotherParam=true"

Please note that the example property defaultRowPrefetch is specific to Oracle databases.

sics-database-sources.xml #

Connection properties can be set using the element called <additionalJdbcConnectionProperties> as a sub-element to the <source> element. Again, the value of the element must be a key/value pair of JDBC connection parameters to be set. Multiple connection properties must be separated by a semi-colon ;.

Examples:

<source name="FOO">
  ...
<additionalJdbcConnectionProperties>
defaultRowPrefetch=500
</additionalJdbcConnectionProperties>
  ...
</source>

<source name="FOO">
  ...
<additionalJdbcConnectionProperties>
defaultRowPrefetch=500;anotherParam=true
</additionalJdbcConnectionProperties>
  ...
</source>

Configuration Priority #

Connection properties given on the command line take precedence over same-named properties defined with the <additionalJdbcConnectionProperties> element in the sics-database-sources.xml file.

If connection properties are defined on the <dataSource> connection string in the sics-database-sources.xml file, and in either the command line or the <additionalJdbcConnectionProperties> element in the sics-database-sources.xml, then the behaviour is undefined. This type of configuration is not recommended and is not supported.