Hi,
I think it heavily depends on the JDBC driver you're using. I'm actually
inserting such a filed in my servlet by calling a stored procedure - it gets
retrieved later through ODBC. I'm using an older WebLogic type 2 driver and
MSSQL 7.0.
Have you tried String buf = rset.getString( your_column_id ) ?
Again, it may be your driver limitations, earlier versions of MSSQl
supported only up to 256 character in varchar.
Jacek
> -----Original Message-----
> From: Ravi T [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, November 02, 1999 00:48
> To: [EMAIL PROTECTED]
> Subject: Reading a large string.
>
> Hi all,
>
> My problem might be a bit off-topic please don't mind.
>
> In one of my servlets Iam using JDBC to access SQLServer7.0.
> One of the tables in the database had a column whose data type is varchar
> of
> size 8000.
> When Iam trying to retrieve the value of this column Iam getting the value
> only of the first 255 characters. Iam using the following method to
> retrieve
> the value of this field.
>
> BufferedReader reader=new BufferedReader(new
> InputStreamReader(rst.getBinaryStream(1)),4000);
> String in=reader.readLine();
> while(in != null)
> {
> sout.println(in);
> in=reader.readLine();
> }
>
> If anyone had a solution to retrieve the whole string stored in that field
> in the database then please let me know that solution.
>
> Thanks in advance,
> Ravi Kumar.
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
> __________________________________________________________________________
> _
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
