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