Posted By: medved (A~z na v~eky Mikov~ce.) on 'CZdatabases'
Title:     Re: Sybase, Java, BLOB-y - jo
Date:      Mon May 22 19:49:43 2000

>      Ave!
> 
>    Ako vyplyva zo $SUBJ, zaujimalo by ma, ci mate niekto skusenosti s
> pouzitim 
> BLOBov v databazi Sybase cez rozhranie JDBC. Nemam Sybase moznost vyskusat, 
> ale mozno ju budem musiet nasadit, a BLOBy cez JDBC su dolezity faktor pri 
> rozhodovani.

Cituji z manualu k jConnectu (Sybase JDBC driver):

... jConnect 4.0 introduces a TextPointer class with sendData( ) methods for 
updating an image column in an Adaptive Server Enterprise or Adaptive Server 
Anywhere database. In earlier versions of jConnect, you had to send image 
data using the setBinaryStream( ) method in java.sql.PreparedStatement. The 
TextPointer.sendData( ) methods use java.io.InputStream and greatly improve 
performance when you send image data to an Adaptive Server database.

A protoze uz mame jConnect 5.2... 

>    Totiz napr. PostgreSQL cez JDBC pracu s BLOBmi neumoznuje, hoci inak ju v
> pohode zvlada (myslim verzie <6 - 7 som este netestoval). A nerad by som na 
> tento problem narazil aj u Sybase.
> 
> Crazy.

Bye

Medved

Si vis pacem, para bellum.