setup HQL so u can use that as an easy database to house the JDBC
backend for unit testing. HQL is an java-based inmemory db so it's easy :).
[EMAIL PROTECTED] wrote:
I wrote a set of classes for providing a command line interface to the po-i-werfull
Apache's POI work. The initial purpose was to load and save XLS files in batch
mode:
jdbc2xls -p properties -s sql_statement [-o outfile]
and,
xls2jdbc -p properties -f infile [-t table] [-c create]
Few month ago I already talk about this on this list but now the poi-tools have been
published.
You can download it a http://www.devaki.org/poi-tools/
Of course it's all under the Apache2 license.
I'm not publishing the CVS at the moment due to lack of ressources but it is still
under my only active development.
I haven't got any testcase cause I'm not sure the way it works when passing throught
jdbc (ex: how can it fit in the jakarta process?)
At the moment xls2jdbc only work with Postgresql but it can easily be extended to
other SQL syntax by using standard inheritance.
Please tell me, if you like to enhance it, or tell me if any advice.
Emmanuel Florent
eflorent [EMAIL PROTECTED] devaki.org
http://www.devaki.org/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
