Timed out issue (JSP in Oracle Portal 10g) [message #392352] |
Tue, 17 March 2009 11:09 |
khuishaque
Messages: 1 Registered: March 2009 Location: Riyad
|
Junior Member |
|
|
Dears,
It is really amazing for me to see this issue in my application which I deployed in Oracle Application Server 10g r2.
I am using JDeveloper 10g to create jsp pages.
On one jsp page i am displaying 15 html tables for a report.
All tables have 1 query to get records from oracle 10g database.
Am opening one connection and than one by one running queries just before each table and rendering data through ResultSet (which is scrollable).
If I test this page from JDeveloper, it is displaying fine.
But when I deploy this page in Oracle Application Server 10g,
and create a portlet and show this jsp page in portlet and open this page,
this page most of the time giving 'TIMED OUT', and a few times displaying report properly.
I tried PreparedStatement to run multiple queries for Oracle DB, but couldn't make it successfully.
BTW,
I checked my OAS log, it shows following error:
09/03/16 18:39:08 hrwfapp: [instance=(null), id=(null)] ERROR: Request has exceeded its warning timeout Time[elapsed=61046ms. Warning timeout=20000ms.] Request[id=5003532663665,3 providerId=493501 portletId=117 portletName=AttritionReports portletInstance=35555_ATTRITIONREPORTS_493501 user=PUBLIC] Thread[ name=AJPRequestHandler-ApplicationServerThread-6 priority=5 alive=true interrupted=false groupName=ApplicationServerThreadGroup]
Please help me in this regard, what should I do to avoid Timed out issue.
Best Regards
|
|
|