The Java™ Platform,
Enterprise Edition (JEE) database logger can use a database that has
a non-default schema name. You must change the schema name in the
database logger EAR file.
About this task
To change the name of the schema that your JEE database logger
uses, complete the following steps:
Procedure
- Extract the JPA JAR file from the EAR file by using the
following command:
jar -xvf ear_file lib/jpa_file
where:- ear_file is com.ibm.wmqfte.databaselogger.jee.oracle.ear or com.ibm.wmqfte.databaselogger.jee.ear depending
on whether you are using DB2® or
Oracle.
- jpa_file is com.ibm.wmqfte.web.jpa.oracle.jar or com.ibm.wmqfte.web.jpa.jar depending
on whether you are using Db2 or
Oracle.
- Extract the persistence.xml file from
the JPA JAR file by using the following command:
jar -xvf lib/jpa_file META_INF/persistence.xml
where:- jpa_file is com.ibm.wmqfte.web.jpa.oracle.jar or com.ibm.wmqfte.web.jpa.jar depending
on whether you are using Db2 or
Oracle.
- Edit the persistence.xml file to change
the following line:
<property name="openjpa.jdbc.Schema" value="schema_name" />
where- schema_name is the schema name you want to
use.
- Update JPA JAR with the modified persistence.xml file
by using the following command:
jar -uvf lib/jpa_file META_INF/persistence.xml
where:- jpa_file is com.ibm.wmqfte.web.jpa.oracle.jar or com.ibm.wmqfte.web.jpa.jar depending
on whether you are using Db2 or
Oracle.
- Update the EAR file with the modified JPA JAR file by using
the following command:
jar -uvf ear_file lib/jpa_file
where:- ear_file is com.ibm.wmqfte.databaselogger.jee.oracle.ear or com.ibm.wmqfte.databaselogger.jee.ear depending
on whether you are using Db2 or
Oracle.
- jpa_file is com.ibm.wmqfte.web.jpa.oracle.jar or com.ibm.wmqfte.web.jpa.jar depending
on whether you are using Db2 or
Oracle.
What to do next
Use the modified EAR file to install the JEE database logger.