[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

getString() is truncating my varchar from recordset

Posted on 2003-03-06
6
Medium Priority
?
498 Views
Last Modified: 2010-04-01
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.
0
Comment
Question by:ants_4_t
6 Comments
 
LVL 1

Expert Comment

by:umangjoshi
ID: 8079016
use clob inseted of varchar
0
 
LVL 3

Expert Comment

by:NetWize
ID: 8079607
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.
0
 

Author Comment

by:ants_4_t
ID: 8080198
I've managed to solve the problem. The driver I was using was SQL7 compatible. Oops. All sort now.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
LVL 19

Expert Comment

by:cheekycj
ID: 8081645
Would you like this question PAQd and your pts refunded?

CJ
0
 

Author Comment

by:ants_4_t
ID: 8333848
Yes, if i could
0
 
LVL 1

Accepted Solution

by:
Cerebro earned 0 total points
ID: 8334101
Refunding Pts and moving to PAQ.

Cerebro
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
The PowerShell Core 6.0 of .NET release is just the beginning. The upcoming PowerShell Core 6.1 would have artificial intelligence and internet of things capabilities. So many things to look forward to in the upcoming release.
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Is your organization moving toward a cloud and mobile-first environment? In this transition, your IT department will encounter many challenges, such as navigating how to: Deploy new applications and services to a growing team Accommodate employee…
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question