Re : Re : Dev Environment Setup

[Sébastien LE CALLONNEC]

Some parts of this message have been removed. Learn more about Nabble's security policy.

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.

----- Message d'origine ----
De : Sébastien LE CALLONNEC <slc_ie@...>
À : Smartweb framework users discussions <smartweb-user@...>
Envoyé le : Vendredi, 18 Avril 2008, 6h10mn 04s
Objet : [smartweb-user] Re : Dev Environment Setup

Hi Roberto,

Ok, I've logged out and back in again, and this time it worked.  It doesn't quite make sense to me, but at least I've been able to add the pictures now.
With regards to Eclipse, I'm using Europa Winter indeed (3.3.2), along with JBoss Tools 2.0.1.  I have added those details to the page.

 

Regards,
Sébastien.

----- Message d'origine ----
De : Roberto Lo Giacco <rlogiacco@...>
À : Smartweb framework users discussions <smartweb-user@...>
Envoyé le : Jeudi, 17 Avril 2008, 16h28mn 13s
Objet : Re: [smartweb-user] Dev Environment Setup

Hi Sebastien,
first of all thank you for your contribution.

About your issue with the wiki

2008/4/17 Sébastien LE CALLONNEC <slc_ie@...>:

> progress, but I think you may have some feedback on this (there's supposed
> to be screenshots too, but it looks like I don't have permissions to upload
> files).  Here is the link: http://smartweb.wikidot.com/devenvironmentsetup

I double checked the configuration and if I've to trust the wikidot
permissions configuration page I should say all site members are
allowed to upload files in the _default scope. Can you please double
check you are not allowed to upload files? May be the wikidot page is
lying to me (meaning the real configuration doesn't match what is
displayed on the web) but it sounds strange to me.

> I am basically trying to run a Smartweb application in Eclipse Java EE +
> JBoss Tools, so if you have any input in that matter, feel free to update
> the page!  That might prove useful to potential users who want to assess
> Smartweb.

Can you give us more details about the configuration you are trying?
Is that Eclipse Europa with EE plugins?
which specific version? If I'm not wrong there should be 3.0.2 out there.


--
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

__________________________________________________
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

[Roberto Lo Giacco-4]

Hi Sébastien ,

it's nice to hear again from you! ;-)

Sébastien LE CALLONNEC wrote:
> 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.
>  
It can be generated issuing the command mvn process-classes which
generates a file named schema.sql into the res folder

Actually we are not including the generated ones as it will change on a
per database engine basis, anyway I think in the long term we should
make those pre-generated scripts (one for each database we decide to
officially support) available for download through the website or the
wiki. Please, help us know what you think is the right place.

We'll continue this topic on the development forum if you agree.

Roberto


-------------------------------------------------------------------------
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

[svetrini]

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-4]

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

[svetrini]

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

-------------------------------------------------------------------------
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