Oracle11g´Ä¶¤Ç¤Î¥¹¥Ú¡¼¥¹ÃͤǤι¹¿·
nakada
Åê¹Æ¿ô: 6
Á°Äó¾ò·ï¡§Oracle11g
¡ÖDataMapper¡×¥³¥ó¥Ý¡¼¥Í¥ó¥È¤Ë¤ÆOracle¤Ø¤ÎSelect¡õUpdate¤ò¼ÂÁõ
¡¥³¥ó¥Ý¡¼¥Í¥ó¥È¡ÖDataMapper¡×¤ËOracle¤è¤ê
¡¡¥Ç¡¼¥¿¼èÆÀSelectʸ¤òºîÀ®¡£
¡¡¤³¤Î¥Ç¡¼¥¿¤ÎChar¹àÌܤ˥¹¥Ú¡¼¥¹£±¤Ä¤¬¥»¥Ã¥È¤µ¤ì¤Æ¤¤¤ë¡£
¢¤³¤Î¡Ö¥Ç¡¼¥¿¥Þ¥Ã¥Ñ¡¼¡×¤ÇÁ÷¤êÀè¤ËUPDATE¤ò»ØÄê¡£
¡¡¡¤Ç¼èÆÀ¤·¤¿¹àÌܤΥǡ¼¥¿ÃͤˤÆUPDATE
£¥Þ¥Ã¥×²èÌ̤ˤÆÁ÷¤êÀè¡ÊSelect¹àÌܡˤÈÁ÷¤ê¸µ¤ÇÀþ°ú¤¤ò¹Ô¤¦¡£
¡¡¡¤Ç¼èÆÀ¤·¤¿¥Ç¡¼¥¿Ãͤò¤½¤Î¤Þ¤Þ¥»¥Ã¥È¡£¥¹¥Ú¡¼¥¹¤â¤½¤Î¤Þ¤Þ¥»¥Ã¥È¡£
¤¥Á¥§¥Ã¥«¡¼¢Í¥×¥í¥¸¥§¥¯¥È¼Â¹Ô¢Í¼Â¹Ô¥Õ¥¡¥¤¥ë¥Ó¥ë¥É¢ÍÁ´¥Ó¥ë¥É
¡¡ÌäÂê¤Ê¤·¡£
¥¥â¥Ë¥¿¡¼¤Ë¤Æ¼Â¹Ô¡£
¦¼Â¹Ô·ë²Ì¡§²¼µ¥¨¥é¡¼¡¡¥â¥Ë¥¿¡¼¤Ç¤Î¥¨¥é¡¼ÆâÍƤòÁ÷ÉÕ¤·¤Þ¤¹¡£
Ž´Ž×Ž° 9805: ORA-01407: ("PBOX_WATADATA"."MASTOKUI"."TOKUISKA")¤òNULL¤Ë¤Ï¹¹¿·¤Ç¤¤Þ¤»¤ó¡£
¢¨Ç°¤Î°Ù¤Ë¥Þ¥Ã¥×²èÌ̤ˤÆÁ÷¤êÀè¤Î¥¨¥é¡¼¹àÌܤÎÀܳ¤ò³°¤··×»»ÃÍÍó¤Ç¥¹¥Ú¡¼¥¹¤ò¸ÇÄꥻ¥Ã¥È¤·¤Æ¤âƱÍͤθ½¾Ý¤Ç¤¹¡£
¤³¤ÎÍͤʸ½¾Ý¤ò³Îǧ¤µ¤ì¤¿»ö¤Ï¤¢¤ê¤Þ¤»¤ó¤Ç¤·¤ç¤¦¤«¡©
¤â¤·²óÈòºö¡¢Âбþºö¤¬¤¢¤ì¤Ð¤´¶µ¼ø¤ò¤ª´ê¤¤Ãפ·¤Þ¤¹¡£
¡ÖDataMapper¡×¥³¥ó¥Ý¡¼¥Í¥ó¥È¤Ë¤ÆOracle¤Ø¤ÎSelect¡õUpdate¤ò¼ÂÁõ
¡¥³¥ó¥Ý¡¼¥Í¥ó¥È¡ÖDataMapper¡×¤ËOracle¤è¤ê
¡¡¥Ç¡¼¥¿¼èÆÀSelectʸ¤òºîÀ®¡£
¡¡¤³¤Î¥Ç¡¼¥¿¤ÎChar¹àÌܤ˥¹¥Ú¡¼¥¹£±¤Ä¤¬¥»¥Ã¥È¤µ¤ì¤Æ¤¤¤ë¡£
¢¤³¤Î¡Ö¥Ç¡¼¥¿¥Þ¥Ã¥Ñ¡¼¡×¤ÇÁ÷¤êÀè¤ËUPDATE¤ò»ØÄê¡£
¡¡¡¤Ç¼èÆÀ¤·¤¿¹àÌܤΥǡ¼¥¿ÃͤˤÆUPDATE
£¥Þ¥Ã¥×²èÌ̤ˤÆÁ÷¤êÀè¡ÊSelect¹àÌܡˤÈÁ÷¤ê¸µ¤ÇÀþ°ú¤¤ò¹Ô¤¦¡£
¡¡¡¤Ç¼èÆÀ¤·¤¿¥Ç¡¼¥¿Ãͤò¤½¤Î¤Þ¤Þ¥»¥Ã¥È¡£¥¹¥Ú¡¼¥¹¤â¤½¤Î¤Þ¤Þ¥»¥Ã¥È¡£
¤¥Á¥§¥Ã¥«¡¼¢Í¥×¥í¥¸¥§¥¯¥È¼Â¹Ô¢Í¼Â¹Ô¥Õ¥¡¥¤¥ë¥Ó¥ë¥É¢ÍÁ´¥Ó¥ë¥É
¡¡ÌäÂê¤Ê¤·¡£
¥¥â¥Ë¥¿¡¼¤Ë¤Æ¼Â¹Ô¡£
¦¼Â¹Ô·ë²Ì¡§²¼µ¥¨¥é¡¼¡¡¥â¥Ë¥¿¡¼¤Ç¤Î¥¨¥é¡¼ÆâÍƤòÁ÷ÉÕ¤·¤Þ¤¹¡£
Ž´Ž×Ž° 9805: ORA-01407: ("PBOX_WATADATA"."MASTOKUI"."TOKUISKA")¤òNULL¤Ë¤Ï¹¹¿·¤Ç¤¤Þ¤»¤ó¡£
¢¨Ç°¤Î°Ù¤Ë¥Þ¥Ã¥×²èÌ̤ˤÆÁ÷¤êÀè¤Î¥¨¥é¡¼¹àÌܤÎÀܳ¤ò³°¤··×»»ÃÍÍó¤Ç¥¹¥Ú¡¼¥¹¤ò¸ÇÄꥻ¥Ã¥È¤·¤Æ¤âƱÍͤθ½¾Ý¤Ç¤¹¡£
¤³¤ÎÍͤʸ½¾Ý¤ò³Îǧ¤µ¤ì¤¿»ö¤Ï¤¢¤ê¤Þ¤»¤ó¤Ç¤·¤ç¤¦¤«¡©
¤â¤·²óÈòºö¡¢Âбþºö¤¬¤¢¤ì¤Ð¤´¶µ¼ø¤ò¤ª´ê¤¤Ãפ·¤Þ¤¹¡£
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
Åê¹Æ¥Ä¥ê¡¼
-
Oracle11g´Ä¶¤Ç¤Î¥¹¥Ú¡¼¥¹ÃͤǤι¹¿·
(nakada, 2010-8-27 15:00)
- Re: Oracle11g´Ä¶¤Ç¤Î¥¹¥Ú¡¼¥¹ÃͤǤι¹¿· (nakada, 2010-8-27 16:25)
- Re: Oracle11g´Ä¶¤Ç¤Î¥¹¥Ú¡¼¥¹ÃͤǤι¹¿· (jBOLTer, 2010-8-27 16:26)
- Re: Oracle11g´Ä¶¤Ç¤Î¥¹¥Ú¡¼¥¹ÃͤǤι¹¿· (nakada, 2010-8-27 16:29)
- Re: Oracle11g´Ä¶¤Ç¤Î¥¹¥Ú¡¼¥¹ÃͤǤι¹¿· (jBOLTer, 2010-8-27 16:37)
- Re: Oracle11g´Ä¶¤Ç¤Î¥¹¥Ú¡¼¥¹ÃͤǤι¹¿· (nakada, 2010-8-30 13:53)