Return-Path: 
 <commons-user-return-6835-apmail-jakarta-commons-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-commons-user-archive@www.apache.org
Received: (qmail 68584 invoked from network); 6 Mar 2004 04:19:07 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 6 Mar 2004 04:19:07 -0000
Received: (qmail 92527 invoked by uid 500); 6 Mar 2004 04:18:43 -0000
Delivered-To: apmail-jakarta-commons-user-archive@jakarta.apache.org
Received: (qmail 92506 invoked by uid 500); 6 Mar 2004 04:18:42 -0000
Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:commons-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:commons-user-subscribe@jakarta.apache.org>
List-Help: <mailto:commons-user-help@jakarta.apache.org>
List-Post: <mailto:commons-user@jakarta.apache.org>
List-Id: "Jakarta Commons Users List" <commons-user.jakarta.apache.org>
Reply-To: "Jakarta Commons Users List" <commons-user@jakarta.apache.org>
Delivered-To: mailing list commons-user@jakarta.apache.org
Received: (qmail 92492 invoked from network); 6 Mar 2004 04:18:42 -0000
Received: from unknown (HELO swan.mail.pas.earthlink.net) (207.217.120.123)
  by daedalus.apache.org with SMTP; 6 Mar 2004 04:18:42 -0000
Received: from h-66-167-162-128.sndacagl.dynamic.covad.net ([66.167.162.128]
 helo=sephiroth.localdomain)
	by swan.mail.pas.earthlink.net with esmtp (Exim 3.33 #1)
	id 1AzTH2-0007em-00
	for commons-user@jakarta.apache.org; Fri, 05 Mar 2004 20:18:52 -0800
Received: from apache.org (localhost [127.0.0.1])
	by sephiroth.localdomain (8.12.10/8.12.10/SuSE Linux 0.7) with ESMTP id
 i264L8Bc017116
	for <commons-user@jakarta.apache.org>; Fri, 5 Mar 2004 20:21:09 -0800
Message-ID: <404951B4.6030700@apache.org>
Date: Fri, 05 Mar 2004 20:21:08 -0800
From: "matthew.hawthorne" <matth@apache.org>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
 rv:1.6b) Gecko/20031205 Thunderbird/0.4
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Jakarta Commons Users List <commons-user@jakarta.apache.org>
Subject: Re: [SQL]Jdbc to Schema AntTasks
References: <1078524286.3908.15.camel@trout>
In-Reply-To: <1078524286.3908.15.camel@trout>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

John E. Conlon wrote:
> I am trying to generate a XML database schema from JDBC metadata. See
> the JDBCTransformTask and the JdbcToSchemaTask in
> org.apache.commons.sql.task package but don't know which one to use or
> the syntax.
> 
> Have tried experimenting with variation against a hsqldb 1.7.2. but my
> builds hang.
> 
> Has anyone an example of either of these tasks?

I've never used this task, but after looking at the JavaDocs for
org.apache.commons.sql.task.JdbcToSchemaTask, and examining
the field names, I'd imagine that it would be used like this:

<jdbc2schema dbDriver="" dbUrl="" dbPassword="" dbUser=""
	dbCatalog="" dbSchema="" outputFile=""/>

with your values filled in accordingly.

If this doesn't help, take a look at the source code, it may help with 
debugging.

Let me know how things go.

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