Hi all,
I am using jboss-4.0.4.G.A version. When execution of SQL queries takes long time, say 5 to 8 hrs. My application is showing "Page cannot be displayed" error when the server is still running. What may be the problem? Is it problem with JBoss?
My Connection Pool settings are:
<local-tx-datasource>
<jndi-name>myjndi</jndi-name>
<connection-url>jdbc:oracle:thin:@127.0.0.1:1521:myjnditest</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>myuser</user-name>
mypwd
<!--pooling parameters-->
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>5</idle-timeout-minutes>
</local-tx-datasource>
Even I had tried increasing/decreasing <blocking-timeout-millis> and <idle-timeout-minutes>. But no use...
Any solution for this will be appreciated ?