SPWrapper / News: Recent posts

Oracle RefCursor News

Hello, the new release increases the support for ref cursor with stored procedures introducing dyntable datatype.

DYNTABLE make it easyer to deal with these result set. You simply have to provide an overry rule in the ant makefile to turn a result set output into a dyntable output.

For each dyntable parameter this snippet is added to the generated source code

java.sql.ResultSet r_X_RIGHE_CONTAB=(narrowedStatement).getCursor(8);
if (r_X_RIGHE_CONTAB != null) {
ResultSetMetaData meta = r_X_RIGHE_CONTAB.getMetaData();
while (r_X_RIGHE_CONTAB.next()) {
HashMap<String, Object> row = new HashMap<String, Object>();
int colNo = meta.getColumnCount();
for (int i = 1; i <= colNo; i++) {
String name = meta.getColumnName(i);
row.put(name, r_X_RIGHE_CONTAB.getObject(i));
}
X_RIGHE_CONTAB.add(row);
}
}... read more

Posted by Giovanni 2008-08-19

SqlJaTor and Pgdb

SPWrapper is a source code generator whose input is a SQL statement, or with some limitations the name of a stored procedure.
Each SQL statement become a Java class, iterable to fetch results if the statement is a SELECT. With this release it is also possible to generate Python classes for the cx_Oracle and pgdb modules.
SPWrapper is designed to require little configuration: it tries to automatically guess input parameters form SQL code, and output parameters from the SQL result set fetched. All the SQL statements can be translated to source code, even those with proprietary syntax.
Currently support four databases for Java (Oracle, Postgresql, mysql and sqlserver) and Oracle/Postgresql with Python.

Posted by Giovanni 2008-03-23

Code generation also for Python

SPWrapper is a source code generator whose input is a SQL statement, or with some limitations the name of a stored procedure.
Each SQL statement become a Java class, iterable to fetch results if the statement is a SELECT. With this release it is also possible to generate Python classes for the cx_Oracle module.
SPWrapper is designed to require little configuration: it tries to automatically guess input parameters form SQL code, and output parameters from the SQL result set fetched. All the SQL statements can be translated to source code, even those with proprietary syntax.
Currently support four databases for Java (Oracle, Postgresql, mysql and sqlserver) and Oracle with Python.
enjoy!

Posted by Giovanni 2008-03-06

Create Java classes from SQL statements

The new release 0.6 of SPWrapper provides a new ant task called SqlJaTor. Given a sql statement, such as INSERT, SELECT etc, SqlJaTor is able to create parametrized java class for you.
Moreover this class is easily usable with JSTL tags.
For further information look at http://spwrapper.sourceforge.net/sqljator/SqlJaTor.html

Posted by Giovanni 2007-04-16

SPWrapper plugin for Netbeans 5.0

Now it is possible to create stored procedure wrappers quickly using a new file wizard. The new plugin creates also ant tasks to rebuild the wrappers.

Posted by Giovanni 2006-08-23

new release 0.5

In this release there are many changes to the core functionalities.
Now it is really easy to call the stored procedure: if null values or complex data types are not needed a simple function call is sufficient.
Support for stored procedure overloading has been completed, and made more comprensible.
Now it is possible to chose the class name for the wrapper.

enjoy

Giovanni

Posted by Giovanni 2006-04-26

SPWrapper release 0.4

This release add support to Reference cursor, Blob and Clob.

Posted by Giovanni 2006-04-05

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks