• Table of contents
• Configuration
  • log4j (Jboss AS 5)
  • HornetQ 2
  • init script for Jboss AS 5
  • Table Schema

Configuration¶

Prerequisite:

• Completed the Installation section.

This section describes how to configure the logging and settings on the application server. All of the configuration files can be found in SCM repository:

Production environment:

http://192.168.2.13:50000/svn/qconnector/trunk/qconnector-config/production

Development environment:

http://192.168.2.13:50000/svn/qconnector/trunk/qconnector-config/development

log4j (Jboss AS 5)¶

Describes how to configure the log4j logging in Jboss AS 5.

Assumes that Jboss AS 5 is installed in:

/opt/jboss-5.1.0.GA

List of the configuration files needed:

• Note: replace {environment} with either production (for production environment) or development (for development environment)
  • log4j-appender.xml - http://192.168.2.13:50000/svn/qconnector/trunk/qconnector-config/{environment}/ws-mimic/logging/log4j-appender.xml
  • log4j-category.xml - http://192.168.2.13:50000/svn/qconnector/trunk/qconnector-config/{environment}/ws-mimic/logging/log4j-category.xml

Steps:

1. login as jboss user
2. cd to /opt/jboss-5.1.0.GA/server/default-with-hornetq/conf
   

   $ cd /opt/jboss-5.1.0.GA/server/default-with-hornetq/conf
   

3. open the jboss-log4j.xml
   

   $ vi jboss-log4j.xml
   

4. append the content of log4j-appender.xml (see above) into the jboss-log4j.xml
5. append the content of log4j-category.xml (see above) into the jboss-log4j.xml
6. save the file, jboss-log4j.xml
7. restart the jboss
8. done

HornetQ 2¶

Describes how to upload the HornetQ's configuration file.

Assumes that Jboss AS 5 is installed in:

/opt/jboss-5.1.0.GA

List of the configuration files needed:

• Note: replace {environment} with either production (for production environment) or development (for development environment)
  • hornetq-configuration.xml - http://192.168.2.13:50000/svn/qconnector/trunk/qconnector-config/{environment}/hornetq/hornetq-configuration.xml
  • hornetq-jms.xml - http://192.168.2.13:50000/svn/qconnector/trunk/qconnector-config/{environment}/hornetq/hornetq-jms.xml

Steps:

1. login as jboss user
2. upload and overwrite the file /opt/jboss-5.1.0.GA/server/default-with-hornetq/deploy/hornetq.sar/hornetq-configuration.xml
3. upload and overwrite the file /opt/jboss-5.1.0.GA/server/default-with-hornetq/deploy/hornetq.sar/hornetq-jms.xml
4. restart jboss
5. done

init script for Jboss AS 5¶

Describes how to configure the init script for Jboss AS in RHEL. Once configured, the server will start the Jboss AS process upon bootup. However, you may skip this section if you plan to start the Jboss AS manually.

Assumes that Jboss AS 5 is installed in:

/opt/jboss-5.1.0.GA

List of the configuration files needed:

• Note: replace {environment} with either production (for production environment) or development (for development environment)
• Note: replace {servername} with the targeted server's hostname, e.g. cwyrnd3-server
  • jbosshq - http://192.168.2.13:50000/svn/qconnector/trunk/qconnector-config/{environment}/{servername}/jboss-init/jboss5hq

Steps:

1. login as root
2. upload the file, jboss5hq to /etc/init.d via ftp or sftp
3. execute the following command to put the init into appropriate run level directory:
   

   # chkconfig --add jboss5hq
   

4. done

Table Schema¶

Create the EVENT_LOG table in the USA database:

create table ECOS.EVENT_LOG(
    id int NOT NULL GENERATED ALWAYS AS IDENTITY,
    description clob(512K),
    event_type varchar(100), 
    status varchar(100),
    last_updated timestamp,
    error_code varchar(20),
    primary key (id)
);