±Û¾´ÀÌ :¹é½Â¿ë 1998³â 4¿ù 02ÀÏ 14:04:51
In Reply to: [Áú¹®]jdbcÀÇ setBinaryStram() & getBinaryStream() ?? posted by ¹é½Â¿ë on 1998³â 4¿ù 01ÀÏ 17:24:13:
DBÀÇ LONG RAW ÇüÀÇ Çʵ忡 µ¥ÀÌŸ¸¦ ³Ö±â À§ÇØ
InputStreamÇüÀÇ µ¥ÀÌŸ·Î º¯È¯ÇÏ¿© Å×½ºÆ®¸¦ Çغôµ¥
¾ÈµÇ´Â ±º¿ä! ¿À¶óŬ ¿¡·¯ ¸Þ¼¼Áö´Â 'Inconsistent Datatype'
À̶ó´Â ¸Þ¼¼Áö°¡ ³ª¿É´Ï´Ù.
¹» À߸øÇÑ °ÍÀϱî¿ä? ¾Æ´Ï¸é ´Ù¸¥ ÀÌÀ¯¶§¹®Àΰ¡¿ä?
<¿¹>
String filecontent ... // ÀÌ º¯¼ö¿¡´Â ÈÀÏÀÇ ³»¿ëÀÌ µé¾î°¡ ÀÖ½¿.
byte[] b = new byte[filecontent.length()];
filecontent.getBytes(0, filecontent.length(), b, 0);
/* Test ¹æ¹ý ¿°Å */
¨çInputStream in = new ByteArrayInputStream(b);
¨èInputStream in = new StringBufferInputStream(filecontent);
¨éÈÀÏÀÇ ³»¿ëÀ» ÈÀÏ¿¡ ÀúÀåÇÑ ´ÙÀ½ ÈÀÏÀ» FileInputStreamÀ¸·Î Àоî
DB¿¡ ÀúÀåÇÏ´Â ¹æ¹ý
FileInputStream in = new FileInputStream("FILENAME");
¨êÀ§ÀÇ ¹æ¹ýµéÀ» »õ·Î »ý¼ºÇÏ´Â ¿ÀºêÁ§Æ®¿Í °°Àº
ÇüÀ¸·Î ¼±¾ðÇÑ ´ÙÀ½ InputStreamÇüÀ¸·Î Casting ÇÏ´Â
¹æ¹ý
...................
pstmt.setBytes(1, in, filecontent.length());
À§ÀÇ ¹æ¹ýÀ» ¾²¸é ¶È°°ÀÌ 'Inconsistent Datatype' ¿¡·¯ ¸Þ¼¼Áö°¡
³ª¿É´Ï´Ù.
À§ÀÇ ¹æ¹ý¿Ü¿¡ setBytes()¸¦ ¾²¸é ÅؽºÆ®¸ðµå ÇüÅÂÀÇ
ÀÛÀº ÈÀÏÀº ÀúÀåÀÌ µÇ³ª ImageµîÀÇ Å« ÈÀÏÀº ´ÙÀ½°ú
°°Àº ¸ÞÁ¦Áö°¡ µð½ºÇ÷¹ÀÌ µË´Ï´Ù.
<¸Þ¼¼Áö>
'No more to read data from socket'
´Ù½Ã ½ÃµµÇϸé
'Broken pipe'
============================================================
»ê ³Ñ¾î »êÀÔ´Ï´Ù. ³Ñ¾î¾ß ÇÒ »êÀÌ ³Ê¹« ¸¹½À´Ï´Ù.
Áñ°Å¿î ÇÏ·ç°¡ µÇ½Ê½Ã¿ä!