Re: MySQL longblob
Konstantin Ignatyev <[email protected]> Mon, 8 Apr 2002 07:45:52 -0700 (PDT)
| Newsgroups | gmane.comp.java.ejb.general |
|---|---|
| Message-ID | <[email protected]> |
Couple of years ago I used getBinaryStream() with pure JDBC successfully. I would guess CMP does not work with BLOB very well. Why do not try BMP in the case? --- niksa_os <[email protected]> wrote: > I have CMP EJB and I don't know what class to use > for MySQL longblob mapping? > This will be deployed to WebLogic and BES5 > (Borland). > I try for WebLogic with java.sql.Blob and for BES > byte[], like documents said, but this doesn't work > for me. > > I just know that I must deliver something that > servlet developer can cast to byte[]. > > Any suggestion (anyone) how to map this column? > > P.S. Sorry Ahmed I didn't explain better ;) > ----- Original Message ----- > From: Aboul-Enein, Ahmed A > To: [email protected] > Sent: Sunday, April 07, 2002 5:31 PM > Subject: RE: [EJB-Developer] MySQL longblob > > > > The following is valid for BLOB, I believe it > should work for longblob also. > > If your JDBC driver is JDBC 2 compliant, try > calling... > 1. BLOB ResultSet#getBlob(String colName) > then > 2. byte[] BLOB#getBytes(long pos, int length) > > Apologies if this did not work, please let me > know if it worked or not for you. > > Yours, Ahmed > __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/