...
This package uses the configuration PID org.clazzes.jdbc.provider and may be configured with keys using the following patternpatterns:
Key | Description | |
|---|---|---|
datasource.<datasourcename>.url | JDBC URL | |
datasource.<datasourcename>.user | JDBC User | |
datasource.<datasourcename>.password | JDBC Password | |
datasource.<datasourcename>.validationQuery | Validation query, executed to ensure the application receives a valid connectiondatasource.<datasourcename>.maxActive | Optional |
For more supported key patterns take a look at the JavaDoc of the org.clazzes.util.jdbc.provider.JdbcProvider class.
Typical JDBC URLs and validation queries can be found in our JDBC Snippets.
Configuration example
Sample configuration file
/etc/apache-karaf/org.clazzes.jdbc.provider.cfg:
| No Format |
|---|
datasource.JPTEST.url = jdbc:mysql://localhost/JPTEST datasource.JPTEST.username = jptest datasource.JPTEST.password = jptest321 datasource.JPTEST.validationQuery = SELECT 1 datasource.SPECTRUM.url = jdbc:oracle:thin:@10.1.2.3:1521:XE datasource.SPECTRUM.maxActive = 8 datasource.SPECTRUM.username = FOO datasource.SPECTRUM.password = bar datasource.SPECTRUM.validationQuery = select SYSDATE from DUAL |
...
Developer Snippets
pom.xml Snippets
It's important for the maven-bundle-plugin to import the Package javax.sql:
...