Iciql

a model-based database access wrapper for JDBC

License	Apache ASL
GroupId	com.gitblit.iciql
ArtifactId	iciql
Last Version	2.2.1
Release Date	May 3, 2021
Type	jar
Description	Iciql a model-based database access wrapper for JDBC
Project URL	http://iciql.com
Source Code Management	https://github.com/gitblit/iciql

Download iciql

Filename	Size
iciql-2.2.1.pom
iciql-2.2.1.jar	245 KB
iciql-2.2.1-sources.jar	143 KB
iciql-2.2.1-javadoc.jar	609 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/com.gitblit.iciql/iciql/ -->
<dependency>
    <groupId>com.gitblit.iciql</groupId>
    <artifactId>iciql</artifactId>
    <version>2.2.1</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/com.gitblit.iciql/iciql/
implementation 'com.gitblit.iciql:iciql:2.2.1'

Gradle Kotlin

// https://jarcasting.com/artifacts/com.gitblit.iciql/iciql/
implementation ("com.gitblit.iciql:iciql:2.2.1")

Apache Buildr

'com.gitblit.iciql:iciql:jar:2.2.1'

Apache Ivy

<dependency org="com.gitblit.iciql" name="iciql" rev="2.2.1">
  <artifact name="iciql" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='com.gitblit.iciql', module='iciql', version='2.2.1')
)

Scala SBT

libraryDependencies += "com.gitblit.iciql" % "iciql" % "2.2.1"

Leiningen

[com.gitblit.iciql/iciql "2.2.1"]

Dependencies

provided (15)

Group / Artifact	Type	Version
com.beust : jcommander	jar	1.17
com.h2database : h2	jar	1.4.193
org.hsqldb : hsqldb	jar	2.3.4
org.apache.derby : derby	jar	10.13.1.1
org.apache.derby : derbyclient	jar	10.13.1.1
org.apache.derby : derbynet	jar	10.13.1.1
mysql : mysql-connector-java	jar	8.0.16
org.postgresql : postgresql	jar	9.4.1212
org.xerial : sqlite-jdbc	jar	3.16.1
org.slf4j : slf4j-api	jar	1.7.20
commons-pool : commons-pool	jar	1.5.6
commons-dbcp : commons-dbcp	jar	1.4
com.google.code.gson : gson	jar	2.3
com.thoughtworks.xstream : xstream	jar	1.4.16
org.yaml : snakeyaml	jar	1.17

test (1)

Group / Artifact	Type	Version
junit : junit	jar	4.13.1

Project Modules

There are no modules declared in this project.

iciql

iciql is...

• a model-based, database access wrapper for JDBC
• for modest database schemas and basic statement generation
• for those who want to write code, instead of SQL, using IDE completion and compile-time type-safety
• small (<250KB with debug symbols) with no runtime dependencies
• pronounced icicle (although it could be French: ici ql - here query language)
• a friendly fork of the H2 JaQu project

iciql is not...

• a complete alternative to JDBC
• designed to compete with more powerful database query tools like jOOQ or QueryDSL
• designed to compete with enterprise ORM tools like Hibernate or mybatis

Supported Databases (Unit-Tested)

• H2 1.4
• HSQLDB 2.3
• Derby 10.12
• MySQL 5.6
• PostgreSQL 9.5
• SQLite 3.8

Support for others is possible and may only require creating a simple "dialect" class.

Downloading

As of 2.0.0 iciql is now distributed through Maven Central and it's coordinates have changed slightly.

<dependencies>
    <dependency>
        <groupId>com.gitblit.iciql</groupId>
        <artifactId>iciql</artifactId>
        <version>2.2.0</version>
    </dependency>
</dependencies>

Older releases are available from the Iciql Maven Repository.

License

iciql is distributed under the terms of the Apache Software Foundation license, version 2.0.
The text of the license is included in the file LICENSE in the root of the project.

Java Runtime Requirement

iciql requires a Java 6 Runtime Environment (JRE) or a Java 6 Development Kit (JDK).

Getting help

Read the online documentation available at the iciql website
Issues & source code @ GitHub

Building iciql

You may use Maven to build the project:

mvn clean package

You may use Maven to run the test suite on the default database:

mvn clean test

You may use Maven to run the test suite on all tested databases:

mvn clean test-compile exec:exec

Versions

Version
2.2.1 May 3, 2021
2.2.0 Feb 1, 2017
2.1.1 Apr 7, 2016
2.1.0 Apr 6, 2016
2.0.0 Apr 5, 2016