| Summary: | Modeshape does not come with SQL scripts to create JPA store | ||
|---|---|---|---|
| Product: | [JBoss] JBoss Enterprise SOA Platform 5 | Reporter: | Jiri Pechanec <jpechane> |
| Component: | EDS | Assignee: | Van Halbert <vhalbert> |
| Status: | CLOSED NEXTRELEASE | QA Contact: | |
| Severity: | high | Docs Contact: | |
| Priority: | high | ||
| Version: | 5.1.0.ER1 | ||
| Target Milestone: | --- | ||
| Target Release: | 5.1.0.ER4 | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| URL: | http://jira.jboss.org/jira/browse/SOA-2326 | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2010-11-10 11:32:37 UTC | Type: | Task |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Bug Depends On: | |||
| Bug Blocks: | 779911 | ||
|
Description
Jiri Pechanec
2010-09-17 13:53:35 UTC
When using a new repository, for production, the idea is to use "validate" and to manually set up the database (using a SQL script created with the "modeshape-jpa-ddl-gen" utility). The gen utility jar (modeshape-jpa-ddl-gen-2.2.0.Final-jar-with-dependencies.jar) is not currently being included. Probably need to wrap this with in a build.xml that makes it easier to run. If there is such utility it should be executed during build process - all other SOA-P components comes with SQL scripts, including those using JPA or Hibernate for db access Parent: Added: SOA-2271 For ER2, there is a tools directory with the gen jar. For the next release, will be adding the script generation tooling that will generate all the scripts for the supporting dbs. The ddl-gen tool is now unbundled with scripts to execute to create ddl. Also, when modeshape is installed, the predefined supported repositories will be automatically generated. There will be a directory for each dialect supported containing the create and drop ddl. MS SQL scripts are missing Also MySQL should be generated using MySQL 5 dialect to have transactions enabled on the tables - ie. create table ... type=InnoDB; The fix has been checked into the soa build. This problem was due to incorrectly entering the dialect for MS. Verified in ER4 |