Hi,
Yes, I am doing a read only query.
I think I have found the reason. It is because my SQL query takes more than 15 minutes to finish but weblogic has the capability to monitor all the
thread, if a thread does not get a response in 10 minutes, weblogic will consider it as "stuck thread".
The solution is to either set the maximun idel time longer or stop having weblogic handle the connection. However, weblogic 6 does not have the option to change the default idel time (Which weblogic 7 does!), I just create my own JDBC connection to the database and the problem has been resolved.