Changing the schema name in the Web Gateway

The Web Gateway can use a database that has a non-default schema name. You must change the schema name in the Web Gateway EAR file.

About this task

The default schema name is FTEWEB. To change the name of the schema that the Web Gateway uses, complete the following steps:

Procedure

  1. Extract the JAR file using the following command:
    jar -xvf com.ibm.wmqfte.web.ear lib/com.ibm.wmqfte.web.jpa.fs.jar

    The JAR file is found in <product_install_location>/web/com.ibm.wmqfte.web.ear.

  2. Extract the persistence.xml file from the JPA JAR file by using the following command:
    jar -xvf lib/com.ibm.wmqfte.web.jpa.fs.jar META-INF/persistence.xml
  3. Edit the META-INF/persistence.xml file to change the following line:
    <property name="openjpa.jdbc.Schema" value="schema_name" />
    where
    • schema_name is your chosen schema name. The default schema name is FTEWEB
  4. Update JPA JAR with the modified persistence.xml file by using the following command:
    jar -uvf lib/com.ibm.wmqfte.web.jpa.fs.jar META-INF/persistence.xml
  5. Update the EAR file with the modified JPA JAR file by using the following command:
    jar -uvf com.ibm.wmqfte.web.ear lib/com.ibm.wmqfte.web.jpa.fs.jar

Task Task

Feedback

Timestamp icon Last updated: Tuesday, 30 January 2018
http://www.ibm.com/support/knowledgecenter/SSEP7X_7.0.4/com.ibm.wmqfte.doc/web_gateway_schema.htm