CrNiCKL JDBC implementation

JDBC implementation of the CrNiCKL database manager for time series.

License	The Apache Software License, Version 2.0
GroupId	ch.agent
ArtifactId	crnickl-jdbc
Last Version	2.0.1
Release Date	Oct 6, 2017
Type	jar
Description	CrNiCKL JDBC implementation JDBC implementation of the CrNiCKL database manager for time series.
Project URL	http://agent.ch/timeseries/crnickl/
Source Code Management	https://github.com/jpvetterli/crnickl-jdbc.git

Download crnickl-jdbc

Filename	Size
crnickl-jdbc-2.0.1.pom
crnickl-jdbc-2.0.1.jar	69 KB
crnickl-jdbc-2.0.1-sources.jar	44 KB
crnickl-jdbc-2.0.1-javadoc.jar	120 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/ch.agent/crnickl-jdbc/ -->
<dependency>
    <groupId>ch.agent</groupId>
    <artifactId>crnickl-jdbc</artifactId>
    <version>2.0.1</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/ch.agent/crnickl-jdbc/
implementation 'ch.agent:crnickl-jdbc:2.0.1'

Gradle Kotlin

// https://jarcasting.com/artifacts/ch.agent/crnickl-jdbc/
implementation ("ch.agent:crnickl-jdbc:2.0.1")

Apache Buildr

'ch.agent:crnickl-jdbc:jar:2.0.1'

Apache Ivy

<dependency org="ch.agent" name="crnickl-jdbc" rev="2.0.1">
  <artifact name="crnickl-jdbc" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='ch.agent', module='crnickl-jdbc', version='2.0.1')
)

Scala SBT

libraryDependencies += "ch.agent" % "crnickl-jdbc" % "2.0.1"

Leiningen

[ch.agent/crnickl-jdbc "2.0.1"]

Dependencies

compile (1)

Group / Artifact	Type	Version
ch.agent : crnickl	jar	2.0.0

test (4)

Group / Artifact	Type	Version
junit : junit	jar	4.11
ch.agent : crnickl-test	jar	2.0.0
org.hsqldb : hsqldb	jar	2.2.8
org.hsqldb : sqltool	jar	2.2.8

Project Modules

There are no modules declared in this project.

crnickl-jdbc : JDBC Implementation of the CrNiCKL Database

Copyright 2012-2017 Hauser Olsson GmbH.

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

	http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.

---

This is a JDBC implementation of the CrNiCKL (chronicle) database. CrNiCKL (pronounced "chronicle") is a database for time series written in Java running on top of SQL and NoSQL systems.

Version 2.0.1

Versions 2.0.0 and 2.0.1 bring a non-compatible change in JDBCDatabase. The constructor now takes a second parameter: a ch.agent.t2.time.TimeDomainCatalog.

Distribution

The distribution consists of three archives

crnickl-jdbc-x.y.z.jar
crnickl-jdbc-x.y.z-javadoc.jar
crnickl-jdbc-x.y.z-sources.jar

with compiled classes, HTML documentation, and sources. The version number x.y.z follows the maven convention. The distribution also includes .asc files with detached cryptographic signatures.

For Maven users

The software is available from the [Maven central repository<] (http://repo.maven.apache.org/maven2/ch/agent/crnickl-jdbc/). To use version x.y.z, insert the following dependency into your pom.xml file:

<dependency>
  <groupId>ch.agent</groupId>
  <artifactId>crnickl-jdbc</artifactId>
  <version>x.y.z</version>
  <scope>compile</scope>
</dependency>

Building the software

The recommended way is to use git for accessing the source and maven for building. The procedure is easy, as maven takes care of locating and downloading dependencies:

$ git clone https://github.com/jpvetterli/crnickl-jdbc.git
$ cd crnickl-jdbc
$ mvn install

This builds and installs the distribution JARs in your local maven repository. They can also be found in the target directory.

When building the software by other means, the following dependencies must be addressed:

• crnickl-x.y.z.jar CrNiCKL database
• t2-x.y.z.jar Time2 Library

Replace all x.y.z with the actual version numbers which can be found in the POM file included in the binary JAR:

/META-INF/maven/ch.agent/crnickl-jdbc/pom.xml

Unit tests

The following command runs unit tests:

$ mvn -Dmaven.test.skip=false test

When building the software without maven, the following additional dependencies must be addressed to compile unit tests:

• hsqldb-<version>.jar HyperSQL Database
• sqltool-<version>.jar HyperSQL Database

Browsing the source code

The source is available on GitHub.

Finding more information

More information on CrNiCKL is available at the project web site.

Updated: 2017-10-06/jpv.

Versions

Version
2.0.1 Oct 6, 2017
2.0.0 Oct 5, 2017
1.1.4 May 1, 2013
1.1.3 Jan 22, 2013
1.1.2 Sep 8, 2012