× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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
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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.