🚀 go-pugleaf

Hi,

To insert BLOBs you need to use the PreparedStatement interface -
prepare a statement, then fill the parameters and call Execute.


--

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> I need to introduce an InputStream coming from an attachment of a mail
> message in a type field BLOB, but it is I impossible. Could they help me?
> This code this well?
>
> filename=parte.getFileName();
> streamFichero=parte.getInputStream();
>             try
>             {
>             inserta="INSERT INTO ANEXOS (NUM,ANEXO,NOMBRE) VALUES
> ("+indice_anexo+","+streamFichero+",'"+filename+"')";
>
>             insertar.execute(inserta); insertar.execute("COMMIT");
>             }
>             catch (SQLException c)
>             {
>               error(c.getMessage());
>             }
>
> Thank you
>
>