felixklauke / prophecy

A little SQL connection pool capable of creating a datasource and improving your database access speed.

Prophecy

Prophecy is a simple java SQL Connection pool capable of having multiple connections to enhance database access speed by using more than one connection.

Build Status

	Build Status
Master
Development

Installation / Usage

• Install Maven
• Clone this repo
• Instal: mvn clean install

Maven repositories

<repositories>
    <!-- Klauke Enterprises Releases -->
    <repository>
        <id>klauke-enterprises-maven-releases</id>
        <name>Klauke Enterprises Maven Releases</name>
        <url>https://repository.klauke-enterprises.com/repository/maven-releases/</url>
    </repository>
	
    <!-- Klauke Enterprises Snapshots -->
    <repository>
        <id>klauke-enterprises-maven-snapshots</id>
        <name>Klauke Enterprises Maven Snapshots</name>
        <url>https://repository.klauke-enterprises.com/repository/maven-snapshots/</url>
    </repository>
</repositories>

Maven dependencies

Core:

<dependency>
    <groupId>de.felixklauke.prophecy</groupId>
    <artifactId>prophecy-core</artifactId>
    <version>1.0.0</version>
</dependency>

Example

Creation:

ProphecyConfig config = ProphecyConfig.newBuilder()
        .setDatabaseURL("{URL}")
        .setDatabaseUser("user")
        .setDatabaseUserPassword("password")
        .createProphecyConfig();
        
Prophecy prophecy = ProphecyFactory.createProphecy(config);

Plain old usage:

Connection connection = prophecy.getConnection();
        
// Do whatever you want, query, update...
        
prophecy.checkInConnection(connection);

Using AutoCloseable:

try (Connection connection = prophecy.getConnection()){
    // Do whatever you want
} catch (SQLException e) {
    e.printStackTrace();
}

We also support Datasources:

DataSource dataSource = prophecy.createDatasource();