osgi-jdbc-example

Example Declarative Service using a JDBC DataSourceFactory

Testing out with Karaf

Install a properly OSGi-wrapped PostgreSQL database driver
Install the OSGi Enterprise bundle: install -s mvn:org.osgi/org.osgi.enterprise/4.2.0
Install the PostgreSQL DataSourceFactory implementation: install -s mvn:org.ops4j.pax.jdbc/pax-jdbc-postgresql
Install the SCR declarative services feature: features:install scr
Install this bundle
Create a config file for the service in the etc/ directory called ServiceWithDbAccess.cfg with properties
- dbname = The database name
- user = The database user
- password = The password for the user
- server = The database host
- port = The port the database is listening on
After the config file is created the service will automagically get activated by the service component runtime in karaf