Mikolaj Rydzewski wrote: > I have following setup: Tomcat 5.5.23 with Oracle database 10.2.0.1.0 ... > There are several webapps deployed. After some time, depending on usage, > applications get stucked - I mean every request that needs database > connection hangs. Thread dump looks ALWAYS the same: > > "http-8080-Processor21" daemon prio=1 tid=0x22aed1d8 nid=0x6958 runnable > [0x20a6c000..0x20a6e7f0] ... > at > oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272) > - locked <0xac40fc70> (a oracle.jdbc.driver.T4CStatement) > - locked <0x90979730> (a oracle.jdbc.driver.T4CConnection) ...
I may have seen something similar -- however unlike in the case you described, the only way we could recover was to restart Tomcat. However, once we upgraded to a more recent Oracle JDBC driver, the problem was gone (there are one-off Oracle patches that do update the JDBC driver, compared to the stock version; the driver we're using now is a result of installing such a patch; I'm rather certain the patches are included in 10.2.0.3 patchset). Getting these does require a valid support contract, though. Apologies for the vagueness of details (and I'm afraid I'm unable to locate the details later, either), it's some time since I was wrestling with this. But in any case, Oracle JDBC drivers seem to have bugs in the early versions (you're quoting db 10.2.0.1.0, thus an early version of 10gRel2; I suppose your JDBC driver comes from that installation). -- ..Juha --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
