RE: JDBC stmt.set.BinaryStream and stmt.setBytes (repost)

Posted in 2000

Sebastien THOMAS — Tue, 31 Oct 2000 16:53:41 +0100 (MET) — source: Informix-list mailing list archive (1991-1998)

On Tue, 31 Oct 2000, Daniel Bonesana wrote: > Date: Tue, 31 Oct 2000 09:51:09 -0300 > From: Daniel Bonesana <Daniel.Bonesana@siemens-itron.com.ar> > To: Sebastien THOMAS <Sebastien.THOMAS@none.net>, informix-list@iiug.org > Subject: RE: JDBC stmt.set.BinaryStream and stmt.setBytes (repost) > > Hi ! > >From page 3-76,77 of the I JDBC Driver - Prog. Guide > there seams to be a recommendation to use one method or the other > depending on the data type you operate upon > yours Thanks for your reply. I've found something in the documentation : Infor;ix JDBC driver 2.0 : programmer's guide, page 3-80 : getBytes is for byte and blob getAsciistream is for cblob, text and lvarchar getBinarystream is for boolean, blob and byte So, It seems we are using something not compatible with text format with a text formated row. So what is the main difference that make it work ? I've not been able to find anything in the JDBC doc v1.4 There is no 1.5 doc. As we use JDBC v1.5, what is supported and what is not ? > > > N. Daniel Bonesana > > SIEMENS-ITRON BUSINESS SERVICES S.A. > > Balcarce 683, (C1064AAM) Buenos Aires, Argentina. > > * 54 (11) 4320-5456 * Daniel.Bonesana@siemens-itron.com.ar > > > > > > > -----Original Message----- > From: Sebastien THOMAS [mailto:Sebastien.THOMAS@none.net] > Sent: Tuesday, October 31, 2000 6:58 AM > To: informix-list@iiug.org > Subject: JDBC stmt.set.BinaryStream and stmt.setBytes (repost) > > > Hi, > > As far as I've been, I haven't been able to find a real difference > between stmt.set.BinaryStream and stmt.setBytes in a java query to a IDS > > 2000 server (9.20) on Solaris 2.6. > I've gone through th Informix JDBC Driver's programmer's guide, without > finding anything. > It seems both are working. Maybe one of this function is newser or > faster to run ? > Maybe the connection to the database or the lock lever is not the same ? > > any clue ? > > -- > _______________________________________________ > Sebastien THOMAS none networks > System Engineer freesbee > > geo:153, rue Saint-Denis, 75002 Paris, France > vox:+33 1 45 08 23 10 - fax:+33 1 45 08 25 29 > mailto:sebastien.thomas@none.net > > _______________________________________________ Sebastien THOMAS none networks System Engineer freesbee geo:153, rue Saint-Denis, 75002 Paris, France vox:+33 1 45 08 23 10 - fax:+33 1 45 08 25 29 mailto:sebastien.thomas@none.net