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.

About the max stream length by using getBytes() or getBinaryStream().

2 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-08-14 15:19:25.0Z
Hong Chen Posted on 1997-08-14 14:19:51.0Z
Message-ID: <33F31407.1CEE5B9C@lincom-asg.com>
Date: Thu, 14 Aug 1997 09:19:51 -0500
From: Hong Chen <chenh@lincom-asg.com>
X-Mailer: Mozilla 4.01 [en] (WinNT; I)
MIME-Version: 1.0
Subject: About the max stream length by using getBytes() or getBinaryStream().
X-Priority: 3 (Normal)
Content-Type: multipart/alternative; boundary="------------46C3451AABF9DC503104F1F5"
Newsgroups: sybase.public.jdbcconnect
Lines: 46
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:378
Article PK: 252130

When I tried to retrieve image file from Sybase using getBytes() or getBinaryStream() method in jConnect, I couldn't get the whole image data which is greater than 32,768 bytes. In other word, when the length of the image data is greater than 32,768, I just could get 32,768 bytes.
Would you please telling me the reason?

My configuration:
 

  • Windows NT
  • JDK 1.1.3
  • jConnect Beta3 installed on the server machine
  • client machine does include the necessary classes such as "com" directory , "uk" directory and also the classpath has been set to the JDK1.1.3 and jConnect classes
  • Netscape Communicator and appletviewer

Please help!
Thanks,

chenh@lincom-asg.com


Lance Andersen Posted on 1997-08-14 15:19:25.0Z
Message-ID: <33F321FD.7CF@sybase.com>
Date: Thu, 14 Aug 1997 11:19:25 -0400
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 3.01Gold (X11; I; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: Hong Chen <chenh@lincom-asg.com>
Subject: Re: About the max stream length by using getBytes() or getBinaryStream().
References: <33F31407.1CEE5B9C@lincom-asg.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 37
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:377
Article PK: 252129

Hong,

You need to execute the command set textsize ###

once you open the connection to increase the default > 32k.

Please refer to the SQL Server Reference manual Volume 1 and
look up the syntax for the set command for further details.

regards,

-lance

Hong Chen wrote:
>
> When I tried to retrieve image file from Sybase using getBytes() or
> getBinaryStream() method in jConnect, I couldn't get the whole image
> data which is greater than 32,768 bytes. In other word, when the
> length of the image data is greater than 32,768, I just could get
> 32,768 bytes.
> Would you please telling me the reason?
>
> My configuration:
>
>
> * Windows NT
> * JDK 1.1.3
> * jConnect Beta3 installed on the server machine
> * client machine does include the necessary classes such as "com"
> directory , "uk" directory and also the classpath has been set to
> the JDK1.1.3 and jConnect classes
> * Netscape Communicator and appletviewer
>
> Please help!
> Thanks,
>
> chenh@lincom-asg.com

--
===============================================================================
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!!!
===============================================================================