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

Chad,

You don't need the SQL package on your as400, as the runtime is part of the
OS.

Have you got a link to the connection pooling article?

Cheers
Colin.W

-----Original Message-----
From: cornelius, chad [mailto:chad.cornelius@xxxxxxxxxxxxxxxxxxxx] 
Sent: 16 December 2003 14:20
To: 'JAVA400-L@xxxxxxxxxxxx'
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.

For the latest on Bertram Books products and services and for up-to-the-minute 
book news visit www.bertrams.com


This e-mail and any attachments may contain information that is confidential 
and privileged and is solely for the use of the intended recipient. If you are 
not the intended recipient please notify the sender and delete this e-mail and 
any attachments immediately