[smartweb-user] Re : Re : Re : Dev Environment Setup

[Sébastien LE C. <sl...@ya...>]

What I meant by "creating the schema" was: creating the tables, setting up the constraints and indexes, executing the grants, etc.

 
Regards,
Sébastien.



----- Message d'origine ----
De : Stefano V <st...@gm...>
À : Smartweb framework users discussions <sma...@li...>
Envoyé le : Mardi, 29 Avril 2008, 10h20mn 51s
Objet : Re: [smartweb-user] Re : Re : Dev Environment Setup

I mean that maven ( with hibernate plugin ) can generate sql scripts,  but this script are without the sql "create schema" instrunction inside them...
just yesterday i committed a new pom version on svn repository. Now smartweb-auth module can generate 3 example schema for 3 different db ( hsqldb postgresql mysql ) . As soon  as i'll do a new release

bye
Stefano Vetrini


2008/4/26 Roberto Lo Giacco <rlo...@sm...>:

Just to clarify the two answers:

if with the term "schema" you mean the database DDL the mvn
process-classes will do the trick, but you have to change the dialect
to match the correct database

if with "schema" you mean the database schema, the preceeding
procedure will generate only TABLE, SEQUENCE, CONSTRAINTS, etc...
definitions but will not create the SCHEMA itself: you should create
an AUTH schema by yourself.


2008/4/25 Stefano V <st...@gm...>:

> Hello
> Hibernate (I think..) doesn't support schema generation and consequently
> smartweb too.  you must do it "handmade" ...
> If you use the hibernate feature to generate tables
>
> i.e.
> <property name="hbm2ddl.auto">create</property>
> inside smartweb.jar.hcf
>
> You have to create the schema script (in your own db dialect) before use
> application.
>
> bye
> Stefano Vetrini
>
>
> 2008/4/24 Sébastien LE CALLONNEC <sl...@ya...>:
>
> >
> >
> > Hi All,
> >
> > Is there any script that can be executed to create the db schema for auth?
> The only ones I've found so far are grants and inserts.
> >
> >
> >
> > Thanks,
> > Sébastien.
>
>

> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save $100.
> Use priority code J8TL2D2.
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> smartweb-user mailing list
> sma...@li...
> https://lists.sourceforge.net/lists/listinfo/smartweb-user
>
>



--
 Roberto Lo Giacco

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
smartweb-user mailing list
sma...@li...
https://lists.sourceforge.net/lists/listinfo/smartweb-user

__________________________________________________
Do You Yahoo!?
En finir avec le spam? Yahoo! Mail vous offre la meilleure protection possible contre les messages non sollicités 
http://mail.yahoo.fr Yahoo! Mail