Hide Forgot
Affects: Documentation (Ref Guide, User Guide, etc.) Complexity: Low Help Desk Ticket Reference: https://access.redhat.com/issue-tracker/1002453 project_key: SOA Ran schema changing script to change to oracle. Then ran script again to change to postgres. The script . SOA comes configured with HSQL, if you run the script it will rename the *-ds.xml to *-ds.xml.org. If you run the script again and change it to a different database, it leaves a lot of stuff behind. 1) leaves old *-ds.xml in deploy (for example oracle-ds.xml, unlike the other files, it doesn't rename it to .org) 2) leaves deploy/messaging/*persistence* (it similar to the datasource, it doesn't rename this one, so when you start you get errors about duplicates) 3) juddi_config/META-INF/persistence.xml - It didn't change the hibernate.dialect to the new database <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect" /> 4) /deploy/jbossesb.esb/jbossesb-service.xml - it didn't update the message-store-sql to the new value <attribute name="SqlFiles"> message-store-sql/postgresql/create_database.sql 5) jbossesb-registry.sar/juddi_config/META-INF/persistence.xml - it didn't update the hibernate dialect 6) deploy/uuid-key-generator.sar/META-INF/jboss-service.xml - it left this somehow, this was when I had oracle config switching to postgres, I had to remove scott. <attribute name="TableName">scott.HILOSEQUENCES</attribute>
The schema tool does not currently support being run more than once to change to a different database.
We may consider a schema tool that has capabilities like this for the future. For now, we need to document that the intent of the tool is to do a one time set, initial set up. This can be documented in the guide or maybe in a Readme.
We need to clearly document that the schema tool can only be run once. There was never an intent for it to be run more than once.
Labels: Removed: schema soa tool Added: ESB_Administrator_Guide Getting_Started_Guide schema soa tool
The ESB Administrators Guide explicity states that this tool can be run multiple times so long as there have been no other configuration changes to this file. This needs to be removed and add the warning that it can only be run once.
Labels: Removed: ESB_Administrator_Guide Getting_Started_Guide schema soa tool Added: ESB_Administrator_Guide schema soa tool Complexity: Added: Medium Affects: Added: [Documentation (Ref Guide, User Guide, etc.)]
Complexity: Removed: Medium Added: Low
Writer: Added: Darrin
can you update the ESB Admin Guide with this please ?
Release Notes Text: Added: I have added this warning. I will add it to the project doc at the next merge.
Release Notes Text: Removed: I have added this warning. I will add it to the project doc at the next merge.
Release Notes Docs Status: Added: Not Required