<div>
&gt;&gt; I am closing<br />
my statement and resultset <br />
<br />
Aren't you closing the ResultSet after *every* query?
</div>


>> I am closing
my statement and resultset

Aren't you closing the ResultSet after *every* query?

<div>
THANKS objects for the link. &nbsp;I think my problem may be related to that; &nbsp; however, I'm certain that my resultset and statement<br />
objects are being closed. &nbsp;It does seem to happen around 15 or 16 queries to Teradata though. <br />
<br />
Still looking - any ideas??
</div>


THANKS objects for the link.  I think my problem may be related to that;   however, I'm certain that my resultset and statement
objects are being closed.  It does seem to happen around 15 or 16 queries to Teradata though.

Still looking - any ideas??

<div>
Your link was helpful in analyzing the problem. &nbsp;<br />
I added LOB_SUPPORT=OFF as part of the Teradata connection URL.
</div>


Your link was helpful in analyzing the problem.  
I added LOB_SUPPORT=OFF as part of the Teradata connection URL.

<div>
<div class="content wysiwyg-content">
I'm getting an error message ...<br />
<br />
Caused by: com.ncr.teradata.jdbc_4.ut<wbr />il.JDBCExc<wbr />eption: [NCR] [Teradata DBMS] : Response limit exceeded.<br />
<br />
I'm only returning about 40,000 rows. &nbsp;It seems to happen after several successful queries to Teradata. &nbsp;I am closing<br />
my statement and resultset and returning the connection back to the pool (all in that order in a finally statement). &nbsp;So, I'm<br />
not sure why I'm getting this response limit exceeded error message. &nbsp;Any ideas??<br />
<br />
Thanks<br />

</div>
</div>


I'm getting an error message ...

Caused by: com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata DBMS] : Response limit exceeded.

I'm only returning about 40,000 rows.  It seems to happen after several successful queries to Teradata.  I am closing
my statement and resultset and returning the connection back to the pool (all in that order in a finally statement).  So, I'm
not sure why I'm getting this response limit exceeded error message.  Any ideas??

Thanks


Response limit exceeded

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.