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
- 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.
- 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
- 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
- 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
- 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