Skip to main content

Glassfish file upload error

Please note these java.net forums are being decommissioned and use the new and improved forums at https://community.oracle.com/community/java.
2 replies [Last post]
yerill
Offline
Joined: 2013-04-19

Hello,

I have a problem with a glassfish cluster. The environment is:

Load balancer
Apache 2.2 Proxy (on host A)
Glassfish 3.1.2.2 (on host A)
Apache 2.2 Proxy (on host B)
Glassfish 3.1.2.2 (on host B)
Apex 4.2.2 (on host C)
Oracle 11.2.0.3 (on host C)

Using Oracle's Apex Sample File Upload and Download Code, I fairly often get an Apex "Please select a file to upload." error. The problem seems to be occuring on one node only. In the glassfish access logs, I see a successful POST. I see nothing in the Glassfish server logs. If I use ngrep to look at the Glassfish to database traffic on port 1521 from host B to host C, I see an ORA-01403 "no data found".

If I watch the directory /generated/jsp/apex I can see the file to be uploaded temporarily appear and then go away.

How can I enable more debug logging in Glassfish to track down this issue?

Thanks!

Reply viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
yerill
Offline
Joined: 2013-04-19

I was able to get Apex listener log events by following the notes here: http://cdivilly.wordpress.com/2013/03/11/configuring-logging-with-oracle...

I now have ClassName=oracle.dbtools.apex in the server.log

yerill
Offline
Joined: 2013-04-19

Here is the log for a failed upload. I don't see a reason for the failure. I still see an ORA-01403 in ngrep.

#
T 10.10.10.10:1521 -> 10.20.20.20:59874 [AP]
.J............Y.....{........ ..........V........ORA-01403: no data found

Here is the log. Any ideas? Everything else seems to work in Apex, except these file uploads, on this cluster node. Works fine on the other node. (Bouncing, and clearning caches does not help).

[#|2013-08-16T11:04:39.177-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.rt.web.HttpEndpointBase;MethodName=service;|Request Path passes syntax validation|#]

[#|2013-08-16T11:04:39.180-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.common.config.db.DatabasePoolConfig;MethodName=log;|Not time to mappings:131916|#]

[#|2013-08-16T11:04:39.181-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.rt.jdbc.DatabaseConnectionFilter;MethodName=applyDatabaseConnectionInfo;|Mapping request to database pool: PoolMap [_poolName=apex, _regex=null, _workspaceIdentifier=null, _failed=false, _lastUpdate=-1, _template=null, _type=REGEX]|#]

[#|2013-08-16T11:04:39.182-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.rt.web.HttpEndpointBase;MethodName=service;|Applied database connection info|#]

[#|2013-08-16T11:04:39.182-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.rt.web.HttpEndpointBase;MethodName=service;|Attempting to process with PL/SQL Gateway|#]

[#|2013-08-16T11:04:39.182-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|==== Processing Request: ====|#]

[#|2013-08-16T11:04:39.183-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|POST /apex/wwv_flow.accept|#]

[#|2013-08-16T11:04:39.183-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|==== Headers in Request ====|#]

[#|2013-08-16T11:04:39.183-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|host: myhost.mydomain:28282|#]

[#|2013-08-16T11:04:39.183-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|connection: keep-alive|#]

[#|2013-08-16T11:04:39.183-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|content-length: 1657159|#]

[#|2013-08-16T11:04:39.184-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|cache-control: max-age=0|#]

[#|2013-08-16T11:04:39.184-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8|#]

[#|2013-08-16T11:04:39.184-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|origin: http://myhost.mydomain:28282|#]

[#|2013-08-16T11:04:39.185-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/28.0.1500.71 Chrome/28.0.1500.71 Safari/537.36|#]

[#|2013-08-16T11:04:39.186-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|content-type: multipart/form-data; boundary=----WebKitFormBoundary26Bbva7BH66UZ9IG|#]

[#|2013-08-16T11:04:39.187-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|referer: http://myhost.mydomain:28282/apex/wwv_flow.accept|#]

[#|2013-08-16T11:04:39.187-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|accept-encoding: gzip,deflate,sdch|#]

[#|2013-08-16T11:04:39.187-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|accept-language: en-US,en;q=0.8|#]

[#|2013-08-16T11:04:39.188-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|cookie: WWV_CUSTOM-F_1315017908377450_126=ORA_WWV-iBBFqTLtnQcJhWPJwIu3DMMi; ORA_WWV_USER_63107111708993=ORA_WWV-Hq0M2ygJ3xATfzALFwyr2BsA; LOGIN_USERNAME_COOKIE=my_username; ORA_WWV_PACKAGED_APPLICATIONS=ORA_WWV-MX0WEeQWmFZXckgW+3jMd17m|#]

[#|2013-08-16T11:04:39.188-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|==== Cookies in Request ====|#]

[#|2013-08-16T11:04:39.189-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|WWV_CUSTOM-F_1315017908377450_126 = ORA_WWV-iBBFqTLtnQcJhWPJwIu3DMMi|#]

[#|2013-08-16T11:04:39.189-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|ORA_WWV_USER_63107111708993 = ORA_WWV-Hq0M2ygJ3xATfzALFwyr2BsA|#]

[#|2013-08-16T11:04:39.189-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|LOGIN_USERNAME_COOKIE = my_username|#]

[#|2013-08-16T11:04:39.190-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=debugRequest;|ORA_WWV_PACKAGED_APPLICATIONS = ORA_WWV-MX0WEeQWmFZXckgW+3jMd17m|#]

[#|2013-08-16T11:04:39.190-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_flow_id=2001|#]

[#|2013-08-16T11:04:39.190-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_flow_step_id=12|#]

[#|2013-08-16T11:04:39.191-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_instance=14013854436577|#]

[#|2013-08-16T11:04:39.191-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_page_submission_id=4720977285279|#]

[#|2013-08-16T11:04:39.191-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_request=CREATE|#]

[#|2013-08-16T11:04:39.191-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_arg_names=2623414469927671315|#]

[#|2013-08-16T11:04:39.191-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_arg_names=2623414663481671332|#]

[#|2013-08-16T11:04:39.192-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_arg_names=2623414879803671334|#]

[#|2013-08-16T11:04:39.192-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_arg_names=2623415059906671334|#]

[#|2013-08-16T11:04:39.192-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_arg_names=2623415264950671334|#]

[#|2013-08-16T11:04:39.192-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_arg_names=2623415481315671338|#]

[#|2013-08-16T11:04:39.193-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_arg_names=2623415677245671338|#]

[#|2013-08-16T11:04:39.193-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_t01=|#]

[#|2013-08-16T11:04:39.193-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_arg_checksums=2623414469927671315_7E3E7F4C953167A86255C04FC6E48BA6|#]

[#|2013-08-16T11:04:39.193-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_arg_checksums=2623414879803671334_7E3E7F4C953167A86255C04FC6E48BA6|#]

[#|2013-08-16T11:04:39.193-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_arg_checksums=2623415059906671334_7E3E7F4C953167A86255C04FC6E48BA6|#]

[#|2013-08-16T11:04:39.194-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_arg_checksums=2623415264950671334_7E3E7F4C953167A86255C04FC6E48BA6|#]

[#|2013-08-16T11:04:39.194-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_t02=303057051003812791843352436077801112800|#]

[#|2013-08-16T11:04:39.194-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_t03=|#]

[#|2013-08-16T11:04:39.194-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_t04=|#]

[#|2013-08-16T11:04:39.194-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_t05=|#]

[#|2013-08-16T11:04:39.195-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_t07=delete me|#]

[#|2013-08-16T11:04:39.195-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_md5_checksum=|#]

[#|2013-08-16T11:04:39.195-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=addValue;|request parameter: p_page_checksum=8D255D65A83732D7243C574E707F2909|#]

[#|2013-08-16T11:04:39.195-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=getProcedureName;|Using Procedure:wwv_flow.accept|#]

[#|2013-08-16T11:04:39.196-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.security.Security;MethodName=isValidRequest;|isValidRequest(), procedure name: |#]

[#|2013-08-16T11:04:39.196-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=validateProcedure;|Validating: wwv_flow.accept|#]

[#|2013-08-16T11:04:39.196-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.common.config.db.DatabaseConfig;MethodName=getConnection;|Requesting Pool:apex|#]

[#|2013-08-16T11:04:39.196-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.common.config.db.DatabaseConfig;MethodName=createPool;|pool exists: apex|#]

[#|2013-08-16T11:04:39.198-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.Procedure;MethodName=getProcedure;|*** Total number of arguments: 510|#]

[#|2013-08-16T11:04:39.203-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=init;|SID: 103|#]

[#|2013-08-16T11:04:39.205-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=printElapsedTime;|Parse: 0 ms|#]

[#|2013-08-16T11:04:39.206-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=execute;|-----
begin
wwv_flow.accept(p_flow_step_id=>?,
p_md5_checksum=>?,
p_arg_names=>?,
p_page_checksum=>?,
p_t07=>?,
p_t05=>?,
p_t04=>?,
p_t03=>?,
p_t02=>?,
p_t01=>?,
p_request=>?,
p_page_submission_id=>?,
p_arg_checksums=>?,
p_flow_id=>?,
p_instance=>?);
commit;
end;|#]

[#|2013-08-16T11:04:39.206-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.Procedure;MethodName=getProcedure;|*** Total number of arguments: 510|#]

[#|2013-08-16T11:04:39.206-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=bind;|p_flow_step_id= 12|#]

[#|2013-08-16T11:04:39.206-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=bind;|p_md5_checksum=|#]

[#|2013-08-16T11:04:39.207-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=bind;|p_arg_names: {2623414469927671315, 2623414663481671332, 2623414879803671334, 2623415059906671334, 2623415264950671334, 2623415481315671338, 2623415677245671338}|#]

[#|2013-08-16T11:04:39.207-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=bind;|p_page_checksum= 8D255D65A83732D7243C574E707F2909|#]

[#|2013-08-16T11:04:39.207-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=bind;|p_t07= delete me|#]

[#|2013-08-16T11:04:39.207-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=bind;|p_t05=|#]

[#|2013-08-16T11:04:39.208-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=bind;|p_t04=|#]

[#|2013-08-16T11:04:39.208-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=bind;|p_t03=|#]

[#|2013-08-16T11:04:39.208-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=bind;|p_t02= 303057051003812791843352436077801112800|#]

[#|2013-08-16T11:04:39.208-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=bind;|p_t01=|#]

[#|2013-08-16T11:04:39.209-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=bind;|p_request= CREATE|#]

[#|2013-08-16T11:04:39.209-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=bind;|p_page_submission_id= 4720977285279|#]

[#|2013-08-16T11:04:39.209-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=bind;|p_arg_checksums: {2623414469927671315_7E3E7F4C953167A86255C04FC6E48BA6, 2623414879803671334_7E3E7F4C953167A86255C04FC6E48BA6, 2623415059906671334_7E3E7F4C953167A86255C04FC6E48BA6, 2623415264950671334_7E3E7F4C953167A86255C04FC6E48BA6}|#]

[#|2013-08-16T11:04:39.209-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=bind;|p_flow_id= 2001|#]

[#|2013-08-16T11:04:39.210-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.OWA;MethodName=bind;|p_instance= 14013854436577|#]

[#|2013-08-16T11:04:39.307-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=printElapsedTime;|Exec: 97 ms|#]

[#|2013-08-16T11:04:39.321-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApex;MethodName=handleRequest;|Got results length: 33051|#]

[#|2013-08-16T11:04:39.321-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.HeaderUtils;MethodName=processResponseHeaders;|==== Headers from Results ====|#]

[#|2013-08-16T11:04:39.321-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.HeaderUtils;MethodName=processHeader;|Setting Content-Type (Content-type): text/html; charset=utf-8|#]

[#|2013-08-16T11:04:39.322-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.HeaderUtils;MethodName=processHeader;|Adding cache-control: no-cache, no-store, max-age=0, must-revalidate|#]

[#|2013-08-16T11:04:39.322-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.HeaderUtils;MethodName=processHeader;|Adding pragma: no-cache|#]

[#|2013-08-16T11:04:39.322-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.HeaderUtils;MethodName=processHeader;|Adding X-Frame-Options: DENY|#]

[#|2013-08-16T11:04:39.332-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.apex.ModApexContext;MethodName=close;|==== Request Processed ====|#]

[#|2013-08-16T11:04:39.332-0400|FINE|glassfish3.1.2|null|_ThreadID=162;_ThreadName=Thread-2;ClassName=oracle.dbtools.rt.web.HttpEndpointBase;MethodName=service;|Processed PL/SQL Gateway request|#]