QConnector

{{toc}}

h1. Administration

Describes how to administrate the common tasks, for instance, update properties files, change logging level and etc.

h2. User Guide - Batches/Daemon

See [[User Guide - Batches/Daemon]]

h2. Monitor Log Files

All of the log files can be found in:

<pre>

/var/ecwyconnector/info.log

/var/ecwyconnector/error.log

/var/ecwyconnector/debug.log

</pre>

All of the log files for daemon/batches can be found in:

<pre>

/var/ecwyconnector-daemon/batch-info.log

/var/ecwyconnector-daemon/batch-error.log

/var/ecwyconnector-daemon/batch-debug.log

</pre>

h2. Change Logging Level

The available logging level:

* *INFO* - default level

* *DEBUG* - should not set to this level unless necessary

* *ERROR*

* *WARN*

_JBoss 4.0.x_

> {jboss folder}/server/{profile name}/conf/log4j.xml

_Jboss 4.2.x / Jboss 5.1.x_

> {jboss folder}/server/{profile name}/conf/jboss-log4j.xml

_Batches/Daemon_

> /opt/ecosway/daemon/qconnector/config/log4j.xml

h2. Update Properties Files

All of the properties files can be found in:

<pre>

/data/qconnector

</pre>

h3. ws-mimic

List of the properties files:

* /data/qconnector/ws-mimic/application.properties

* /data/qconnector/ws-mimic/jndi-factory.properties

* *application.properties*

|_.Property name|_.Description|

|ws.url|The URL of the web service which process the request|

|status.callback.url|the callback URL of the caller to update the status, e.g. Dot Com mall |

* *jndi-factory.properties*

|_.Property name|_.Description|

|jndi.initial|the initial context of the JNDI|

|jndi.url|the URL of the JNDI provider (JMS)|

|jndi.url.pkgs|the naming packages of the JNDI|

|jndi.connection.factory|the JNDI name of the JMS connection factory|

|session.cache.size|the number of JMS session to be cached|

|request.queue.name|the name of the JMS queue which keeps the web service request|

|response.queue.name|the name of the JMS queue which keeps the web service response|

h3. ws-status

List of the properties files:

* /data/qconnector/ws-status/database.properties

* database.properties

|_.Property name|_.Description|

|jndi.datasource|the JNDI name of the data source|

|db.dialect|the database dialect, e.g. DB2|

|db.show.sql|indicates whether to show the SQL used|

|db.sql.comment|indicates whether to show the comment of the SQL used|

h3. ecosway-adaptor

List of the properties file:

* /data/qconnector/ecosway-adaptor/application.properties

* /data/qconnector/ecosway-adaptor/database.properties

* /data/qconnector/ecosway-adaptor/registration/template.properties

* *application.properties*

|_.Property name|_.Description|

|ws.url|the URL of the web service. Currently this is the URL of the mimic of the actual web service|

|connector.user|the username of the actual web service|

|connector.password|the password of the actual web service|

* *database.properties*

|_.Property name|_.Description|

|jndi.datasource|the JNDI name of the data source|

|db.dialect|the database dialect, e.g. DB2|

|db.show.sql|indicates whether to show the SQL used|

|db.sql.comment|indicates whether to show the comment of the SQL used|

h2. Housekeeping

The following files (e.g. log file, report file), which are older than *30-day*, will be deleted:

* *application log folder:*

** <pre>/var/ecwyconnector</pre>

* *daemon/batch log folder:*

** <pre>/var/ecwyconnector-daemon</pre>

* *output folder of generated report:*

** <pre>/opt/ecosway/daemon/qconnector/reports</pre>

The housekeeping script can be found in SVN:

> http://192.168.2.13:50000/svn/qconnector/trunk/qconnector-config/housekeeping

h2. Scheduled Task

*Daemon/Batch:*

|_.Name|_.Path|_.Scheduled Time|

|PendingEventProcessor|/opt/ecosway/daemon/qconnector/pending_event_processor.sh|Hourly|

|EventReport|/opt/ecosway/daemon/qconnector/event_report.sh|Daily at 0105|

*Housekeeping:*

|_.Name|_.Path|_.Scheduled Time|

|Remove application log files which older than 30-day|/opt/ecosway/housekeeping/scripts/delete_old_webapp_log_files.sh|Daily at 0010|

|Remove daemon log files which older than 30-day|/opt/ecosway/housekeeping/scripts/delete_old_daemon_log_files.sh|Daily at 0010|

|Remove old generated report files which older than 30-day|/opt/ecosway/housekeeping/scripts/delete_old_report_files.sh|Daily at 0010|