Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Configuring a JDBC datasource

Configuring a JDBC datasource named datasource_name must be done by setting the following mandatory properties:

...

Info
titleDisclaimer

The descriptions above and the default values are taken from http://commons.apache.org/proper/commons-dbcp/configuration.htmlApache Commons DBCP website.

Info

Not setting a connection pool optional parameter results in a DEBUG message in the log in the form: SqlConnectionData datasource_name has no poolMaxTotal property set explicitly. Default value 8 will be used.

Setting a connection poolparameterto an invalid value will result in a WARNING message in the log in the form: SqlConnectionData datasource_name was initialized with poolMaxTotal=eight, but it is not a valid number. Default value 8 will be used.

...

Configuring a ODBC datasource

Configuring an ODBC datasource named datasource_name must be done by setting the following mandatory properties:

Code Block
languagejava
connection.datasource_name.sql.type=odbc
connection.datasource_name.sql.database=
connection.datasource_name.sql.username=
connection.datasource_name.sql.password=

Configuring a JNDI datasource

Configuring an ODBC datasource named datasource_name must be done by setting the following mandatory properties:

Code Block
languagejava
connection.datasource_name.sql.type=jndi
connection.datasource_name.sql.jndi=jndi_resource_name

Creating a JNDI datasource is container-specific. Please consult the documentation of the application server on how to create a JNDI datasource.

Using the development plugin