I have a very puzzling problem. I'm using JRun 2.3.3 Build 157 to connect to an
Oracle 8.1.6 database.
I'm using connection pooling and it seems that when my site is idle for sometime
(maybe an hour or so), I cannot load any JSP pages that connect to Oracle. Static
HTML pages and
JSP pages that do NOT connect to Oracle are just fine.
Restarting JRun always fixes the problem. But I've also noticed that if I kill the
Oracle connections and then refresh the browser, I can connect again.
At first I was using my own custom database connection pool and I thought it might be
something I coded wrong. So I switched to a connection pool I downloaded from
http://www.webdevelopersjournal.com/columns/connection_pool.html, but the problem
still occurs.
It almost seems like the connections or something else in JRun is timing out after
some time of inactivity.
Another confusing part is that this same setup on my current web hosting provider
works fine. We are moving to a different provider now and that is where the problem
is happening
with the same exact code.
Could a difference in the environment be any cause? Any ideas as to where to look?
Thanks,
Neil
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
