...
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>.userusername | JDBC User |
datasource.<datasourcename>.password | JDBC Password |
datasource.<datasourcename>.validationQuery | Validation query, executed to ensure the application receives a valid connection |
| datasource.<datasourcename>.maxActive | Optional |
For more supported key patterns take a look at the JavaDoc of the org.clazzes.util.jdbc.provider.JdbcProvider classFull list of JDBC Provider Configuration Keys.
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:
...