1) $HOME/[MOUNT POINT]/apex-config.xml
2) ${config.dir}/[MOUNT POINT]/apex-config.xml ( from web.xml )
3) ${java.io.tmpdir}/[MOUNT POINT]/apex-config.xml (default for new installs )
4) $HOME/apex-config.xml
5) ${config.dir}/apex-config.xml ( from web.xml )
6) ${java.io.tmpdir}/APEX/apex-config.xml (default for new installs )
Now for some new things.
1) A new /listenerAdmin which gives realtime stats. It's a long ways from the end look of the page but it give stats. This is protected by a role named "listenerAdmin". Users and roles are setup in the webserver. To setup this role in tomcat, edit the conf/tomcat-users.xml and add something like this:
<tomcat-users>
<role rolename="listenerAdmin"></role></pre>
<user password="klrice" roles="listenerAdmin" username="klrice"></user>
</tomcat-users>
Here's an example from the tryapexnow.com site:
Current Time: Thu Feb 11 20:08:40 EST 2010
Server uptime: 50 Days 07:16:23.966
Total accesses: 1449806.0
Total Traffic: 21.85G
Total File Downloads: 86029
Total Errors: 3678
Total Processing Time: 10 Days 21:07:36.838
2) There's now a mechanism to log the full db requests. This is a step towards having the requests repayable in the Unit Tester.
To begin with this here's the 2 lines needed in the apex-config.xml
<entry key="apex.log.enable">false</entry>
<entry key="apex.log.procedure">log_proc</entry>
A sample of the required signature is in the WEB-XML/sample_capture.sql
3) The listener can now take a *.xls file that is uploaded and convert it into a collection. Here's the steps to try this out.
a) This needs to be turned on in the apex-config.xml
<entry key="apex.excel2collection">true</entry>
b) The file upload page must have a request of xls2collection.
You should get a collection of the name of the item and the C001 is the name of the sheet in the xls file. Here's an example.
