?
Solved

getString() is truncating my varchar from recordset

Posted on 2003-03-06
6
Medium Priority
?
492 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Hey fellow admins! This time, I have a little fairy tale for you. As many tales do, it starts boring and then gets pretty gory. I hope you like it. TL;DR: It is about an important security matter, you should read it if you run or administer Windows …
The top devops trends for 2017 are focused on improved deployment frequency, decreased lead time for change and decreased MTTR.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month10 days, 1 hour left to enroll

762 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