sqlex-mapper

Map java.sql.SQLException to more a meaningful exceptions hierarchy

License	Apache License, Version 2.0
Categories	Net
GroupId	net.bzdyl
ArtifactId	sqlex-mapper
Last Version	0.1.1
Release Date	Jan 29, 2016
Type	jar
Description	sqlex-mapper Map java.sql.SQLException to more a meaningful exceptions hierarchy
Project URL	https://github.com/pbzdyl/sqlex-mapper
Source Code Management	https://github.com/pbzdyl/sqlex-mapper

Download sqlex-mapper

Filename	Size
sqlex-mapper-0.1.1.pom
sqlex-mapper-0.1.1.jar	28 KB
sqlex-mapper-0.1.1-sources.jar	15 KB
sqlex-mapper-0.1.1-javadoc.jar	170 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/net.bzdyl/sqlex-mapper/ -->
<dependency>
    <groupId>net.bzdyl</groupId>
    <artifactId>sqlex-mapper</artifactId>
    <version>0.1.1</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/net.bzdyl/sqlex-mapper/
implementation 'net.bzdyl:sqlex-mapper:0.1.1'

Gradle Kotlin

// https://jarcasting.com/artifacts/net.bzdyl/sqlex-mapper/
implementation ("net.bzdyl:sqlex-mapper:0.1.1")

Apache Buildr

'net.bzdyl:sqlex-mapper:jar:0.1.1'

Apache Ivy

<dependency org="net.bzdyl" name="sqlex-mapper" rev="0.1.1">
  <artifact name="sqlex-mapper" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='net.bzdyl', module='sqlex-mapper', version='0.1.1')
)

Scala SBT

libraryDependencies += "net.bzdyl" % "sqlex-mapper" % "0.1.1"

Leiningen

[net.bzdyl/sqlex-mapper "0.1.1"]

Dependencies

test (2)

Group / Artifact	Type	Version
junit : junit	jar	4.12
org.assertj : assertj-core	jar	3.3.0

Project Modules

There are no modules declared in this project.

sqlex-mapper

Map java.sql.SQLException to a more meaningful exceptions hierarchy

Exception handling in JDBC is not easy. It provides base java.sql.SQLException with getSQLState and getErrorCode information but it's vendor specific and cumbersome to use. Yes, JDBC 4 (since Java 6) provides some improvements (additional exception hierarchy including classes like java.sql.SQLIntegrityConstraintViolationException etc.). Unfortunately not all SQL vendors catched up with those improvements (e.g. PostgreSQL still uses a single class for all kinds of errors).

This projects borrows the idea and code from Spring Framework. It provides simplified version of SQLExceptionTranslator - SqlExceptionMapper.

The default implementation of SqlExceptionMapper provides translation similar to SQLErrorCodeSQLExceptionTranslator and uses the same error codes mapping.

This is a very early version and API can still change.

Credits

Big 'thank you' goes to Spring Framework team for their implementation.

License

This project is released under version 2.0 of the [Apache License][].

Versions

Version
0.1.1 Jan 29, 2016
0.1.0 Jan 29, 2016