Projects tagged ‘database’ 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]

This Perl module allow your program to process text files containing one or many commands that execute SQL statements sequentially following the procedure you define. Please keep in mind that ... [More] DBIx::Simple::Procedure is an alternative to database stored procedures and not a replacement or emulation of them. Essentially it is an interface to execute and return data from multiple queries. Here is an example of how to setup and process a (sql) text file. EXAMPLE: use DBIx::Simple::Procedure; my $db = DBIx::Simple::Procedure->new($path_to_sqlfiles, 'dbi:SQLite:dbname=file.dat'); $db->queue($sql_file)->process_queue(@sql_parameters); foreach my $result (@{$db->cache(0)}){ $result->{...}; } [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]