I did :
 - installation
 - setting of datasource preference : MySQL5
 - then testing it is ok
 - etc...
I set the datasource to MySQL5 only for PortalDS.
I have let the hypersonic db for the DefaultDS (for the time being, but will 
put it in MySQL5 later... more clean for prod).

About drop database :
the scripts are several : one for "all the database", and some for deleting 
specifically the CMS part, the user and role part, the Portal part.

When developping, I usually "erase" only the Portal part. 
And keep safe the CMS and Users/Roles parts. 

This to clean the portal description (when playing with new 
windows/instances/portlets), but KEEP all the data of the CMS and all the users 
I need for my tests.
Can't recreate all this each time. 

That's why I do not drop the whole DB.

By the way, I used to do some "delete" of records rather than "drop table" : 
avoid to recreate the tables... quicker when relaunching the server... which 
may be several time per hours, when playing with new windows, instances, and 
portlets.

With JBPM, the tables are strongly in relation with foreign keys. It seems not 
possible to just suppress the records (the jbpm objects/instances). 
Do you know a way to do that ?
(may be it will not be something to do oftenly, like Users/Roles part... but 
just to know).



View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4056296#4056296

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4056296
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to