Re: JDBC Connection Time-out

Thanks for the suggestions so far, but let me clarify. I need to know if
there is anything on the i5 side causing the idle connections to be dropped
not on the web server side. This is the main reason why I posted it here
and not on the Java list. I did find information that MySQL has an idle
connection setting within its database settings, but does the i5?

So far, it is looking like it is all on the web server side and not on the
i5.

Thanks,
Scott J


Scott Johnson wrote:

We have an outside consultant using the JTOpen JDBC driver to connect to
our i5 (v5r4). They are using apache, tomcat, hibernate, and such. They
are saying that their connections are getting dropped after a time of
in-activity. They have asked me if there are any settings on the i5 that
control this. From what I have been able to find out via searching is that
there is nothing and that it has to do with how they have the connection
set-up on their side. I just need confirmation that this would be true and
I can then throw it back into their lap.

I checked the "TCP keep alive" setting on the i5 and it is set to 120
(default). I could change this down to a lower level, but I don't see how
that would solve their problem. The first person in the morning after an
long evening of inactivity on the website would still have problems.

Thanks,
Scott J.