What is SPWrapper?
This project aims at developing a set of tools to generate source code to execute SQL statements and stored procedures.
Its majour features are:
Project componentsSPWrapper is currently composed of three parts:
This software is compiled with JDK 1.5, it is not possbile to compile it with previous java versions.
The stored procedure wrapper generator works with Oracle, and with less features also on Postgresql, Mysql and Sqlserver.
SqlJaTor currently works with four databases: Oracle, Postgresql, Mysql and SqlServer.
The generated Java classes can be used in Java applications, libraries or inside application servers. Special care has been taken to support Tomcat and Jboss connection pooling. If you use other servlet engines probably some extra care is needed for the JNDI related code.
Oracle is the first database supported. Specific code has been written to support stored procedure oveloading and Oracle specific datatypes.
The support for three other databases (Postgresql, Mysql and SqlServer) has just been introduced from release 0.7. Currently only type alias has been introduced, very specific types are not available.
Python support has been checked with version 2.5.
Add or modify database support
It is possible to allow SqlJaTor and SPWrapper to work with new databases writing some configuration files. If you are interested to work with a new database or to support a specific datatypes you could read the Add Database Support tutorial.
Don't forget to send us your contibution to make it available to everybody!
Planned next steps
There are a lot of things that can be done; these are those we plan to develop first: