OK I added localhost as a server and have a system DSN called Calendar but
when I try to access it it tells me that there are no system DSN entries.
Any advice - if I go to DataSources it shows my DSN what am I doing wrong???
Thanks in advance Shawn Harris
----- Original Message -----
From: "Boemio, Neil (CAP, FGI)" <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 9:22 AM
Subject: RE: JRun/Oracle/Firewall
> Well, since a conn.createStatement() hangs, I won't be able to do this.
>
> -----Original Message-----
> From: Moore, Jim [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 04, 2001 11:55 AM
> To: JRun-Talk
> Subject: RE: JRun/Oracle/Firewall
>
>
> how about running a super simple query like "SELECT 1"
>
> if you get back 1 in the resultset, everything is a-ok, otherwise dump the
> connection.
>
> -----Original Message-----
> From: Boemio, Neil (CAP, FGI) [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 04, 2001 11:11 AM
> To: JRun-Talk
> Subject: RE: JRun/Oracle/Firewall
>
>
> Well, I found out why this was happening, but I can't find a solution.
>
> There *is* a check in the connection pool code to test if a connection is
> valid before returning it for use. The problem is that when the firewall
> kills a connection, any test on
> that connection to check if it's valid will just hang and eventually time
> out.
>
> I have found that if I kill connections on the Oracle end, the connection
> validity test works just fine (it throws an exception immediately). When
> this happens, I catch the
> exception and create a new connection. But when the connection is timed
out
> in the firewall's connection table, there seems to be no way to test the
> connection without hanging.
>
> I have tried using conn.commit(), conn.createStatement(), and others, as
the
> method for testing to see if the connection is valid. The obvious choice
> would be to use
> conn.isClosed(). But this seems to return False when the connection is
bad!
>
> Any ideas on how to test a connection without hanging?
>
> > -----Original Message-----
> > From: Boemio, Neil (CAP, FGI)
> > Sent: Saturday, March 31, 2001 10:36 AM
> > To: '[EMAIL PROTECTED]'
> > Subject: RE: JRun/Oracle/Firewall
> >
> > I found out some information from a firewall guy. It looks like it's a
> firewall issue:
> >
> > Yes, that's probably what's happening. The firewall maintains a
> connection table for all established connections (this applies to tcp
only).
> The session time-out is currently
> > set for 3600 seconds (1 hour). This is the default setting. We can
> increase up to 7200 seconds (2 hours) fairly easily. I believe that in
> order to go beyond the 2 hour limit,
> > we need to tweak firewall parameters you normally don't want to play
with,
> which may also require a firewall reload. At any rate, even if we can do
> this, I'm not sure that it's
> > a good idea. If we fill the connection table with dormant connections,
we
> could wreak havoc on all users, perhaps even require a system reboot. Of
> course, we could extend the
> > size of the connection table, but this means playing with more
parameters
> you normally don't want to touch.
> >
> > -----Original Message-----
> > From: Boemio, Neil (CAP, FGI)
> > Sent: Friday, March 30, 2001 3:52 PM
> > To: '[EMAIL PROTECTED]'
> > 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
