The approach of just using ps.setBlob(actualBlobObject) in the original insert has the limit of 4k.
The code in my sample (inserting record with empty BLOB, selecting for update, get pointer to BLOB, and write byte stream to that) will work for bigger files. I think the first approach above is what the original poster was referring to? -----Original Message----- From: Christian Bollmeyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 12:01 PM To: Struts Users Mailing List Subject: Re: converting a FormFile to a Blob object Am Dienstag, 23. Dezember 2003 17:12 schrieb Ebersole, Steven: > FWIW, that approach will work as long as the data is not larger then > the limit (which escapes me at the moment, but I believe its > something like 4K). No? Admitting we didn't actually test with file sizes beyond 150MB. -- Chris. Btw, Mr. Nicholson's code sample uses the same approach. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
