xls2jdbc & jdbc2xls

[ef...@formaguide.com]

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 nosp@m devaki.org
http://www.devaki.org/




---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org

Re: xls2jdbc & jdbc2xls

[Danny Mui <da...@muibros.com>]

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 :).




eflorent@formaguide.com 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 nosp@m devaki.org
> http://www.devaki.org/
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org