Re: Tomcat version 4.1.27 Crash after iSeries upgrade From V5R2 to V5R3

Thanks David, we already have a quick fix, but i really want to know why 
it was working before the upgrade, is there any system variables changed 
in the new V5R3.

Thanks.


Edouard Lanteigne
Abbott Laboratories (Canada), Systems Analyst
Tel: (514) 832-7124 Fax: (514) 832-7833
E-mail : edouard.lanteigne@xxxxxxxxxx
http://www.abbott.ca


This communication may contain information that is proprietary, 
confidential or exempt from disclosure. If you are not the intended 
recipient, please note that any dissemination, distribution, use or 
copying of this communication is strictly prohibited. Anyone who receives 
this message in error should notify the sender immediately by telephone or 
by return e-mail, and delete it from his or her computer.

Cette communication peut contenir des renseignements protégés, 
confidentiels ou soustraits à la divulgation en vertu de la loi. Si vous 
n'êtes pas le destinataire prévu, veuillez prendre note que la 
divulgation, la distribution ou la reproduction de cette communication 
sont strictement interdites. Si vous avez reçu cette communication par 
erreur, veuillez immédiatement en avertir l’expéditeur par téléphone ou 
par retour de ce courriel, et supprimer la communication de votre 
ordinateur.



"David Morris" <David.Morris@xxxxxxxxxxxxx> 
Sent by: java400-l-bounces@xxxxxxxxxxxx
06/15/2005 02:42 PM
Please respond to
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>


To
<java400-l@xxxxxxxxxxxx>
cc

Subject
Re: Tomcat version 4.1.27 Crash after iSeries upgrade From      V5R2 to 
V5R3






Eduard,

What connection pool implementation are you using? If it is DBCP you might 
try setting a validationQuery. This is usually a simple query that will 
run very quickly and is used to check connections before they are 
returned. That is not a long term solution but it may help you keep the 
system up and running. This is not really related, but you may want to 
look at a newer JDK and some unit tests.

David Morris


>>> edouard.lanteigne@xxxxxxxxxx 06/15/05 11:38 AM >>>
I am using Tomcat which connecting to Oracle (Classes12.jar) using 
connection pooling, since the upgrade i am getting an error every hour 
(Around) and i have to restart the Tomcat.


Here is the tomcat log .
CPC2206:  Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed. 
 
Using Classpath: 
/tomcat400/bin/bootstrap.jar:/QIBM/ProdData/Java400/jdk13/lib/tools.jar 
 
Using CATALINA_BASE: /tomcat400 
Using CATALINA_HOME: /tomcat400 
Using JAVA_HOME: /QIBM/ProdData/Java400/jdk13 
*INFO| Registry - -Loading registry information 
*INFO| Registry - -Creating new Registry instance 
*INFO| Registry - -Creating MBeanServer 
*INFO| Http11Protocol - -Initializing Coyote HTTP/1.1 on port 9080 
 
Starting service Tomcat-Standalone 
Apache Tomcat/4.1.27 
*INFO| PropertyMessageResources - -Initializing, 
config='org.apache.struts.util.LocalStrings', returnNull=true 
*INFO| PropertyMessageResources - -Initializing, 
config='org.apache.struts.action.ActionResources', returnNull=true 
*INFO| PropertyMessageResources - -Initializing, 
config='org.apache.webapp.admin.ApplicationResources', returnNull=true 
*INFO| Http11Protocol - -Starting Coyote HTTP/1.1 on port 9080 
*INFO| ChannelSocket - -JK2: ajp13 listening on 0.0.0.0/0.0.0.0:8009 
 
*INFO| JkMain - -Jk running ID=0 time=35/899 
config=/tomcat400/conf/jk2.properties 
Order processed: 1 
Order processed: 2 
 Order processed: 3 
 Order number:40181026 Ship Flag true 
 Order number:40180929 Ship Flag true 
 Order number:40181028 Ship Flag true 
 Order processed: 4 
 Order number:40180929 Ship Flag true 
 Order processed: 5 
 Order processed: 6 
 Order number:40181028 Ship Flag true 
 Order number:40181021 Ship Flag true 
 Order processed: 7 
 Order number:40181029 Ship Flag true 
 Order processed: 8 
 Order number:40181016 Ship Flag true 
 Order processed: 9 
 Order number:40181007 Ship Flag true 

 Message :SYS1002!! RootCause :java.sql.SQLException: Closed Statement SQL 

Exception!! Severity :3!! Pricer Generated :false
java/lang/Throwable.<init>(Ljava/lang/String;)V+4 (Throwable.java:85) 
 
java/lang/Exception.<init>(Ljava/lang/String;)V+1 (Exception.java:33) 
 
abbott/contractmgmt/error/SelecticaAPIException.<init>(Ljava/lang/String;ILjava/lang/String;)V+2
 

(SelecticaAPIException.java:5 
abbott/contractmgmt/rules/orderhistory/HierarchyAdmin.getHierarchy(Ljava/lang/String;I)Ljava/util/List;+458
 

(HierarchyAdmin.ja 
abbott/contractmgmt/rules/orderhistory/HierarchyMgmt.processHierachy(Labbott/contractmgmt/integration/Order;)V+48
 

(HierarchyMg 
abbott/contractmgmt/pricerinterface/SelecticaPricingRequest.processRequest()V+116
 

(SelecticaPricingRequest.java:118) 
abbott/contractmgmt/integration/Order.submit()Labbott/contractmgmt/integration/OrderResponse;+14
 

(Order.java:460) 
PricingServlet.doPost(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V+475
 

(PricingServlet.ja 
javax/servlet/http/HttpServlet.service(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V+139
 

( 
javax/servlet/http/HttpServlet.service(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+30
 

(HttpServlet.java:85 
org/apache/catalina/core/ApplicationFilterChain.internalDoFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;
 

 
org/apache/catalina/core/ApplicationFilterChain.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+101
 

( 
org/apache/catalina/core/StandardWrapperValve.invoke(Lorg/apache/catalina/Request;Lorg/apache/catalina/Response;Lorg/apache/ca
 


org/apache/catalina/core/StandardPipeline$StandardPipelineValveContext.invokeNext(Lorg/apache/catalina/Request;Lorg/apache/cat
 


org/apache/catalina/core/StandardPipeline.invoke(Lorg/apache/catalina/Request;Lorg/apache/catalina/Response;)V+10
 

(StandardPip 
org/apache/catalina/core/ContainerBase.invoke(Lorg/apache/catalina/Request;Lorg/apache/catalina/Response;)V+8
 

(ContainerBase.j 
org/apache/catalina/core/StandardContextValve.invoke(Lorg/apache/catalina/Request;Lorg/apache/catalina/Response;Lorg/apache/ca
 


org/apache/catalina/core/StandardPipeline$StandardPipelineValveContext.invokeNext(Lorg/apache/catalina/Request;Lorg/apache/cat
 


org/apache/catalina/core/StandardPipeline.invoke(Lorg/apache/catalina/Request;Lorg/apache/catalina/Response;)V+10
 

(StandardPip 
org/apache/catalina/core/ContainerBase.invoke(Lorg/apache/catalina/Request;Lorg/apache/catalina/Response;)V+8
 

(ContainerBase.j 
org/apache/catalina/core/StandardContext.invoke(Lorg/apache/catalina/Request;Lorg/apache/catalina/Response;)V+81
 

(StandardCont 
org/apache/catalina/core/StandardHostValve.invoke(Lorg/apache/catalina/Request;Lorg/apache/catalina/Response;Lorg/apache/catal
 


org/apache/catalina/core/StandardPipeline$StandardPipelineValveContext.invokeNext(Lorg/apache/catalina/Request;Lorg/apache/cat
 


org/apache/catalina/valves/ErrorDispatcherValve.invoke(Lorg/apache/catalina/Request;Lorg/apache/catalina/Response;Lorg/apache/
 


org/apache/catalina/core/StandardPipeline$StandardPipelineValveContext.invokeNext(Lorg/apache/catalina/Request;Lorg/apache/cat
 


org/apache/catalina/valves/ErrorReportValve.invoke(Lorg/apache/catalina/Request;Lorg/apache/catalina/Response;Lorg/apache/cata
 


org/apache/catalina/core/StandardPipeline$StandardPipelineValveContext.invokeNext(Lorg/apache/catalina/Request;Lorg/apache/cat
 


org/apache/catalina/core/StandardPipeline.invoke(Lorg/apache/catalina/Request;Lorg/apache/catalina/Response;)V+10
 

(StandardPip 
org/apache/catalina/core/ContainerBase.invoke(Lorg/apache/catalina/Request;Lorg/apache/catalina/Response;)V+8
 

(ContainerBase.j 
org/apache/catalina/core/StandardEngineValve.invoke(Lorg/apache/catalina/Request;Lorg/apache/catalina/Response;Lorg/apache/cat
 


org/apache/catalina/core/StandardPipeline$StandardPipelineValveContext.invokeNext(Lorg/apache/catalina/Request;Lorg/apache/cat
 


org/apache/catalina/core/StandardPipeline.invoke(Lorg/apache/catalina/Request;Lorg/apache/catalina/Response;)V+10
 

(StandardPip 
org/apache/catalina/core/ContainerBase.invoke(Lorg/apache/catalina/Request;Lorg/apache/catalina/Response;)V+8
 

(ContainerBase.j 
org/apache/coyote/tomcat4/CoyoteAdapter.service(Lorg/apache/coyote/Request;Lorg/apache/coyote/Response;)V+103
 

(CoyoteAdapter.j 
org/apache/coyote/http11/Http11Processor.process(Ljava/io/InputStream;Ljava/io/OutputStream;)V+253
 

(Http11Processor.java:601) 
org/apache/coyote/http11/Http11Protocol$Http11ConnectionHandler.processConnection(Lorg/apache/tomcat/util/net/TcpConnection;*L
 


org/apache/tomcat/util/net/TcpWorkerThread.runIt(*Ljava/lang/Object;)V+167 

(PoolTcpEndpoint.java:565) 
org/apache/tomcat/util/threads/ThreadPool$ControlRunnable.run()V+184 
(ThreadPool.java:619) 
java/lang/Thread.run()V+11 (Thread.java:479) 
processed: 72 
ge :SYS1002!! RootCause :java.sql.SQLException: Closed Statement SQL 
Exception!! Severity :3!! Pricer Generated :false 
java/lang/Throwable.<init>(Ljava/lang/String;)V+4 (Throwable.java:85) 
 
java/lang/Exception.<init>(Ljava/lang/String;)V+1 (Exception.java:33) 
 

.....

An idea of what has changed from R2 to R3


Edouard Lanteigne