Projects tagged ‘java’ and ‘storedprocedure’

JProcedure is a generic engine written completely in Java (1.5) for invoking stored procedures on variety of database platforms (Oracle, PostreSQL, MySQL, etc). It uses java annotations to describe ... [More] information necessary for a proper stored procedure call and lets you define whether the results should be cached or not. It also allows you to inject custom written interceptors to add specific logic to procedure invocation (you may find interceptors useful for logging or performance measuring purposes) [Less]

jdbc-proc provides mappings from POJOs to stored procedures arguments. Main features: uses mapping specification of JPA with annotations: Entity, Column, OneToOne, ManyToOne, OneToMany ... [More] , JoinColumn creates stored procedures mapping code on the fly integrated with spring framework For step-by-step instructions, see Getting Started guide [Less]

External Language Stored Procedures for MySQL is a patch for MySQL to provide support for stored procedures written in an external languages. Stored procedures are declared in SQL using SQL standards ... [More] compliant syntax. Additional stored procedure languages are implemented as plug-ins to be installed at run time into the server. Currently, plugins for Java and Perl are implemented, as well as support for declaring XML-RPC requests as stored procedures. [Less]

A Sybase ASE 12.x SQL Parser & Object ModelAboutA Java 1.5 library for parsing Sybase ASE 12.x T-SQL queries and stored procedures into an object model. FeaturesFree & open source (available under ... [More] the LGPL licence) Parses a 'popular subset' of Sybase ASE 12.x T-SQL syntax Provides an extensive Java object model to inspect, analyse and manipluate Sybase syntax Object model is intuitive and easy to use (hand crafted, not auto generated from BNF) Provides a text renderer and an XML renderer (not yet available) Supports stored procedures as well as standalone SQL queries Pure Java (1.5) library (available as a jar) with no dependancies on external libraries Small library (~200KB), 97 classes, ~11,000 TLOC StatusThis project is currently in alpha status, meaning it is not yet feature complete and is not yet stable enough for use in a production environment. The parser and model are both fairly complete and should be able to cope with most queries and stored procedures. It has been validated against a set of over 1000 real stored procedures. VersionThe latest version available is 0.5.1.121 (alpha) which can be downloaded from this site. JavadocThe javadoc for the current release can be found at http://www.fairbait.com/sybaseparser_0.5.0.115_alpha/javadoc/ [Less]