SqlDataLoader

Hello,

Please find as attachement a very simple SqlDataLoader. All the 
configuration still need to be written. I've used it for a simple use, 
by hardcoding the config data (hugly, but I was in hury).

If it can benefit for anyone, and if somebody feel to write the 
configuration code, it would be nice 

This code is totaly free of any right, you could use it as you want.

To use it, you just need to write
<#assign database = pp.loadData('SqlDataLoader') >

and then,
${database.tableName} is a list with all rows of table "tableName"

so you could write :
<#list database.tableName as row>
${row.fieldName}
</#list>

to retrieve your data.

Carl

import java.sql.Connection;
import java.sql.DriverManager;

FMPP 0.9.8 is released

FMPP 0.9.8 is released.

Download:
http://prdownloads.sourceforge.net/fmpp/fmpp_0.9.8.tar.gz

New features, improvements:

* FreeMarker 2.3.2mod (a stable nightly build after 2.3.2) is included.

* FMPP was updated to enable the new output encoding and URL escaping
  related features of FreeMarker 2.3.1. (The usage of 2.3.2mod is
  recommended because of a bugfix.)

* New setting: urlEscapingCharset

* Java API: added static final fields to Engine for reserved engine
  parameter (setting) value strings: PARAMETER_VALUE_SOURCE,
  PARAMETER_VALUE_HOST, PARAMETER_VALUE_OUTPUT. Also added the similar
  missing static fields to the Settings class.

Bugfixes:

* The reserved "host" output encoding value was not resolved in some
  rare cases.

* The pp.urlEnc/pp.urlPathEnc functions and the
  fmpp.util.StringUtil.urlEnc(...)/urlPathEnc(...) methods were
  malfunctioned with a few charsets, for example with UTF-16, UTF-7, and
  EBCDIC based charsets.