Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

text field >32768

2 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-04-30 14:03:00.0Z
Denys CHAUME Posted on 1997-04-30 10:05:23.0Z
Message-ID: <33671963.41C6@cnusc.fr>
Date: Wed, 30 Apr 1997 12:05:23 +0200
From: Denys CHAUME <Denys.Chaume@cnusc.fr>
X-Mailer: Mozilla 3.01Gold (X11; I; AIX 1)
MIME-Version: 1.0
Subject: text field >32768
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 11
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:897
Article PK: 252648

Hello !

I have some problems to read text field with length greater than
32768. The data is truncated.

I am using the jConnect trial version 2.1. and JDK 1.1 on AIX.

I tried to use the Statement.setMaxFieldSize but I have got a
SQLException :

"This class method has not been completed and should
not be called. : setMaxFieldSize "

Who can help me !

Thanks,

Denys


Lance Andersen Posted on 1997-04-30 14:03:00.0Z
Message-ID: <33675114.7234@sybase.com>
Date: Wed, 30 Apr 1997 10:03:00 -0400
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 3.01Gold (X11; I; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: Denys CHAUME <Denys.Chaume@cnusc.fr>
Subject: Re: text field >32768
References: <33671963.41C6@cnusc.fr>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 28
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:896
Article PK: 252647

Hi,

The default size of text returned by t-sql is 32k.

Use the t-sql 'set textsize' command to change this value.

Please refer to the t-sql reference manual volume 1 for
more details.


-lance

Denys CHAUME wrote:
>
> Hello !
>
> I have some problems to read text field with length greater than
> 32768. The data is truncated.
>
> I am using the jConnect trial version 2.1. and JDK 1.1 on AIX.
>
> I tried to use the Statement.setMaxFieldSize but I have got a
> SQLException :
>
> "This class method has not been completed and should
> not be called. : setMaxFieldSize "
>
> Who can help me !
>
> Thanks,
>
> Denys

--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Technical Support Phone:(617) 564-6336
77 South Bedford Street Fax: (617) 564-6148
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================