Have you tried using a blob instead ??
William
Ravi T wrote:
> HI,
>
> For you information the data type of the column in my SQL server database is
> "varchar" of size "8000".
>
> Thank you,
> Ravi.
>
> >From: Thomas To <[EMAIL PROTECTED]>
> >Reply-To: "A mailing list for discussion about Sun Microsystem's Java
> > Servlet API Technology." <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Re: Reading a large string.
> >Date: Tue, 2 Nov 1999 18:05:26 -0800
> >
> >I believe the max size of varchar for SQL server is 255.
> >
> >- Thomas -
> >
> >Ravi T wrote:
> > >
> > > Hi Jacek,
> > >
> > > I tried even the following method still it didn't worked.
> > > String xyz = rset.getString("col_name");
> > >
> > > Iam using Weblogic's type 4 jdbc driver of version 4.5
> > > My problem is still unsolved. If you've any alternative suggestions then
> > > please let me know.
> > >
> > > Thanks,
> > > Ravi.
> > >
> > > >From: "Wuwer, Jacek M." <[EMAIL PROTECTED]>
> > > >Reply-To: "A mailing list for discussion about Sun Microsystem's Java
> > > > Servlet API Technology." <[EMAIL PROTECTED]>
> > > >To: [EMAIL PROTECTED]
> > > >Subject: Re: Reading a large string.
> > > >Date: Tue, 2 Nov 1999 08:04:25 -0800
> > > >
> > > >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
> > > >
> > >
> > > ______________________________________________________
> > > 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
> >
>
> ______________________________________________________
> 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
