my guess is that some of your connections are not being closed/returned to
the pool. after a while oracle hits its max connections and refuses to give
out anymore. restarting jrun causes everything to get garbage collected and
all the connections get closed, so eveything works for a while until max
connections is reached again.
go through your code and make sure connections are ALWAYS being
closed/returned. if you are throwing any SQLExceptions, make sure you
close/return the connection in the finally block.
i'm not sure how or why a change in providers would have triggered this, but
it really sounds like the connections are being closed/returned.
--jim
-----Original Message-----
From: Boemio, Neil (CAP, FGI) [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 3:52 PM
To: JRun-Talk
Subject: JRun/Oracle/Firewall
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
