<div>
use clob inseted of varchar
</div>


<div>
if you can't change the database to clob as umangjoshi is advising, you could try to use the<br />
<br />
ResultSet.getBytes() or<br />
ResultSet.getAsciiStream()<wbr /><br />
<br />
for retrieving large varchar values.
</div>


if you can't change the database to clob as umangjoshi is advising, you could try to use the

ResultSet.getBytes() or
ResultSet.getAsciiStream()

for retrieving large varchar values.

<div>
I've managed to solve the problem. The driver I was using was SQL7 compatible. Oops. All sort now.
</div>


I've managed to solve the problem. The driver I was using was SQL7 compatible. Oops. All sort now.

<div>
Would you like this question PAQd and your pts refunded?<br />
<br />
CJ
</div>


Would you like this question PAQd and your pts refunded?

CJ

<div>
<div class="content wysiwyg-content">
I am trying to output a storedprocedure which returns a record fine. When I try outputting a varchar it on my JSP page I am using getString(). It seems to be truncating it around 256 characters.
</div>
</div>


I am trying to output a storedprocedure which returns a record fine. When I try outputting a varchar it on my JSP page I am using getString(). It seems to be truncating it around 256 characters.

getString() is truncating my varchar from recordset

JavaServer Pages (JSP) allow the development of dynamically generated web pages. It uses the Java programming language; JSP pages are translated into servlets at runtime, with each servlet being cached and reused until the JSP is modified. JSP allows Java code to be interleaved with static web markup content, so the resulting page can be compiled and executed on the server to deliver the content.