You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Huy Do <hu...@tramada.com> on 2001/08/08 07:06:13 UTC

newbie sql2xml ant task question

Hi all,

Just trying to use the sql2xml ant task. Is it working ?
I saw a posting in the archive which said it is not really
working. Is this true ?

Is there any other way of converting an existing database schema
(postgresql) into an xml schema so I can use torque.

Many thanks

Huy


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

RE: newbie sql2xml ant task question

Posted by Huy Do <hu...@tramada.com>.
I was using the schema dump from pg_dump -s.

CREATE TABLE bkn_contact_comments (
    key1 character varying(12) NOT NULL,
    key2 character varying(12) NOT NULL,
    description character varying(60),
    contact_comm_desc text,
    Constraint bkn_contact_comments_pkey Primary Key (key1, key2));

sql2xml doesn't seem to like the line     

Constraint bkn_contact_comments_pkey Primary Key (key1, key2)

It loops indefinitely. It works fine if i just use Primary Key (key1, key2)

Thanks

Huy


> -----Original Message-----
> From: Leon Messerschmidt [mailto:leon@opticode.co.za]
> Sent: Wednesday, 8 August 2001 5:54 PM
> To: turbine-user@jakarta.apache.org
> Subject: Re: newbie sql2xml ant task question
> 
> 
> Hi Huy,
> 
> It is working for me.  If you have problems I could help fix them.
> 
> ~ Leon
> 
> ----- Original Message ----- 
> From: "Huy Do" <hu...@tramada.com>
> To: <tu...@jakarta.apache.org>
> Sent: Wednesday, August 08, 2001 7:06 AM
> Subject: newbie sql2xml ant task question
> 
> 
> > Hi all,
> > 
> > Just trying to use the sql2xml ant task. Is it working ?
> > I saw a posting in the archive which said it is not really
> > working. Is this true ?
> > 
> > Is there any other way of converting an existing database schema
> > (postgresql) into an xml schema so I can use torque.
> > 
> > Many thanks
> > 
> > Huy
> > 
> > 
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: turbine-user-help@jakarta.apache.org
> > 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
> 
> 

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

Re: newbie sql2xml ant task question

Posted by Leon Messerschmidt <le...@opticode.co.za>.
Hi Huy,

It is working for me.  If you have problems I could help fix them.

~ Leon

----- Original Message ----- 
From: "Huy Do" <hu...@tramada.com>
To: <tu...@jakarta.apache.org>
Sent: Wednesday, August 08, 2001 7:06 AM
Subject: newbie sql2xml ant task question


> Hi all,
> 
> Just trying to use the sql2xml ant task. Is it working ?
> I saw a posting in the archive which said it is not really
> working. Is this true ?
> 
> Is there any other way of converting an existing database schema
> (postgresql) into an xml schema so I can use torque.
> 
> Many thanks
> 
> Huy
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
> 


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