Mirage 1.0.3 Released

Mirage 1.0.3 is now available!

Mirage is a simple SQL centric database access library. See the following URL to know about Mirage:

• http://amateras.sourceforge.jp/site/mirage/welcome.html

Here is the list of changes in this release:

• Iteration search per a record using cursor.
• Stored procedure / function support.
• BugFix about SqlManager#insertEntity().

Please see also my past entries about new features in Mirage 1.0.3.

• Mirage supports stored procedure/functions
• Large results processing in Mirage

I wish that Mirage helps your development. Enjoy!

Mirage supports stored procedure/function

The next version of Mirage will support stored procedure/function. We added new methods to call them to SqlManager in the SVN trunk.

Here is an example to call stored function in Mirage:

// Creates parameter object which give to stored function
GetCountParam param = new GetCountParam();
param.deptId = 1;
...
// Calls a stored function and get a result value.
Long count = sqlManager.call(Long.class, "get_emp_count", param);

Fields of the parameter class has annotation such as @In, @Out, @InOut and @ResultSet. These annotations mean parameter type.

If the function returns ResultSet, use SqlManager#callForList() instead of SqlManager#call().

Please wait for the next release of Mirage!