RE: MySQL longblob
"Aboul-Enein, Ahmed A" <[email protected]> Sun, 7 Apr 2002 16:31:26 +0100
| Newsgroups | gmane.comp.java.ejb.general |
|---|---|
| Message-ID | <4DCE4850399BD511AE980002A58717FE25ED54@EGCRM201> |
------_=_NextPart_001_01C1DE49.4825CBE0 Content-Type: text/plain; charset="iso-8859-1" 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 -----Original Message----- From: niksa_os [mailto:[email protected]] Sent: Sunday, April 07, 2002 1:38 PM To: [email protected] Subject: [EJB-Developer] MySQL longblob I have in MySQL longblob column. I need this longblob in servlet like byte[]. Any suggestion how to do this? Yahoo! Groups Sponsor ADVERTISEMENT <http://rd.yahoo.com/M=178320.1964497.3448863.1261774/D=egroupweb/S=17050069 05:HM/A=879171/R=0/*http://www.fastweb.com/ib/yahoo-57f> <http://us.adserver.yahoo.com/l?M=178320.1964497.3448863.1261774/D=egroupmai l/S=1705006905:HM/A=879171/rand=591726535> EJB-Developer group email addresses: Post message: [email protected] Subscribe: [email protected] Unsubscribe: [email protected] List owner: [email protected] Our other technical discussion groups: - For general Java (J2EE) questions/answers: http://groups.yahoo.com/group/Java_Developer <http://groups.yahoo.com/group/Java_Developer> - For peer-to-peer software development discussion: http://groups.yahoo.com/group/P2P-Developer <http://groups.yahoo.com/group/P2P-Developer> Web link to the EJB-Developer group: http://groups.yahoo.com/group/EJB-Developer <http://groups.yahoo.com/group/EJB-Developer> ATTENTION: You are receiving this message because you actively subscribed to the EJB-Developer technical discussion group on Yahoo! Groups. All subscriptions come from Yahoo-verified email addresses and are logged, thereby provable. To unsubscribe, send a blank email from the email address receiving group messages to the 'Unsubscribe' email address shown above. If this doesn't work, send a message concerning this problem to [email protected]. Only Yahoo! Groups is responsible for their own subscription services; the moderator will not perform these services at any time. *** EJB-Developer - A free service brought to you by Democracy 2.0 (www.democracy2.org) *** Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service. ------_=_NextPart_001_01C1DE49.4825CBE0 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: 7bit <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 5.00.3315.2870" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <BLOCKQUOTE> <DIV align=left class=OutlookMessageHeader dir=ltr><BR><FONT size=2><FONT color=#0000ff face=Tahoma><SPAN class=187221615-07042002>The following is valid for BLOB, I believe it should work for longblob also.</SPAN></FONT></FONT></DIV> <DIV align=left class=OutlookMessageHeader dir=ltr><FONT size=2><FONT color=#0000ff face=Tahoma><SPAN class=187221615-07042002></SPAN></FONT></FONT> </DIV> <DIV align=left class=OutlookMessageHeader dir=ltr><FONT size=2><FONT color=#0000ff face=Tahoma><SPAN class=187221615-07042002></SPAN></FONT></FONT><FONT size=2><FONT color=#0000ff face=Tahoma><SPAN class=187221615-07042002>If your JDBC driver is JDBC 2 compliant, try calling...</SPAN></FONT></FONT></DIV> <DIV align=left class=OutlookMessageHeader dir=ltr><FONT size=2><FONT color=#0000ff face=Tahoma><SPAN class=187221615-07042002>1. BLOB ResultSet#getBlob(String colName)</SPAN></FONT></FONT></DIV> <DIV align=left class=OutlookMessageHeader dir=ltr><FONT size=2><FONT color=#0000ff face=Tahoma><SPAN class=187221615-07042002>then</SPAN></FONT></FONT></DIV> <DIV align=left class=OutlookMessageHeader dir=ltr><FONT size=2><FONT color=#0000ff face=Tahoma><SPAN class=187221615-07042002>2. byte[] BLOB#getBytes(long pos, int length)</SPAN></FONT></FONT></DIV> <DIV align=left class=OutlookMessageHeader dir=ltr><FONT size=2><FONT color=#0000ff face=Tahoma><SPAN class=187221615-07042002></SPAN></FONT></FONT> </DIV> <DIV align=left class=OutlookMessageHeader dir=ltr><FONT size=2><FONT color=#0000ff face=Tahoma><SPAN class=187221615-07042002>Apologies if this did not work, please let me know if it worked or not for you.</SPAN></FONT></FONT></DIV> <DIV align=left class=OutlookMessageHeader dir=ltr><FONT size=2><FONT color=#0000ff face=Tahoma><SPAN class=187221615-07042002></SPAN></FONT></FONT> </DIV> <DIV align=left class=OutlookMessageHeader dir=ltr><FONT size=2><FONT color=#0000ff face=Tahoma><SPAN class=187221615-07042002>Yours, Ahmed</SPAN></FONT></FONT></DIV> <DIV align=left class=OutlookMessageHeader dir=ltr><FONT size=2><FONT color=#0000ff face=Tahoma><SPAN class=187221615-07042002></SPAN></FONT></FONT> </DIV> <DIV align=left class=OutlookMessageHeader dir=ltr><FONT size=2><FONT face=Tahoma><SPAN class=187221615-07042002> </SPAN>-----Original Message-----<BR><B>From:</B> niksa_os [mailto:[email protected]]<BR><B>Sent:</B> Sunday, April 07, 2002 1:38 PM<BR><B>To:</B> [email protected]<BR><B>Subject:</B> [EJB-Developer] MySQL longblob<BR><BR></DIV></FONT></FONT> <DIV><FONT face=Arial size=2>I have in MySQL longblob column. I need this longblob in servlet like byte[].</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>Any suggestion how to do this?</FONT></DIV><BR><BR><TT>EJB-Developer group email addresses:<BR> Post message: [email protected]<BR> Subscribe: [email protected]<BR> Unsubscribe: [email protected]<BR> List owner: [email protected]<BR><BR>Our other technical discussion groups:<BR>- For general Java (J2EE) questions/answers: <A href="http://groups.yahoo.com/group/Java_Developer">http://groups.yahoo.com/group/Java_Developer</A><BR>- For peer-to-peer software development discussion: <A href="http://groups.yahoo.com/group/P2P-Developer">http://groups.yahoo.com/group/P2P-Developer</A><BR><BR>Web link to the EJB-Developer group:<BR> <A href="http://groups.yahoo.com/group/EJB-Developer">http://groups.yahoo.com/group/EJB-Developer</A><BR><BR>ATTENTION: You are receiving this message because you actively subscribed to the EJB-Developer technical discussion group on Yahoo! Groups. All subscriptions come from Yahoo-verified email addresses and are logged, thereby provable. To unsubscribe, send a blank email from the email address receiving group messages to the 'Unsubscribe' email address shown above. If this doesn't work, send a message concerning this problem to [email protected]. Only Yahoo! Groups is responsible for their own subscription services; the moderator will not perform these services at any time.<BR><BR>*** EJB-Developer - A free service brought to you by Democracy 2.0 (www.democracy2.org) ***</TT> <BR><BR><TT>Your use of Yahoo! Groups is subject to the <A href="http://docs.yahoo.com/info/terms/">Yahoo! Terms of Service</A>.</TT> <BR></BLOCKQUOTE> <br> <!-- |**|begin egp html banner|**| --> <table border=0 cellspacing=0 cellpadding=2> <tr bgcolor=#FFFFCC> <td align=center><font size="-1" color=#003399><b>Yahoo! Groups Sponsor</b></font></td> </tr> <tr bgcolor=#FFFFFF> <td align=center width=470><table border=0 cellpadding=0 cellspacaaing=0> <tr> <td align=center><font face=arial size=-2>ADVERTISEMENT</font><br><a href="http://rd.yahoo.com/M=178320.1964497.3448863.1261774/D=egroupweb/S=1705006905:HM/A=879171/R=0/*http://www.fastweb.com/ib/yahoo-57f"><img src="http://us.a1.yimg.com/us.yimg.com/a/fa/fastweb/300x250.gif" alt="" width="300" height="250" border="0"></a></td> </tr> </table></td> </tr> <tr><td><img alt="" width=1 height=1 src="http://us.adserver.yahoo.com/l?M=178320.1964497.3448863.1261774/D=egroupmail/S=1705006905:HM/A=879171/rand=304632143"></td></tr> </table> <!-- |**|end egp html banner|**| --> <br> <tt> EJB-Developer group email addresses:<BR> Post message: [email protected]<BR> Subscribe: [email protected]<BR> Unsubscribe: [email protected]<BR> List owner: [email protected]<BR> <BR> Our other technical discussion groups:<BR> - For general Java (J2EE) questions/answers: <a href="http://groups.yahoo.com/group/Java_Developer">http://groups.yahoo.com/group/Java_Developer</a><BR> - For peer-to-peer software development discussion: <a href="http://groups.yahoo.com/group/P2P-Developer">http://groups.yahoo.com/group/P2P-Developer</a><BR> <BR> Web link to the EJB-Developer group:<BR> <a href="http://groups.yahoo.com/group/EJB-Developer">http://groups.yahoo.com/group/EJB-Developer</a><BR> <BR> ATTENTION: You are receiving this message because you actively subscribed to the EJB-Developer technical discussion group on Yahoo! Groups. All subscriptions come from Yahoo-verified email addresses and are logged, thereby provable. To unsubscribe, send a blank email from the email address receiving group messages to the 'Unsubscribe' email address shown above. If this doesn't work, send a message concerning this problem to [email protected]. Only Yahoo! Groups is responsible for their own subscription services; the moderator will not perform these services at any time.<BR> <BR> *** EJB-Developer - A free service brought to you by Democracy 2.0 (www.democracy2.org) ***</tt> <br> <br> <tt>Your use of Yahoo! Groups is subject to the <a href="http://docs.yahoo.com/info/terms/">Yahoo! Terms of Service</a>.</tt> </br> </BODY></HTML> ------_=_NextPart_001_01C1DE49.4825CBE0--