jdbc-proc provides mappings from POJOs to stored procedures.

10 seconds introduction

Mapping a stored procedure to Java DAO:

public interface CompanyDao {

    @AStoredProcedure( name = "create_company")
    void createCompany(Company aCompany);

}

Read more about this example

Main features

• uses mapping specification of JPA with annotations: Entity, Column, OneToOne, ManyToOne, OneToMany, JoinColumn
• creates stored procedures mapping code on the fly
• integrated with spring framework and Google Guice

For step-by-step instructions, see Getting Started guide

Supported databases

• MySQL ≥ 5.0
• MariaDB ≥ 10.0
• PostgreSQL
• Microsoft SQL Server

Gratitudes

Many thanks to JProfiler

Changelog

2022 Nov 25 Added possibility to serialize List input parameters as json string

2015 Sep 02 Migrated to github

2013 May 13 Added patched mysql jdbc driver with improved performance mysql-connector-java-5.1.22-3-bin.jar

2011 Nov 02 new version 1.1.1 released. Main feature: added postgresql support

2011 Nov 01 migrated from svn to git

2010 May 05 jdbc-proc artifacts are deployed on the Central Repository. Thanks Sonatype!

They already use jdbc-proc Framework in production environments:

• Payneteasy https://payneteasy.com
• Leads Protection System https://lp.systems
• Superfly SSO https://github.com/payneteasy/superfly
• Srvlog Logs Collector https://github.com/payneteasy/srvlog