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