Teamworks Localhost Access Log - 6.2 and JBoss

How To Configure Localhost Access log in Teamworks 6.2 on JBoss

Teamworks localhost access log provides a means to track the requests and responses passing through the JBoss server. This includes access to all the static files (images, JS and CSS) as well as the dynamic resources (JSP, Servlets). 

This configuration can be found in the file process-server/deploy/jbossweb-tomcat55.sar/server.xml. In this file locate the entry <Valve className="org.apache.catalina.valves.FastCommonAccessLogValve", un-comment this tag to enable the logging. For various aspects of logging available, please refer the link given below.

Reference : http://tomcat.apache.org/tomcat-5.5-doc/config/valve.html 

Note: Tomcat does not support automatic house keeping of the logs, i.e. if you need to keep only "n" days worth of log, you would need to schedule jobs to delete the logs jobs. Tomcat does not handle this.

Connect to Oracle RAC Database server

Oracle RAC database uses service-name instead of service-id. Hence, you would need a connection string formatted for using service-name.

Lets say your non-RAC server was hosted on "abc.xyz.com" @ port 1521 and your SID is oradb01, then your connection string would have been :

  jdbc:oracle:thin:@abc.xyz.com:1521:oradb01

On a oracle RAC database server with service-name as oradb01, your connection string would be :

 jdbc:oracle:thin:@//abc.xyz.com:1521/oradb01

Note : I assume you are using Oracle thin driver for Java.

How to Refresh Coach Designer HTML (TW 6.2.2)

Problem Statement
You want to refresh the HTML generated by combining the Coach's XML and CoachDesigner.xsl

How To Do That?
Use "touch" command on *nix platforms to update timestamp of CoachDesigner.xsl file. The HTML will be refreshed next time any user requests for that Coach.

Useful SQL

select
 pi.name,
 p.last_modified AS "Service Modified On",
 pi.twcomponent_id,
 pi.process_item_id,
 pi.last_modified AS "Coach Last Modified On",
 cr.resource_data,
 cr.virtual_name,
 cr.last_modified AS "Coach XML/HTML Modified",
 cr.coach_resource_id
from
 tw_proc.lsw_process_item pi,
 tw_proc.lsw_process p,
 TW_PROC.lsw_coach_resource cr
where
  pi.process_id = p.process_id and
  pi.twcomponent_name = 'Coach' and
  p.name = '<NAME OF SERVICE>' and
  pi.twcomponent_id = cr.coach_id;