QConnector

{{toc}}

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

h2. 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}/logging/log4j-appender.xml

** log4j-category.xml - http://192.168.2.13:50000/svn/qconnector/trunk/qconnector-config/{environment}/logging/log4j-category.xml

*Steps:*

# login as jboss user

# <code>cd</code> to <code>/opt/jboss-5.1.0.GA/server/default-with-hornetq/conf</code>

<pre>

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

</pre>

# open the *jboss-log4j.xml*

<pre>

$ vi jboss-log4j.xml

</pre>

# append the content of *log4j-appender.xml* (see above) into the *jboss-log4j.xml*

# append the content of *log4j-category.xml* (see above) into the *jboss-log4j.xml*

# save the file, *jboss-log4j.xml*

# restart the jboss

# done

h2. 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:*

# login as jboss user

# upload and overwrite the file */opt/jboss-5.1.0.GA/server/default-with-hornetq/deploy/hornetq.sar/hornetq-configuration.xml*

# upload and overwrite the file */opt/jboss-5.1.0.GA/server/default-with-hornetq/deploy/hornetq.sar/hornetq-jms.xml*

# restart jboss

# done

h2. init script for Jboss AS 5

Describes how to configure the <code>init</code> script for Jboss AS in RHEL. Once configured, the server will start the <code>Jboss AS</code> 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:*

# login as root 

# upload the file, *jboss5hq* to */etc/init.d* via ftp or sftp

# execute the following command to put the <code>init</code> into appropriate run level directory:

<pre>

# chkconfig --add jboss5hq

</pre>

# done

h2. Table Used

Create the *EVENT_LOG* table in the *USA* database:

<pre>

<code class="sql">

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)

);

</code>

</pre>