You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Hale India <ha...@yahoo.com> on 2005/09/26 20:53:47 UTC
Turbine XML format
Hi
I am using Ojb from some time and would like to find
out Turbine XML format definition.
I have been looking at Turbine site, torque site etc.
I am trying to get it because I would like to create
our database using ddlutils and I would like to find
if it is possible to use COMMENT and or REMARK in
database.
When I create XML from our database, by now Comment on
our columns are lost and Index also. (Not primary Keys
nor Foreign Keys but Index).
Any help welcome
Andre
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: Torque, Turbine XML format
Posted by Hale India <ha...@yahoo.com>.
Hi Thomas
Thank's for your answer, I will check it and give you
elements if I succeed.
Cheers
Andre
--- Thomas Dudziak <to...@gmail.com> wrote:
> On 10/16/05, Hale India <ha...@yahoo.com>
> wrote:
>
> > I am looking to know if unique constraints are
> managed
> > when reverse ingeneering from database using Jdbc.
> >
> > In torque dtd unique and unique-column tags exists
> so
> > table creation is made using them, but what's
> happen
> > is we generate torque from a database (using
> ddlutils
> > for example).
>
> I'm not sure if DdlUtils is able to read them back
> yet. But you could
> check for yourself, and if not, then please open an
> issue with
> DdlUtils' JIRA.
>
> Tom
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail:
> ojb-user-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: Torque, Turbine XML format
Posted by Thomas Dudziak <to...@gmail.com>.
On 10/16/05, Hale India <ha...@yahoo.com> wrote:
> I am looking to know if unique constraints are managed
> when reverse ingeneering from database using Jdbc.
>
> In torque dtd unique and unique-column tags exists so
> table creation is made using them, but what's happen
> is we generate torque from a database (using ddlutils
> for example).
I'm not sure if DdlUtils is able to read them back yet. But you could
check for yourself, and if not, then please open an issue with
DdlUtils' JIRA.
Tom
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Torque, Turbine XML format
Posted by Hale India <ha...@yahoo.com>.
Hi
I am looking to know if unique constraints are managed
when reverse ingeneering from database using Jdbc.
In torque dtd unique and unique-column tags exists so
table creation is made using them, but what's happen
is we generate torque from a database (using ddlutils
for example).
Any help welcome.
Andre
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: Turbine XML format
Posted by Thomas Dudziak <to...@gmail.com>.
On 9/27/05, Hale India <ha...@yahoo.com> wrote:
> I will try for Jira, but I don't know how to use
> it....
It's not difficult, simply go to
http://issues.apache.org/jira/
there register for a new account for you (the account is for all
Apache projects that use JIRA as their bugtracking system, eg. OJB and
DdlUtils). After that, login and select "Create new issue" and then
enter the feature request or bug report details.
Tom
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: Turbine XML format
Posted by Hale India <ha...@yahoo.com>.
Hi Thomas
I will try for Jira, but I don't know how to use
it....
Have nice time
Andre
--- Thomas Dudziak <to...@gmail.com> wrote:
> On 9/26/05, Hale India <ha...@yahoo.com> wrote:
>
> > index tag and unique tag exists in both dtd but I
> > found no index element nor unique element created
> when
> > I have generated XML from our database using
> > DatabaseIO().write
>
> You could add a bug to DdlUtils' JIRA. If possible
> please use the
> DumpMetadataTask on the database in question like
> so:
>
> <taskdef name="dumpMetadata"
>
>
classname="org.apache.ddlutils.task.DumpMetadataTask">
> <classpath refid="runtime-classpath"/>
> </taskdef>
>
> <dumpMetadata outputFile="metadata.xml">
> <database
> url="jdbc:postgresql://localhost/visite"
>
> driverClassName="org.postgresql.Driver"
> username="superuser"
> password="secretPassword"/>
> </dumpMetadata>
>
> and attach the output (basically a complete dump of
> the metadata as
> returned by the jdbc driver).
>
> > In fact I just add this in our eclipse db plugin.
> > It generate XML from database and create database
> from
> > XML using ddlutils. (it create also mapping and
> > objects for Ojb).
> >
> > I hope that we will publish this new release soon.
> So
> > any help welcome.
>
> Cool! I'm just in the process of finalizing the 1.0
> release of
> DdlUtils, by creaing unit tests and updating the
> doc.
>
> Tom
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail:
> ojb-user-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: Turbine XML format
Posted by Thomas Dudziak <to...@gmail.com>.
On 9/26/05, Hale India <ha...@yahoo.com> wrote:
> index tag and unique tag exists in both dtd but I
> found no index element nor unique element created when
> I have generated XML from our database using
> DatabaseIO().write
You could add a bug to DdlUtils' JIRA. If possible please use the
DumpMetadataTask on the database in question like so:
<taskdef name="dumpMetadata"
classname="org.apache.ddlutils.task.DumpMetadataTask">
<classpath refid="runtime-classpath"/>
</taskdef>
<dumpMetadata outputFile="metadata.xml">
<database url="jdbc:postgresql://localhost/visite"
driverClassName="org.postgresql.Driver"
username="superuser"
password="secretPassword"/>
</dumpMetadata>
and attach the output (basically a complete dump of the metadata as
returned by the jdbc driver).
> In fact I just add this in our eclipse db plugin.
> It generate XML from database and create database from
> XML using ddlutils. (it create also mapping and
> objects for Ojb).
>
> I hope that we will publish this new release soon. So
> any help welcome.
Cool! I'm just in the process of finalizing the 1.0 release of
DdlUtils, by creaing unit tests and updating the doc.
Tom
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: Turbine XML format
Posted by Hale India <ha...@yahoo.com>.
Hi Thomas
Thank you for the dtd links.
It help me a lot.
index tag and unique tag exists in both dtd but I
found no index element nor unique element created when
I have generated XML from our database using
DatabaseIO().write
In fact I just add this in our eclipse db plugin.
It generate XML from database and create database from
XML using ddlutils. (it create also mapping and
objects for Ojb).
I hope that we will publish this new release soon. So
any help welcome.
Andre
--- Thomas Dudziak <to...@gmail.com> wrote:
> On 9/26/05, Hale India <ha...@yahoo.com> wrote:
>
> > I am using Ojb from some time and would like to
> find
> > out Turbine XML format definition.
> >
> > I have been looking at Turbine site, torque site
> etc.
>
> You can find the DTDs here:
>
> http://db.apache.org/torque/dtd/
>
> the DTD currently used by DdlUtils would be the 3.1
> version:
>
> http://db.apache.org/torque/dtd/database_3_1.dtd
>
> (not that there are much differences to the 3.2
> version)
>
> > I am trying to get it because I would like to
> create
> > our database using ddlutils and I would like to
> find
> > if it is possible to use COMMENT and or REMARK in
> > database.
>
> Interesting, I didn't know this is possible. How
> about you create a
> feature request for DdlUtils and I add (for
> databases that support
> this) the corresponding COMMENT statements ?
>
> > When I create XML from our database, by now
> Comment on
> > our columns are lost and Index also. (Not primary
> Keys
> > nor Foreign Keys but Index).
>
> The comments are retained where the DTD allows to
> (description
> attributes). But you're right, for foreign keys and
> indices there is
> no description attribute. You could ask the Torque
> guys for whether
> they could add this attribute.
>
> Tom
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail:
> ojb-user-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: Turbine XML format
Posted by Thomas Dudziak <to...@gmail.com>.
On 9/26/05, Hale India <ha...@yahoo.com> wrote:
> I am using Ojb from some time and would like to find
> out Turbine XML format definition.
>
> I have been looking at Turbine site, torque site etc.
You can find the DTDs here:
http://db.apache.org/torque/dtd/
the DTD currently used by DdlUtils would be the 3.1 version:
http://db.apache.org/torque/dtd/database_3_1.dtd
(not that there are much differences to the 3.2 version)
> I am trying to get it because I would like to create
> our database using ddlutils and I would like to find
> if it is possible to use COMMENT and or REMARK in
> database.
Interesting, I didn't know this is possible. How about you create a
feature request for DdlUtils and I add (for databases that support
this) the corresponding COMMENT statements ?
> When I create XML from our database, by now Comment on
> our columns are lost and Index also. (Not primary Keys
> nor Foreign Keys but Index).
The comments are retained where the DTD allows to (description
attributes). But you're right, for foreign keys and indices there is
no description attribute. You could ask the Torque guys for whether
they could add this attribute.
Tom
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org