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 "Christophe.Demarey" <Ch...@lifl.fr> on 2003/10/16 13:44:44 UTC

Tools to create database schema from 'repository.xml' ?

Hi,

I had a look in your test application but I don't find how to generate 
the database schema binding to the repository.xml file.

 From the repository.xml file, is it possible to :
1) generate a sql file to create tables in the database?
2) execute this sql file in the database to create the database schema? 
(I think it's possible with Torque).

For these two steps, shall I use Torque Tasks ?
In this case :
* What values must I assign to properties? I found no documentation 
about this (ex: basePathToDbProps, idTableXMLFile, sqldbmap, ...).
* What configuration files must I take into my application? What should 
be modified? What is really needed (I want to use a light OJB version: 
only jars and configuration files)?

I really need this information as it is a very important part for me.


Thanks.

-- 
Christophe Demarey,
Research engineer
OpenCCM project - http://www.objectweb.org/openccm
GOAL Team - CNRS/USTL/LIFL - http://www.lifl.fr/GOAL/
Universite des Sciences et Technologies de Lille
LIFL - UMR CNRS 8022- Batiment M3
59655 Villeneuve d'Ascq Cedex - FRANCE
Phone: +33 (0)32043 4728
Fax  : +33 (0)32043 6566


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


Re: Tools to create database schema from 'repository.xml' ?

Posted by Marcus Breese <ma...@breese.com>.
I actually use a combination of Torque and the ojb-doclet to create the 
database and the repository.xml file.  It also creates a skeleton 
object model.

Let me know if you're interested in my ant scripts and velocity 
templates...

On Thursday, October 16, 2003, at 06:44  AM, Christophe.Demarey wrote:

> Hi,
>
> I had a look in your test application but I don't find how to generate 
> the database schema binding to the repository.xml file.
>
> From the repository.xml file, is it possible to :
> 1) generate a sql file to create tables in the database?
> 2) execute this sql file in the database to create the database 
> schema? (I think it's possible with Torque).
>
> For these two steps, shall I use Torque Tasks ?
> In this case :
> * What values must I assign to properties? I found no documentation 
> about this (ex: basePathToDbProps, idTableXMLFile, sqldbmap, ...).
> * What configuration files must I take into my application? What 
> should be modified? What is really needed (I want to use a light OJB 
> version: only jars and configuration files)?
>
> I really need this information as it is a very important part for me.
>
>
> Thanks.
>
> -- 
> Christophe Demarey,
> Research engineer
> OpenCCM project - http://www.objectweb.org/openccm
> GOAL Team - CNRS/USTL/LIFL - http://www.lifl.fr/GOAL/
> Universite des Sciences et Technologies de Lille
> LIFL - UMR CNRS 8022- Batiment M3
> 59655 Villeneuve d'Ascq Cedex - FRANCE
> Phone: +33 (0)32043 4728
> Fax  : +33 (0)32043 6566
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>
-=-= -=-= -=-= -=-= -=-= -=-= -=-= -=-= -=-= -=-= -=-=-
Marcus Breese                            mbreese@iupui.edu
IU School of Medicine              marcus@breese.com
Dept. of Biochemistry and Molecular Biology
Center for Medical Genomics / Grow Lab



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