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.

BLOBs via jConnect.

2 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-10-02 21:29:34.0Z
Gene Smith Posted on 1997-10-02 17:36:50.0Z
Message-ID: <3433DBB1.C150CF25@bellhow.com>
Date: Thu, 02 Oct 1997 13:36:50 -0400
From: Gene Smith <gene@bellhow.com>
Reply-To: gene@bellhow.com
Organization: Bell+Howell
X-Mailer: Mozilla 4.0 [en] (WinNT; I)
MIME-Version: 1.0
Subject: BLOBs via jConnect.
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 9
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:200
Article PK: 251951

Has anyone successfully inserted BLOBs into SSA, greater than 32K, via
jConnect. If so please give me a code snippet of how to do it.
Obviously the standard method of setBytes() doesn't work and I've also
tried the ASCII hex string method but it just gives me back the ASCII
hex string when I read the BLOB back from the table.

Gene


David Lance Wolf Posted on 1997-10-02 21:29:34.0Z
Message-ID: <3434123E.E0126200@sybase.com>
Date: Thu, 02 Oct 1997 14:29:34 -0700
From: David Lance Wolf <dwolf@sybase.com>
Organization: Sybase Professional Services
X-Mailer: Mozilla 4.02 [en] (Win95; I)
MIME-Version: 1.0
Subject: Re: BLOBs via jConnect.
References: <3433DBB1.C150CF25@bellhow.com>
Content-Type: multipart/mixed; boundary="------------7519D52EF3456A9E94BC580A"
Newsgroups: sybase.public.jdbcconnect
Lines: 38
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:199
Article PK: 251954

Gene-

I havent tried it, but I know the ODBC programmers would chunk up the
data. They'd insert the first say 30K. The issues updates to
concatenate on the remaining chunks.

Sorry, I dont have a sample though. Maybe I'll give it a shot if I get
a chance.

Dave Wolf
Sybase Professional Services

Gene Smith wrote:
>
> Has anyone successfully inserted BLOBs into SSA, greater than 32K, via
> jConnect. If so please give me a code snippet of how to do it.
> Obviously the standard method of setBytes() doesn't work and I've also
> tried the ASCII hex string method but it just gives me back the ASCII
> hex string when I read the BLOB back from the table.
>
> Gene


Download VCard vcard.vcf