Dear All,


can any one help me on this ..

Our application running in solaris environment and iplanetAplication server 6.0 .with type 2 driver.



When users have reported that system is not giving any response We have taken thread dump at regular interval .We found that some threads were active and hanged for more than 30 mins and the following is one among them. In all the issues we found that oci driver is causing the problem.In all the threads which are hanging for more time , all were trying to execute oracle.jdbc.oci8.OCIDBAccess.do_fetch or
oracle.jdbc.oci8.OCIDBAccess.do_execute methods.

Can anyone find what is causing the problem .is it purely driver related issue or anything else.


"Thread-41" (TID:0xd00590, sys_thread_t:0xd004c8, state:R, thread_t: t@47, threadID:0xe9011a00, stack_bottom:0xe7700000, stack_size:0x80000) prio=5

[1] oracle.jdbc.oci8.OCIDBAccess.do_fetch(Native Method)
[2] oracle.jdbc.oci8.OCIDBAccess.fetch(OCIDBAccess.jav a:1358)
[3] oracle.jdbc.driver.OracleStatement.<init>(OracleSt atement.java:455)
[4] oracle.jdbc.driver.OracleStatement.getCursorValue( OracleStatement.java:2608)
[5] oracle.jdbc.driver.OracleStatement.getObjectValue( OracleStatement.java:4134)
[6] oracle.jdbc.driver.OracleStatement.getObjectValue( OracleStatement.java:4123)
[7] oracle.jdbc.driver.OracleCallableStatement.getObje ct(OracleCallableStatement.java:541)
[8] com.ramco.maps.ccms.Cc.FMS.bean.CF_BkngDetails_bea n.getMPHBkngDtls(CF_BkngDetails_bean.java:143)
[9] jsp.APPS.maps.ccms.Cc.FMS.Enquiry_Registration.CF_ BookingDetails_02._jspService(CF_BookingDetails_02 .java:337)
[10] jsp.APPS.maps.ccms.Cc.FMS.Enquiry_Registration.CF_ BookingDetails_02.service(CF_BookingDetails_02.jav a:322)
[11] javax.servlet.http.HttpServlet.service(HttpServlet .java:835)
[12] com.netscape.server.servlet.servletrunner.ServletI nfo.service(Unknown Source)
[13] com.netscape.server.servlet.servletrunner.ServletR unner.callJSP(Unknown Source)
[14] com.netscape.server.servlet.platformhttp.PlatformH ttpServletResponse.callJspCompiler(Unknown Source)
[15] com.netscape.server.servlet.platformhttp.PlatformH ttpServletResponse.callUri(Unknown Source)
[16] com.netscape.server.servlet.platformhttp.PlatformH ttpServletResponse.callUriRestrictOutput(Unknown Source)
[17] com.netscape.server.servlet.platformhttp.PlatformR equestDispatcher.forward(Unknown Source)
[18] com.netscape.server.servlet.jsp.JSPRunner.service( Unknown Source)
[19] javax.servlet.http.HttpServlet.service(HttpServlet .java:835)
[20] com.netscape.server.servlet.servletrunner.ServletI nfo.service(Unknown Source)
[21] com.netscape.server.servlet.servletrunner.ServletR unner.execute(Unknown Source)
[22] com.kivasoft.applogic.AppLogic.execute(Unknown Source)
[23] com.kivasoft.applogic.AppLogic.execute(Unknown Source)
[24] com.kivasoft.thread.ThreadBasic.run(Native Method)