Thanks, Alfred. That's what I eventually did. But I'm still surprised that I can't find a way to do it with ESQL. For example, there is no problem to insert a CLOB field.
One of the EQSL advantages is that you don't need to mass with Context lookup and connections Eitan -----Original Message----- From: Alfred Nathaniel [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 1:45 AM To: [email protected] Subject: Re: Using ESQL to insert binary data into BLOB filed usingInputStream On Tue, 2006-12-26 at 04:06 -0800, Eitan Ben-Noach wrote: > I would like to insert a file content (binary) into a BLOB field in my > database (oracle ) using the file InputStream. > > Something that is analogous to java.sql.PreparedStatement. > setBinaryStream(); ESQL is a great tool for ad-hoc queries but for database updates I'd recommend you to encapsulate it in a separate Java class. Cheers, Alfred. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
