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