DataBase Driver and URL Configurations

Since TomEE doesn't have any UI, all the data sources should be created manually in tomee.xml file in conf directory.

Below are the parameters and their corresponding values for different databases.

DB Drivers Config
Drivers Details

Oracle

jdbcDriver = oracle.jdbc.driver.OracleDriver

jdbcUrl = jdbc:oracle:thin:@<host>:<port>:<sid>

SQLServer

jdbcDriver = com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbcUrl = jdbc:sqlserver://<host>:<port>;DatabaseName=<databasename>

OSC configuration changes For TomEE

For TomEE, the service-registry.xml file needs to be changed with the following changes as TomEE uses ActiveMQ internally for messaging Queues. For more details related to initial setup refer OIPA OSC Installation guide.

Service-Registry

<TemplateName>Greetings.ftl</TemplateName>

<ConnectionFactory>java:openejb/Resource/OSCConnectionFactory</ConnectionFactory>

<Destination>java:openejb/Resource/OSCQueue</Destination>

</Service>

OSC configuring Connection Factory and Queue in TomEE

In tomee.xml file we need to configure the Connection Factory and Queue required for JMS setup. The following example shows the way of configuring them if the server is running locally.

TomEE connection details

BrokerXmlConfig = broker:(tcp://localhost:61616)

Serverurl = tcp://localhost:61616

DataSource = ADMINSERVERDS

</Resource>

ResourceAdapter = JMSResourceAdapter

</Container>

resourceAdapter = JMSResourceAdapter

</Resource>

Document Generator (Additional Changes)

Refer 11.3.2.0 OIPA Document Generator for more details.

Installation

Note: JDK17 does not have a fonts directory inside jdk/lib directory. Hence the fonts folder has been shipped in OIPA distribution.

For tomEE and weblogic environments, fonts folder has to be placed on jdk/libs folder at OS level, i.e. /usr/java/jdk-17.0.7/lib.

For Liberty environment, fonts folder has to be placed in jdk/libs folder inside liberty environment, i.e. /scratch/oipa/IBM/WebSphere/Liberty/java/17.0/jdk-17.0.x/lib

Required Libraries

OIPA expects crystal runtime libraries for Document Generator functionality. Below listed libraries from crjava-runtime_12.2.219.zip must be placed in the class loader of the application server. Each of these files is included with Crystal Reports and not included with OIPA.

Copy the CR libraries into the shared\crlib directory of TomEE

commons-collections-3.2.2.jar	commons-configuration-1.2.jar	commons-logging-1.2-1e55e8f.jar	commons-lang-2.1.jar
CrystalCommon2.jar	CrystalReportsRuntime.jar	DatabaseConnectors.jar	log4j.jar
logging.jar	icu4j-4.6.jar	JDBInterface.jar	keycodeDecoder.jar

The catalina.properties file in the conf folder needs to be modified so as to make the TomEE container to pick custom configuration or CR jars defined by user.

Application shared/lib folders

shared.loader=${catalina.home}/shared/lib,${catalina.home}/shared/lib/*.jar,

${catalina.home}/shared/crlib/*.jar,${catalina.home}/shared/conf