(Embedded image moved to file: pic02324.pcx)
Fred So@SENTOR
(Embedded image moved to file: pic24508.pcx)
16/03/99 16:23
(Embedded image moved to file: pic16937.pcx)
To: "A mailing list for discussion about Sun Microsystem's Java Servlet API
Technology." <[EMAIL PROTECTED]>
cc:
Subject: Re: UPDATE a DB with Binary Data
You need to use praprareStatement and then use setBinaryStream.
> Hi,
>
> I use a servlet to UPDATE a BD (mySQL) trough JDBC . All works fine with SQL
> strings like : INSERT INTO table1 (id_pais,link,descripcio) VALUES (1,"a
> link","a description")
> But now, I want to INSERT into the DB a BLOB FIELD with BINARY DATA (really
> is the data of a JPG file).
> I can't make a SQLstring with binary data for the executeQuery(String)
> method of my Statement.
> How can I solve that ?
>
pic02324.pcx
pic24508.pcx
pic16937.pcx