db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jun Li" <allanju...@gmail.com>
Subject Re: Is there a way to get schema and catalog into the XML file?
Date Mon, 24 Jul 2006 01:20:31 GMT
Sure you can.

Just need to add two more mappings:
 <attribute name="catalog" property="catalog"/>

<attribute name="schema" property="schema"/>
Edit mapping.xml to include the above lines under

<class name="org.apache.ddlutils.model.Table">

On 7/23/06, Ray Malanga <ray@purejavasolutions.com> wrote:
>
> Hi.  I'm having a problem similar to the recent post by
> "Ajay.Bh...@us.hsbc.com".
>
> Is there a way to get DDLUtils to include the schema and catalog of a
> table in the XML file?
> For example, the XML generated by DDLUtils for my database may currently
> look like this:
>
> <database name="SomeDatabase">
>    <table name="SomeTable">
> ...
>    </table>
> </database>
>
> What I really need is this:
>
> <database name="SomeDatabase">
>    <table name="SomeTable" catalog="SomeCatalog" schema="SomeSchema">
> ...
>    </table>
> </database>
>
> Perhaps it may help if I give a little background about my situation...
> I use the DDLUtils ant task to dump each database required by my web
> app.  I few XSLT and Velocity transformations later I have a completely
> functional data access layer written in Java that I didn't have to write
> :).  Now I have the problem where two different catalogs have a table
> with the same name (but not the same structure) and I'd like to modify
> my templates to carry the catalog and schema name along but I'd need
> DDLUtils output to have it in there first.
>
>
> ty,
>
> - Ray M
>



-- 
--------------
Cheers,
Jun

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message