View source for 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:

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

== Usage ==

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

=== Reading the connection properties from the context ===

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

TBA