Informix JDBC - System or internal error

Posted in 2004

Topics: Connectivity: ODBC / JDBC / .NET, Java & JDBC Development, Cloud, Docker & Containers

LLOYD SERRAO — Mon, 08 Mar 2004 05:05:53 — source: IIUG Forums & Mailing Lists

Dear All, My java developers are trying to connect to my DB & are getting the error "java.sql.SQLException: System or internal error". What could be the problem. This error happens occassionally. Below are the settings in the property file - XXX.SQLConnectionPool.MinimumReadyConnections=50 XXX.SQLConnectionPool.MaximumReadyConnections=100 XXX.SQLConnectionPool.MaximumConnections=100 XXX.SQLConnectionPool.MaximumConnectionAge=3600000 XXX.SQLConnectionPool.MaximumConnectionWait=30000 XXX.SQLConnectionPool.MaximumWaiters=0 But i can connect to my DB using other 3rd party tools like Winsql. Do i need to tune any of the above parameters or configure Informix Configuration parameters. Please advice. Best Regards, Lloyd Java exception error -- 2004-03-08 09:16:26 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception com.pegs.netbooker.exception.ws.WSDatabaseExceptionApplicationExceptionERRORCODE : PCC1003ERRORMESSAGE : java.sql.SQLException: System or internal errorWSApplicationExceptionERRORCODE : PCC1003ERRORMESSAGE : java.sql.SQLException: System or internal errorWSDatabaseExceptionERRORCODE : PCC1003ERRORMESSAGE : java.sql.SQLException: System or internal error at com.pegs.netbooker.util.IDGenerator.getNewID(IDGenerator.java:194) at com.pegs.netbooker.util.IDGenerator.getPCCID(IDGenerator.java:78) at org.apache.jsp.IDGenerator_jsp._jspService(IDGenerator_jsp.java:45) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt erChain.java:284) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. java:204) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2 56) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.ja va:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValv e.java:245) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1 99) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.ja va:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:195) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.ja va:151) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.ja va:149) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156 ) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.ja va:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:211) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:805) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnectio n(Http11Protocol.java:696) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:67 7) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: System or internal error at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2198) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1340) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1313) at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:216) at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:839) at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:139) at com.pegs.netbooker.util.IDGenerator.getNewID(IDGenerator.java:149) ... 32 more

↪ replying to LLOYD SERRAO

Olson, Kenneth — Mon, 08 Mar 2004 14:26:36 — source: IIUG Forums & Mailing Lists

I don't have a solution but I am curious, we are having similar problems with jdbc. What engine are you using? Did this connection ever work? I have a jdbc connection that will work for months then all of a sudden it stops working(IDS 7.24UC2). I can snoop the port and see that the jdbc call is getting there but the listener does not even see it. Now if I point it to a different server/database with a synonym back to where I want to go it works (hack). I'm hoping our upgrades will eliminate this problem because I have yet to get an answer on this on. sound familiar ? -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On Behalf Of LLOYD SERRAO Sent: Sunday, March 07, 2004 11:06 PM To: ids@iiug.org Subject: Informix JDBC - System or internal error [2627] Dear All, My java developers are trying to connect to my DB & are getting the error "java.sql.SQLException: System or internal error". What could be the problem. This error happens occassionally. Below are the settings in the property file - XXX.SQLConnectionPool.MinimumReadyConnections=50 XXX.SQLConnectionPool.MaximumReadyConnections=100 XXX.SQLConnectionPool.MaximumConnections=100 XXX.SQLConnectionPool.MaximumConnectionAge=3600000 XXX.SQLConnectionPool.MaximumConnectionWait=30000 XXX.SQLConnectionPool.MaximumWaiters=0 But i can connect to my DB using other 3rd party tools like Winsql. Do i need to tune any of the above parameters or configure Informix Configuration parameters. Please advice. Best Regards, Lloyd Java exception error -- 2004-03-08 09:16:26 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception com.pegs.netbooker.exception.ws.WSDatabaseExceptionApplicationExceptionERRORCODE : PCC1003ERRORMESSAGE : java.sql.SQLException: System or internal errorWSApplicationExceptionERRORCODE : PCC1003ERRORMESSAGE : java.sql.SQLException: System or internal errorWSDatabaseExceptionERRORCODE : PCC1003ERRORMESSAGE : java.sql.SQLException: System or internal error at com.pegs.netbooker.util.IDGenerator.getNewID(IDGenerator.java:194) at com.pegs.netbooker.util.IDGenerator.getPCCID(IDGenerator.java:78) at org.apache.jsp.IDGenerator_jsp._jspService(IDGenerator_jsp.java:45) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt erChain.java:284) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. java:204) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2 56) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.ja va:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValv e.java:245) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1 99) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.ja va:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:195) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.ja va:151) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.ja va:149) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156 ) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.ja va:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:211) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:805) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnectio n(Http11Protocol.java:696) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:67 7) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: System or internal error at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2198) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1340) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1313) at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:216) at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:839) at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:139) at com.pegs.netbooker.util.IDGenerator.getNewID(IDGenerator.java:149) ... 32 more