Return-Path: Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org Received: (qmail 62782 invoked from network); 8 Sep 2004 18:21:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 8 Sep 2004 18:21:36 -0000 Received: (qmail 38503 invoked by uid 500); 8 Sep 2004 18:21:23 -0000 Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org Received: (qmail 38400 invoked by uid 500); 8 Sep 2004 18:21:21 -0000 Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "POI Users List" Reply-To: "POI Users List" Delivered-To: mailing list poi-user@jakarta.apache.org Received: (qmail 38253 invoked by uid 99); 8 Sep 2004 18:21:20 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from [69.28.209.52] (HELO muibros.com) (69.28.209.52) by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 08 Sep 2004 11:21:17 -0700 Received: from [127.0.0.1] (softdnserr [::ffff:127.0.0.1]) by muibros.com with esmtp; Wed, 08 Sep 2004 14:22:06 -0400 Message-ID: <413F4EB7.7010709@muibros.com> Date: Wed, 08 Sep 2004 14:25:59 -0400 From: Danny Mui User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: POI Users List Subject: Re: xls2jdbc & jdbc2xls References: <4135D0CD.16754.AD98BC@localhost> In-Reply-To: <4135D0CD.16754.AD98BC@localhost> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N 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