All Forums Connectivity
shimpeko 8 posts Joined 04/10
11 Oct 2012
ERROR "Response Limit exceeded" in JDBC Driver

I got following error in my application(Web app deploying on JBoss EAP).
It seems exception generated at "CheckValidConnectionSQL.isValidConnection", when JDBC Driver try to check validity of connection.
I checked the JDBC User guide and SET LOB_SUPPORT to OFF, but still getting the same error.
Any advice?
 
 

2012-10-10 21:15:29,796 WARN  [org.jboss.resource.adapter.jdbc.local.LocalManagedCon nectionFactory] (http-0.0.0.0-18080-43) Destroying connection that is not valid, due to the following exception: com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection@ 36caf2d4

com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 13.00.00.16] [Error 3130] [SQLState HY000] Response limit exceeded.

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabas eSQLException(ErrorFactory.java:317)

at com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubSt ate.action(ReceiveInitSubState.java:104)

at com.teradata.jdbc.jdbc_4.statemachine.StatementReceive State.subStateMachine(StatementReceiveState.java:286)

at com.teradata.jdbc.jdbc_4.statemachine.StatementReceive State.action(StatementReceiveState.java:177)

at com.teradata.jdbc.jdbc_4.statemachine.StatementControl ler.runBody(StatementController.java:111)

at com.teradata.jdbc.jdbc_4.statemachine.StatementControl ler.run(StatementController.java:102)

at com.teradata.jdbc.jdbc_4.Statement.executeStatement(St atement.java:339)

at com.teradata.jdbc.jdbc_4.Statement.executeStatement(St atement.java:281)

at com.teradata.jdbc.jdbc_4.Statement.execute(Statement.j ava:254)

at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalStatement.e xecute(TeraLocalStatement.java:365)

at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalStatement.e xecute(TeraLocalStatement.java:329)

at org.jboss.resource.adapter.jdbc.CheckValidConnectionSQ L.isValidConnection(CheckValidConnectionSQL.java:58)

at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConn ectionFactory.isValidConnection(BaseWrapperManagedConn ectionFactory.java:560)

at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConn ection.checkValid(BaseWrapperManagedConnection.java: 323)

at org.jboss.resource.adapter.jdbc.local.LocalManagedConn ectionFactory.matchManagedConnections(LocalManagedConn ectionFactory.java:402)

at org.jboss.resource.connectionmanager.InternalManagedCo nnectionPool.getConnection(InternalManagedConnectionPo ol.java:225)

at org.jboss.resource.connectionmanager.JBossManagedConne ctionPool$BasePool.getConnection(JBossManagedConnectio nPool.java:690)

at org.jboss.resource.connectionmanager.BaseConnectionMan ager2.getManagedConnection(BaseConnectionManager2.java :404)

at org.jboss.resource.connectionmanager.TxConnectionManag er.getManagedConnection(TxConnectionManager.java:424)

at org.jboss.resource.connectionmanager.BaseConnectionMan ager2.allocateConnection(BaseConnectionManager2.java: 496)

at org.jboss.resource.connectionmanager.BaseConnectionMan ager2$ConnectionManagerProxy.allocateConnection(BaseCo nnectionManager2.java:941)

at org.jboss.resource.adapter.jdbc.WrapperDataSource.getC onnection(WrapperDataSource.java:89)

at com.ncr.twr.common.DataBase.doConnect(DataBase.java: 2166)

at com.ncr.twr.common.DataBase.doConnectFromDDCName(DataB ase.java:2075)

at com.ncr.twr.common.DataBase.execSqlCsv(DataBase.java: 1477)

at com.ncr.twr.http.TwrStreamingResponse.dataStream(TwrSt reamingResponse.java:104)

at com.ncr.twr.http.TwrServlet.doResponse(TwrServlet.java :549)

at com.ncr.twr.http.TwrServlet.doPost(TwrServlet.java:93)

at javax.servlet.http.HttpServlet.service(HttpServlet.jav a:637)

at javax.servlet.http.HttpServlet.service(HttpServlet.jav a:717)

at org.apache.catalina.core.ApplicationFilterChain.intern alDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilt er(ApplicationFilterChain.java:206)

at com.planetj.servlet.filter.compression.CompressingFilt er.doFilter(CompressingFilter.java:266)

at org.apache.catalina.core.ApplicationFilterChain.intern alDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilt er(ApplicationFilterChain.java:206)

at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilte r(ReplyHeaderFilter.java:96)

at org.apache.catalina.core.ApplicationFilterChain.intern alDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilt er(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(S tandardWrapperValve.java:235)

at org.apache.catalina.core.StandardContextValve.invoke(S tandardContextValve.java:191)

at org.jboss.web.tomcat.security.SecurityAssociationValve .invoke(SecurityAssociationValve.java:183)

at org.jboss.web.tomcat.security.JaccContextValve.invoke( JaccContextValve.java:95)

at org.jboss.web.tomcat.security.SecurityContextEstablish mentValve.process(SecurityContextEstablishmentValve.ja va:126)

at org.jboss.web.tomcat.security.SecurityContextEstablish mentValve.invoke(SecurityContextEstablishmentValve.jav a:70)

at org.apache.catalina.core.StandardHostValve.invoke(Stan dardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(Err orReportValve.java:102)

at org.jboss.web.tomcat.service.jca.CachedConnectionValve .invoke(CachedConnectionValve.java:158)

at org.apache.catalina.valves.AccessLogValve.invoke(Acces sLogValve.java:567)

at org.apache.catalina.core.StandardEngineValve.invoke(St andardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(Co yoteAdapter.java:330)

at org.apache.coyote.http11.Http11AprProcessor.process(Ht tp11AprProcessor.java:905)

at org.apache.coyote.http11.Http11AprProtocol$Http11Conne ctionHandler.process(Http11AprProtocol.java:593)

at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprE ndpoint.java:2036)

at java.lang.Thread.run(Thread.java:662)

Tags:
tomnolan 594 posts Joined 01/08
12 Oct 2012

Detailed advice is listed in the Teradata JDBC Driver Reference:
http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_5.html#CHDGCHBB
"To solve this issue, examine applications to verify that they have proper exception handling, with finally blocks coded to ensure that ResultSet objects, Statement objects, LOB InputStream, and LOB Reader objects are always closed as soon as they are no longer needed. If the application modifies LOBs, then Blob and Clob objects must be freed in finally blocks."
"Beginning with Teradata JDBC Driver version 14.00.00.08, if the LOG=INFO connection parameter is specified, then the Teradata JDBC Driver will log information about all outstanding open responses when a Teradata Database Error 3130 occurs. The logged information will include each open response's request number, date/time of submission, submitter thread ID, SQL request text, and submitter call stack. This information can be useful to an application developer to help pinpoint which places in the application are submitting SQL requests and not subsequently closing them."
Also, you are using an old version of the Teradata JDBC Driver (version 13.00.00.16), and you should upgrade to the latest version available here on Developer Exchange.
http://downloads.teradata.com/download/connectivity/jdbc-driver
 

shimpeko 8 posts Joined 04/10
18 Jul 2013

This was a bug, and fixed in current version.

You must sign in to leave a comment.