Page History
...
Configuring a JDBC datasource
Configuring a JDBC datasource named datasource_name must be done by setting the following mandatory properties:
...
Info | ||
---|---|---|
| ||
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 | ||
---|---|---|
| ||
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 | ||
---|---|---|
| ||
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.