[jboss-user] [JBoss Portal] - Re: JBP2.6RC2 - MySQL5 : SQL Warning: 1051, SQLState: 42S02

[Antoine_h]

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