Connecting to a Database

Connection to various databases goes trough DatabaseConnectionManager class. In order to use it, you should add the following dependency to your project:

<dependency>
	<groupId>net.ccil</groupId>
	<artifactId>ccil-common-sql</artifactId>
	<version>${ccil.version}</version>
</dependency>

Usage

...
Connection cnn = db.getConnection();
PreparedStatement st = (PreparedStatement) cnn
       .prepareStatement("SELECT * FROM collections WHERE context = ?");
st.setString(1, name);
ResultSet rs = st.executeQuery();
...

Reading the connection properties from the context

First thing, you need a reference to the contexts service.

TBA