Re: Initial JDBC Hits to AS/400 DB using Tomcat is Very Slow?

Every time you start the Tomcat server, the temporary class files created
from the jsp's are created (when the page is first hit).  This is what
causes the slow response from the first hit.  You have a couple of options.
You could not shutdown the iSeries nightly (I believe that IBM does not
recommend shutting down the iSeries daily).  Another thing you could do is
to write a program that hits the page in question after the iSeries comes up
(so the users would not see the slow response).  Any platform running Tomcat
in this same scenario (shutting the server down daily) would have this same
issue.

Mike


----- Original Message ----- 
From: "cornelius, chad" <chad.cornelius@xxxxxxxxxxxxxxxxxxxx>
To: <JAVA400-L@xxxxxxxxxxxx>
Sent: Tuesday, December 16, 2003 9:19 AM
Subject: Initial JDBC Hits to AS/400 DB using Tomcat is Very Slow?


> Does anyone know what would cause initial JDBC hits on an AS/400 DB to
> perform slowly using Tomcat?  I have setup Tomcat to use connection
pooling
> just as David suggests in his article, "Tomcat on iSeries", which is very
> good by the way.  I have compiled all the .jar files, but Tomcat still
> performs slowly on the first hits.  Our AS/400's shutdown nightly to
perform
> backups, so I am not sure if this is the cause.  After one hit is made to
a
> table, all other hits are very fast.  It's just the first hit in the
> morning.  My other thought is that we do not have the SQL package on our
> AS/400, which allows you to perform the STRSQL command.  Would this be
> another reason?  It seems JDBC would be independent of that.  Does anyone
> have any suggestions?  Any help would be greatly appreciated.
>
>
>
> Thanks,
>
> Chad
>
>
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>