You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by MP <pe...@ngi.it> on 2006/05/03 12:41:58 UTC

SQL schema script for J2 & oracle

Hi all,
I downloaded the src version of jetspeed2 (M3) but I'm not able to find 
scritps which generate the schema in any directory,  apart 
portal/src/sql/hsql ones. Which schema is used by maven in order to 
build the database?

Thank you.
Maurizio

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


Re: SQL schema script for J2 & oracle

Posted by Martin Dulisch <md...@gmail.com>.
Hi,

jetspeed generates the schema for the diferent database systems by
torque. You first have to set the used database in your build
properties. This is also the parameter that controls the schema
generation.

There is a task in the maven build that only generates the schema. I
think maven db.scriptsgen. But I am not sure what the exact name is.
Try maven -u in the root jetspeed src folder.

Martin


2006/5/3, MP <pe...@ngi.it>:
> Ok,
> I've downloaded version 2.0.
> The schema now are under:  jetspeed-2.0-src\etc\sql\derby\schema
>
> May I use this in order to generate a schema under Oracle 9i?
> If yes, what about the order of script?
>
> I know that maven will install properly J2 on Oracle with right
> build.properties, but I've to try the schema before.
>
> Tnx a lot.
> Bye
> Maurizio
>
>
> Aaron Evans wrote:
> > I wouldn't use M3 if I were you. That is *really* old.  Either go with
> > 2.0 or 2.1-dev...
> >
> >
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>

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


Re: SQL schema script for J2 & oracle

Posted by MP <pe...@ngi.it>.
Ok,
I've downloaded version 2.0.
The schema now are under:  jetspeed-2.0-src\etc\sql\derby\schema

May I use this in order to generate a schema under Oracle 9i?
If yes, what about the order of script?

I know that maven will install properly J2 on Oracle with right 
build.properties, but I've to try the schema before.

Tnx a lot.
Bye
Maurizio


Aaron Evans wrote:
> I wouldn't use M3 if I were you. That is *really* old.  Either go with
> 2.0 or 2.1-dev...
>
>
>
>
>


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


Re: SQL schema script for J2 & oracle

Posted by Aaron Evans <aa...@gmail.com>.
I wouldn't use M3 if I were you. That is *really* old.  Either go with
2.0 or 2.1-dev...

On 5/3/06, MP <pe...@ngi.it> wrote:
> Hi all,
> I downloaded the src version of jetspeed2 (M3) but I'm not able to find
> scritps which generate the schema in any directory,  apart
> portal/src/sql/hsql ones. Which schema is used by maven in order to
> build the database?
>
> Thank you.
> Maurizio
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>

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