Hide Forgot
project_key: SOA There is some problem with modeshape DDL scripts for postgresql and oracle in 5.2 ER4. I ran test suite multiple times with different options but result is the same[1]. When I run the repo with autogenerate schema enabled, then tests pass with all databases. On the jenkins link below you can find server logs and configuration files used to setup repos. Server has been restarted between each repo changes made (although this makes no difference compared to admin console -> reload of modeshape component). Unfortunately I can't see any exceptions related to the problem in the log. The repos seem just not deployed. [1] https://hudson.qa.jboss.com/hudson/view/SOA-Release/job/soa-modeshape-ddl/143/
I'm not sure what was the problem in #143 above, but it seems to have worked itself out in https://hudson.qa.jboss.com/hudson/view/SOA-Release/job/soa-modeshape-ddl/144/. It succeeded.
Hey Van, it was far from fixing by itself ;) On each build page you can click "Parameters" and see what parameters have been set for the build. With 114 I verified that autogenerateschema makes tests pass. With the builds before it I verified that without the option, pgsql and oracle fail.
As I'm testing this, I realized the ddl scripts were changed for postgresql and oracle because of a jbpm schema collision with using sequencing. As noted in the create_sequence.modeshape-jpa-connector.ddl script: WARNING: Running this script could fail if jBPM and ModeShape are sharing the same database schema, and jBPM has already created the sequence I wonder if your tests setup is executing both (2) ddl scripts for these databases? The 2 scripts to run are: create.modeshape-jpa-connector.ddl and create_sequence.modeshape-jpa-connector.ddl This was done as a result of SOA-3187.
No, I'm not running both scripts. I can't understand what's the point in having the scripts split out? It seems like you need to execute both to have the repository working, correct? So why make it harder by splitting into two files? In case there is a very good reason for the split, then is there any order required when executing the files? Thank you!
As logged in SOA-3187, there's an issue if jBPM and ModeShape are sharing the same database. This is the reason for the "create sequence" being separated so the user has the option not to execute that statement. The was the option chosen after a group discussion on the issue.
Excuse me if missed something but such a decision can only make sense if modeshape repo can work without the problematic DDL script. But it seems like it cannot, so how is separating the files helping here? As far as I see user just needs to be made aware to not use modeshape an jBPM on the same DB. Please also tell me if order of execution of the two scripts should matter.
order of execution doesn't matter.
Thank you Van, when execting all SQL, modeshape seems to be working fine. Even DB2!
Temporarily reopening for release note status.
Release Notes Docs Status: Added: Not Required Writer: Added: dlesage