All Forums Tools
JSwan 1 post Joined 04/05
16 Aug 2005
ERROR ~ [Teradata DBMS] : Response limit exceeded.

I MOVED THIS TO A MORE APPROPRIATE FORUMOur Java app is throwing this error :com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata DBMS] : Response limit exceeded.Anyone ever had this error before ?This seems to happen right after an insert of 108 rows into a Teradata table.TIAJay

kyang 3 posts Joined 05/08
23 May 2008

I try to modify my jdbc url like this : jdbc:teradata://10.46.9.111/LOB_SUPPORT=off , but I got the same error info. code like this :connection.prepareStatement(sql);connection.executeUpdate();connection.commit();What is the problem? Thanks!

Adeel Chaudhry 773 posts Joined 04/08
23 May 2008

Hello,What sort of query you execute when this error is generated?Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

Adeel Chaudhry 773 posts Joined 04/08
23 May 2008

After trying Wale's solution if the problem persists, do try by closing all the requests as soon as possible before sending new requests.Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

kyang 3 posts Joined 05/08
23 May 2008

insert into cfg_ccms_model(model_id, model_desc) values(?,?); sql like this...Thanks!

kyang 3 posts Joined 05/08
24 May 2008

I use a loop to executeUpdate, and commit out of loopcode like thisfor (int i =0; i < 100; i ++) { String sql = "update aaa"; conn.prepareStatement(sql); conn.executeUpdate();}conn.commit();

Adeel Chaudhry 773 posts Joined 04/08
25 May 2008

Try by lowering the loop, e.g. 100 => 10 if it works fine, then you are hitting a limit somehow, and also try by putting the commit part in the loop and then slowly increasing the loop till 100 (or whatever you like :))HTH.Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

murthy2k3 1 post Joined 11/10
03 Nov 2010

I am facing the same issue. Can you please update me if there is a solution.

tomnolan 594 posts Joined 01/08
04 Nov 2010

First, the code posted above is not the right way to use a PreparedStatement. You should not prepare a SQL request over and over again inside a loop.

Instead, the SQL request should be prepared once, before entering the loop. Inside the loop, parameter values should be bound to the question-mark parameter markers.

The code should look like:

String sql = "update aaa set bbb = ? where ccc = ?";
PreparedStatement ps = conn.prepareStatement(sql);
for (int i =0; i < 100; i ++)
{
ps.setInt(1,i);
ps.setInt(2,i);
ps.executeUpdate();
}

You can get better performance by using a PreparedStatement batch.

String sql = "update aaa set bbb = ? where ccc = ?";
PreparedStatement ps = conn.prepareStatement(sql);
for (int i =0; i < 100; i ++)
{
ps.setInt(1,i);
ps.setInt(2,i);
ps.addBatch();
}
ps.executeBatch();

This article discusses how to use PreparedStatements for better performance:

http://developer.teradata.com/connectivity/articles/speed-up-your-jdbcodbc-applications

Finally,
With respect to the Database Error 3130 "Response Limit Exceeded", please refer to the Troubleshooting section in the Teradata JDBC Driver User Guide about this topic.

The Teradata JDBC Driver User Guide can be found here in the Download Center:

http://www.teradata.com/DownloadCenter/Forum98-1.aspx

Go to Appendix B Troubleshooting,
Section "Large Object Interface"
Subsection "Response Limit Exceeded Error".

kefira 1 post Joined 03/11
16 Mar 2011

I could not find the Teradata JDBC Driver User Guide. Link is broken, googling it also did not bring any results. I am getting SQLException : "Data size bigger than max size for this type: 4057" on some machines (all Macs), although all machines are using same version of drivers, java and execute same query.

tomnolan 594 posts Joined 01/08
17 Mar 2011

Here's a different link for the Teradata JDBC Driver User Guide:

http://www.info.teradata.com/templates/eSrchResults.cfm?txtttlkywrd=CJDBC&rdsort=Title

Regarding your SQLException "Data size bigger than max size for this type: 4057" -- That doesn't look like any SQLException thrown by the Teradata JDBC Driver. Can you please post the entire exception stack trace?

Thanks,
--Tom

tomnolan 594 posts Joined 01/08
31 Oct 2012

The Teradata JDBC Driver User Guide is now located here on Developer Exchange. Use the link posted below.
The Teradata JDBC Driver User Guide's Troubleshooting section documents the common causes and remedies for Teradata Database Error 3130.
http://developer.teradata.com/doc/connectivity/jdbc/ reference/current/jdbcug_chapter_5.html#CHDGCHBB

You must sign in to leave a comment.