Derbyã?®ãƒãƒƒã‚¯æ©Ÿæ§‹(共有ãƒãƒƒã‚¯)ã?«ã?¦ã€?java.sql.Blobã‚„java.sql.Clobã?ŒæŒ‡ã?—示ã?™ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã?®æƒ…å ±ã?®æ›´æ–°ã‚„削除ã?¯é˜²ã?Œã‚Œã?¦ã?„ã?¾ã?™ã€‚ ã?—ã?‹ã?—ã?ªã?Œã‚‰ã€?Derbyã?®å?³æ™‚ãƒãƒƒã‚¯ã?®æ©Ÿæ§‹ã?¯ã€?java.sql.Blobã‚„java.sql.Clobã?«å¯¾å¿œã?™ã‚‹åˆ—ã?Œå®ˆã‚‰ã‚Œã?¦ã?„ã?ªã?„瞬間ã?®å˜åœ¨ã‚’許ã?™ã?“ã?¨ã?Œã?‚りã?¾ã?™ã€‚ 引ã??ç¶šã??getBlob/getClobã?Šã‚ˆã?³java.sql.Blob/java.sql.Clobã?®å‘¼ã?³å‡ºã?—ã?¯æœªå®šç¾©ã?ªæŒ¯ã‚‹èˆžã?„ã‚’èµ·ã?“ã?™å?¯èƒ½æ€§ã?Œã?‚りã?¾ã?™ã€‚
ã?•らã?«java.sql.Blob/java.sql.Clobã‚’æŒ?ã?¤ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã?Œã€?(ä»–ã?®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã?«å¯¾ã?—ã?¦)ã€?対応行を更新ã?™ã‚‹ã?“ã?¨ã‚’防ã??機構ã?¯ã?‚りã?¾ã?›ã‚“。(ã?“ã?®å•?題ã?¯getXXXStreamメソッドã?«ã‚‚å˜åœ¨ã?—ã?¦ã?„ã?¾ã?™ã€‚) java.sql.Blob/java.sql.Clobã?Œé–‹ã?„ã?¦ã?„ã?¦ã?Šã‚Šã€?アプリケーションプãƒã‚°ãƒ©ãƒ ã?«ã?¦å¯¾å¿œã?™ã‚‹æƒ…å ±ã?®æ›´æ–°ã?Œå¦¨ã?’られã?Ÿå ´å?ˆã€?失敗ã?—ã?Ÿã?“ã?¨ã?«ã‚ˆã‚ŠäºˆæœŸã?›ã?¬æŒ¯ã‚‹èˆžã?„ã?Œèµ·ã??ã‚‹å?¯èƒ½æ€§ã?Œã?‚りã?¾ã?™ã€‚
ResultSet rs = s.executeQuery("SELECT text FROM CLOBS WHERE i = 1"); while (rs.next()) { aclob=rs.getClob(1); ip = rs.getAsciiStream(1); }
サイズã?®å¤§ã??ã?ªåˆ—ã?®æƒ…å ±ã‚’æ‰±ã?†ã‚¹ãƒˆãƒªãƒ¼ãƒ ã?¯ã‚¹ãƒ¬ãƒƒãƒ‰ã‚»ãƒ¼ãƒ•ã?§ã?¯ã?‚りã?¾ã?›ã‚“。従ã?£ã?¦ã€?ã‚‚ã?—ユーザã?Œè¤‡æ•°ã?®ã‚¹ãƒ¬ãƒƒãƒ‰ã‚’作æˆ?ã?—ã?¦ã€?ã??れらスレッドã?‹ã‚‰ã‚¹ãƒˆãƒªãƒ¼ãƒ ã?«ã‚¢ã‚¯ã‚»ã‚¹ã?—ã?Ÿå ´å?ˆã€?未定義ã?®å‹•作を起ã?“ã?—ã?¾ã?™ã€‚
Clobã?«ã?¯ãƒã‚±ãƒ¼ãƒ«ã?«ã‚ˆã‚‹æŒ¯ã‚‹èˆžã?„ã?®é?•ã?„ã?Œã?‚りã?¾ã?›ã‚“。