Re : Re : Re : Dev Environment Setup

View: New views
2 Messages — Rating Filter:   Alert me  

Re : Re : Re : Dev Environment Setup

by Sébastien LE CALLONNEC :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.
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 <stvnove@...>
À : Smartweb framework users discussions <smartweb-user@...>
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 <rlogiacco@...>:
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 <stvnove@...>:
> 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 <slc_ie@...>:
>
> >
> >
> > 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
> smartweb-user@...
> 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
smartweb-user@...
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
-------------------------------------------------------------------------
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
smartweb-user@...
https://lists.sourceforge.net/lists/listinfo/smartweb-user

Re: Re : Re : Re : Dev Environment Setup

by svetrini :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

normally this work is delegated to hibernate hbm2ddl function.
you can use it adding
<property name="hbm2ddl.auto">update</property>
in your smartweb.jar.hcf in smartweb framework
or
in hibernate.cfg.xml in hibernate standalone.


2008/4/29 Sébastien LE CALLONNEC <slc_ie@...>:
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 <stvnove@...>
À : Smartweb framework users discussions <smartweb-user@...>
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 <rlogiacco@...>:
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 <stvnove@...>:
> 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 <slc_ie@...>:
>
> >
> >
> > 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
> smartweb-user@...
> 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
smartweb-user@...
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

-------------------------------------------------------------------------
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
smartweb-user@...
https://lists.sourceforge.net/lists/listinfo/smartweb-user



-------------------------------------------------------------------------
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
smartweb-user@...
https://lists.sourceforge.net/lists/listinfo/smartweb-user