±Û¾´ÀÌ :ÀüÁø¹è 1998³â 5¿ù 17ÀÏ 11:53:22
In Reply to: Æ®·£Àè¼Ç°ú °ü·ÃÇÏ¿©.... posted by ±èÇÊÈ£ on 1998³â 5¿ù 16ÀÏ 10:17:08:
¾È³çÇϼ¼¿ä ±èÇÊÈ£´Ô Àú¶«½Ã·Õ °í»ýÀÌ ¸¹Áö¿ä
¿ì¼± Áö±Ý±îÁöÀÇ ¼º¿ø¿¡ °¨»çµå¸³´Ï´Ù.
º»·ÐÀ¸·Î µé¾î°¡¼ Æ®·£Àè¼Ç 󸮴 ²À ÇؾßÇϰŵç¿ä
±×·¡¼ conn.setAutoCommit(false) ¸¦ ½á¾ßÇÏ°í¿ä
Æ®·£Àè¼Ç 󸮸¦ ÇÏÁö¾ÊÀ¸¸é DB 󸮴 ¾Æ¹« Àǹ̰¡
¾ø°ÚÁö¿ä, ±×¸®°í conn.commit() µµ Client ÀÇ Message¿¡ µû¶ó
󸮴 ÇØ¿ä.( ¿¹ sqlText.equals("COMMIT"); .....)
Test Class ÀÇ ¿¹´Â ÀÏ´Ü Select ¿¡¼ Error ¹ß»ýÇϴϱî
Ŭ·¡½º À̸§°ú°°ÀÌ Test Class ¸¦ ¸¸µé¾î¼ TestÇÑ°ÍÀÌ°í¿ä
Message¿¡µû¶ó DB connection, DB open, DB close(pstmt.close()), DB commit,
DB rollback, DB disconnect( conn.close()),socket disconnect µî ÇÊ¿äÇÑ
󸮴 Á¦°¡ »ç¿ëÇÏ´Â ¿ø·¡ source ¿¡¼´Â ´Ù Çß¾î¿ä
¸¶Áö¸·À¸·Î ¿ø·¡ÀÇ ±Ã±ÝÇÑ°ÍÀº ¾î¶² ƯÁ¤ÇÑ TableÀÇ
Data ¸¸ Select ÇÏ¸é °¡²û SQLException ÀÌ ¹ß»ýÇÑ´Ù´Â
°ÍÀÓ´Ï´Ù. ¹°·Ð Record´ÜÀ§ ó¸®À϶§ ƯÁ¤ Record °¡ Exception ºóµµ°¡
³ô°í¿ä. ±×·¡¼ Àú´Â JDBC ÂÊ Error ·Î ÀǽÉÇÏ°í¿ä
ÀúÀÇ ÇöÀç±îÁöÀÇ °á·ÐÀº JDBC bug ¾Æ´Ï¸é Á¦°¡ JDBC ¸¦
install À߸øÇÑ°ÍÀÌ ¾Æ´Ñ°¡ »ý°¢µÊ´Ï´Ù. ±×·¡¼ ProgramÀÚüÅ×½ºÆ®´Â
´ÙÀ½À¸·Î ¹Ì·ç°í JDBC ¸¦ ´Ù½Ã Install ÈÄ Test ÇغÁ¾ß ÇÒ°Í°°¾Æ¿ä
´Ù½Ã TestÇÑÈÄ Bug¸¦ ãÀ¸¸é ÀÚ¹Ù ¹¯°í ´äÇϱ⿡
¿Ã¸®°Ú½À´Ï´Ù. Ȥ½Ã ´Ù¸¥ÂÊ¿¡ ÀǽÉÀÌ °¡½Ã¸é
°è¼Ó µµ¿ò ºÎŹµå¸³´Ï´Ù. °¨»çÇÕ´Ï´Ù.
===== ÀÚ¹Ù¸¦ °øºÎÇϽô ¸ðµç ºÐµéÀÌ¿© ÈÀÌÆà ====