SpringBoot+MyBatisで例外が出たときどこを見るか

Transcript

1. 4QSJOH
   
   .Z#BUJTͰ
   ྫ֎͕ग़ͨͱ͖Ͳ͜ΛݟΔ͔ 
   ؔδϟό`
   ݄౓
   ϢΧΠ
2. ϢΧΠ
   !TZVLBJ
   &$αΠτ։ൃӡ༻νʔϜͷ&.
   +BWBΛத৺ʹஔ͖ͭͭ։ൃʹؔ͢ΔͳΜͰ΋΍Δ
   ʢϑϩϯτΤϯυ͔Β͸ڑ཭Λஔ͍͍ͯΔʣ ࣗݾ঺հ 2
3. ࠓ೔ͷΰʔϧ w .Z#BUJTͷΤϥʔݟͯ΋ύχΫΒͳ͍
4. .Z#BUJTͱ͸ʁ IUUQTNZCBUJTPSHNZCBUJTKBJOEFYIUNM
5. ࡶͳઆ໌
   9.-ϑΝΠϧʹॻ͍ͨ42-Λ࣮ߦͯ͘͠ΕΔπʔϧ 
 ʢͱ͍͏࢖͍ํΛ͢Δ૝ఆͰࠓ೔͸࿩͠·͢ʣ
6. ͱ͍͏ཧղͩͱྫ֎ग़ͨͱ͖ʹʮ42-࣮ߦ͍͚ͨͩ͠ͳͷʹʂʯͱͳΔ
   ݴ͍׵͑Δͱ
   ʮ42-Λ࣮ߦ͢ΔͨΊʹඞཁͳz͋Ε͜Εz΋΍ͬͯ͘ΕΔศརͳ΍ͭʯ
   ˠz͋Ε͜Εz͕ͲΜͳ͜ͱͳͷ͔஌͓ͬͯ͘͜ͱ͕େࣄ
   ˠ͜ͷล͕ؒҧ͑ͯͨΒ͜Μͳྫ֎͕ग़Δɺ͕Θ͔Δ
   ɹυΩϡϝϯτ΋ͪΐͬͱಡΈ΍͘͢ͳΔ͸ͣʢͨͿΜɻ͠ΒΜ͚Ͳʣ
7. େ·͔ͳॲཧͷྲྀΕ
8. ʢલఏʣࠓճ૝ఆͷ؀ڥ w +BWB
   w 4QSJOH#PPU
   w )
   %BUBCBTF
   w (SBEMF ˞؀ڥҎ֎ʹ΋ҧ͏࢖͍ํɾॻ͖ํ΋Ͱ͖·͕͢ɺ 
 ɹҰྫͱͯ͠ࢀߟʹ͍ͯͩ͘͠͞ɻ
9. αϯϓϧ ݺͼग़͠Օॴ
   demoMapper.get(); %FNP.BQQFSKBWB
   @Mapper public interface DemoMapper { List<Demo> get();_ } %FNP.BQQFSYNM
   <select id="get"> SELECT * FROM demo </select> (JU)VC
   IUUQTHJUIVCDPNTZVLBJNZCBUJTFSSPSMFBSOJOHXJUITQSJOHCPPU
10. ΍ͬͯ͘ΕΔ͜ͱ  ʢΞϓϦىಈ࣌ʣ9.-Λϩʔυ
     .BQϑΝΠϧΛ୳͢
     ύϥϝλ౉͢ɺ໭Γ஋ͷϚοϐϯά
     42-Λ४උ͢Δ QSFQBSF
     42-Λ࣮ߦͯ͠%#͔Β݁ՌΛड͚औΔ
     ΦϒδΣΫτʹ஋Λ୅ೖ ͦΕͧΕͷॲཧͰΤϥʔ͕ൃੜ͠͏Δ
    ίϯύΠϧΤϥʔʹͳΒͳ͍
11. 9.-ϑΝΠϧΛϩʔυ w ىಈ࣌ʹ.Z#BUJT༻ʹ༻ҙͨ͠9.-ϑΝΠϧΛϩʔυ͢Δ
    w 9.-ΛಡΈࠐΜͰඞཁͳΫϥεͱ͔ϩʔυͯ͠Δʁ
12. ൃੜ͢Δྫ֎ͱz͋Δ͋Δz w PSHBQBDIFJCBUJTCVJMEFS#VJMEFS&YDFQUJPOʢىಈ࣌ʹൃੜʣ
    w 9.-ͷจ๏͕ؒҧ͑ͯΔ
    w 3FTVMU.BQͳͲʹࢦఆͨ͠Ϋϥε͕ؒҧ͑ͯΔʢଘࡏ͠ͳ͍ʣ
13. .BQϑΝΠϧΛ୳͢ w .BQQFSΠϯλϑΣʔεʹରԠ͢ΔYNMϑΝΠϧΛ୳͢
    w σϑΥϧτͰ͸SFTPVSDFT഑Լͷ.BQQFSͱಉ͡ύε
    w .BQQFS͕
    TSDNBJODPNFYBNQMFEFNP.BQQFSͳΒ 
 SFTPVSDFNBJODPNFYBNQMFEFNP.BQQFSYNM
    w .BWFO΍(SBEMFͰSFTPVSDFTͷର৅Λઃఆ͢Δ͜ͱͰ
    NBJO഑Լʹஔ͍ ͯ΋ಡΈࠐ·ΕΔΑ͏ʹมߋͰ͖Δ
14. ൃੜ͢Δྫ֎ͱz͋Δ͋Δz w PSHBQBDIFJCBUJTCJOEJOH#JOEJOH&YDFQUJPO
    w ϑΝΠϧͷஔ͖৔ॴؒҧ͑ͯΔ
    w ϑΝΠϧ໊ʢେจࣈখจࣈͱ͔΋ؚΊʣؒҧ͑ͯΔ
    w 3FTPVSDFͷઃఆ͕ແ͍ɺؒҧ͑ͯΔ
15. ύϥϝλΛ౉͢ w 42-ͰόΠϯυม਺ͱͯ͠ѻ͏஋Λ౉͢
    w .BQQFSϝιουͷύϥϝλʹ!1BSBNΞϊςʔγϣϯΛ͚ͭͯύϥϝλ Λ౉͢
    Demo getById(@Param("pk") DemoPk pk); w 42-ଆͰ͸\YYY^
    \YYY^ͳͲͰύϥϝλΛड͚औΔ
    where pk = #{pk.value}
16. ൃੜ͢Δྫ֎ͱz͋Δ͋Δz
     w PSHNZCBUJTTQSJOH.Z#BUJT4ZTUFN&YDFQUJPO
    w DBVTFE
    CZ
    PSHBQBDIFJCBUJTCJOEJOH#JOEJOH&YDFQUJPO
    w .BQQFSͱ9.-Ͱύϥϝλ໊͕Ұகͯ͠ͳ͍
    w ύϥϝλ໊ॻ͖๨Ε
    w !1BSBNॻ͖๨Ε
17. ൃੜ͢Δྫ֎ͱz͋Δ͋Δz
     w PSHNZCBUJTTQSJOH.Z#BUJT4ZTUFN&YDFQUJPO
    w DBVTFE
    CZ
    PSHBQBDIFJCBUJTSF fl FDUJPO3F fl FDUJPO&YDFQUJPO
    w ϓϩύςΟ͕ͳ͍
    w ϓϩύςΟ໊ؒҧ͑ͯΔʢେจࣈɾখจࣈʣ
    w ϓϩύςΟͷ֊૚Λؒҧ͑ͯΔ
18. ݁ՌΛϚοϐϯά w %#͔Βड͚औͬͨ݁ՌΛฦ٫༻ΫϥεʹϚοϐϯά͢Δ
    w ͜ͷྻ͸͜ͷϓϩύςΟʹೖΕΔͱ͔
    w SFTVMU5ZQF΍SFTVMU.BQͷࢦఆ
    w SFTVMU.BQͰྻຖͷϚοϐϯάࢦఆ
19. ൃੜ͢Δྫ֎ͱz͋Δ͋Δz w PSHNZCBUJTTQSJOH.Z#BUJT4ZTUFN&YDFQUJPO
    w DBVTFE
    CZ
    PSHBQBDIFJCBUJTSF fl FDUJPO3F fl FDUJPO&YDFQUJPO
    w ϓϩύςΟ໊ؒҧ͑ͯΔ
20. ൃੜz͠ͳ͍zΤϥʔ w 4FMFDUͯ͠ͳ͍ྻ໊Λॻ͍͍ͯͯ΋ΤϥʔʹͳΒͳ͍
    w ࣮ߦͯ͠΋֘౰ͷ߲໨ʹOVMM΍ίϯετϥΫλͷॳظ஋͕ೖΔ͚ͩ
    w +BWBͰೖΕ෺͸༻ҙ͚ͨ͠ͲԿ΋ೖΒͳ͔ͬͨɺΈ͍ͨͳѻ͍
21. 42-Λ४උ͢Δ w ࣮ߦͷલʹ42-ΛϓϦίϯύΠϧ࣮ͯ͠ߦ४උ͢Δ
    w .Z#BUJTʹݶΒ͍͍ͣͩͨ͜ͷॲཧ͕͋Δ
    w ࢀߟ
    KBWBTRM1SFQBSFE4UBUFNFOU
22. ൃੜ͢Δྫ֎ͱz͋Δ͋Δz w จ๏Τϥʔ͸͜ͷλΠϛϯάͩͱࢥͬͯͨΜ͚ͩͲ 
 ࠓճΑ͘Α֬͘ೝͨ͠Βҧ͏͔ͬͨʂ
    w ͜ͷλΠϛϯάͰΤϥʔى͜͢ํ๏ࢥ͍͔ͭͳ͔ͬͨͷͰ͍͖࣍·͢ʂ
23. 42-࣮ߦͯ͠%#͔Β݁ՌΛड͚औΔ w ࣮ࡍʹ42-Λ࣮ߦ͢Δ
    w %BUBTPVSDFΛࢀরͯ͠%#ʹ઀ଓ
    w ઀ଓࣗମ͸.Z#BUJTͷൣғ֎ʢ)JLBSJ$1ͱ͔ʣ
    w ݁ՌΛ%#͔Βड͚औΔ
    w ਖ਼ৗͳͷ͔ɺҟৗͳͷ͔
    w ड͚औͬͨ݁ՌΛݺͼग़͠ݩʹฦ٫Ͱ͖Δܗʹ͢Δͷ͸͜ͷޙͷॲཧɻ
24. ൃੜ͢Δྫ֎ͱz͋Δ͋Δz w %#ʹͭͳ͕Βͳ͍ɺ%#མͪͯͨɺλΠϜΞ΢τɾɾɾ
    w ʢ಺ଂ)Ͱ͜ͷλΠϛϯάͰى͜͢ͷ೉͘͠ͳ͍ʁʣ
    w PSHTQSJOHGSBNFXPSLKECD#BE4RM(SBNNBS&YDFQUJPO
    w 42-จ๏ޡΓ
    w UZQPɺ4&-&$5۟ͷΧϯϚൈ͚ɺςʔϒϧ໊ɾྻ໊ؒҧ͍ɾɾɾɾ
25. ΦϒδΣΫτʹ஋Λ୅ೖ w %#͔Βड͚औͬͨ݁ՌΛ+BWBͷΦϒδΣΫτʹ֨ೲ͢Δ
    w ֨ೲ͢ΔͨΊͷΠϯελϯεੜ੒
    w SFTVMU.BQ͕͋Ε͹هࡌͷϚοϐϯάͰɺ 
 ͳ͚Ε͹ྻ໊ʹԊͬͨϓϩύςΟʹSF fl FDUJPOͰ஋Λ֨ೲ
26. ൃੜ͢Δྫ֎ͱz͋Δ͋Δz w PSHNZCBUJTTQSJOH.Z#BUJT4ZTUFN&YDFQUJPO
    w $BVTFE
    CZ
    PSHBQBDIFJCBUJTSF fl FDUJPO3F fl FDUJPO&YDFQUJPO
    w ֨ೲ͢ΔΫϥεʹద੾ͳίϯετϥΫλ͕ແ͍
    w Ҿ਺ͳ͠ίϯετϥΫλ͔ɺ֨ೲ͢Δશ߲໨ͷҾ਺Λ࣋ͭίϯετϥ Ϋλ͕ଥ౰
    w QSJWBUFͰ΋େৎ෉
    w ίϯετϥΫλະఆٛͳΒσϑΥϧτͰҾ਺ͳ͕͠༻ҙ͞ΕΔ
27. ͓·͚ɿͨ·ʹz͋Δ͋Δz w ίϯετϥΫλ΋ϓϩύςΟ΋ͪΌΜͱ͋ΔͷʹͳΜ͔஋͕͏·͍͜ͱ ೖΒͳ͍ͷͳΜͰʁʁʁ
    w ಛఆͷQSF fi Y͕͍ͭͨϝιου͕HFUUFS΍TFUUFSͱͯ͠ಈ͍ͯ͠·͏
    w HFU
    JT
    DBO
    ʜ
    w HFU)PHF
    \
    JG
    IPHF
    
    OVMM
    
    SFUVSO
    OFX
    )PHF ^
28. ྫʣ
    )PHF\
    'VHB
    GVHB
    
    OFX
    'VHB 
    )PHF \^
    HFU'VHB \
    
    JG GVHBWBMVF
    
    OVMM
    
    
    
    
    SFUVSO
    OFX
    'VHB 
    
    SFUVSO
    GVHB
    ^  ίϯετϥΫλʹΑΓGVHBOVMMͷ )PHFΠϯελϯε͕࡞ΒΕΔ
     .Z#BUJT͸GVHBʹ୅ೖ͢ΔͨΊ HFU'VHBͰऔΓग़ͨ͠ϓϩύςΟʹ ஋Λ୅ೖ͠Α͏ͱ͢Δ
     GVHB͸OVMMͳͷͰ৽͍͠'VHBΠϯ ελϯε͕ฦ͞ΕΔ
     ̏Ͱ࡞ͬͨΠϯελϯεʹ஋Λ୅ೖ
     )PHFGVHB͸OVMMͷ··ɾɾɾ )PHF
    GVHB
    OVMM GVHB
    HFU'VHB ୅ೖ
29. ͍͞͝ʹ w ࠓճ঺հͨ͠Ҏ֎ʹ΋৭ΜͳΤϥʔ͕ൃੜ͠ಘΔ
    w ͲΜͳ͜ͱΛͲΜͳॱ൪Ͱ΍͍ͬͯΔͷ͔Λ೺Ѳ͠ͳ͕Β 
 ʮ42-͸࣮ߦͰ͖ͯΔ͔Β͜ͷล͕ؒҧ͑ͯͦ͏ʯ 
 ʮ42-ͷ࣮ߦ͢Βͯ͠ͳ͍͔Β͜͜Βล͔Βௐ΂Α͏ʯ 
 ͱ͔མͪண͍ͯߟ͑ΒΕΔΑ͏ʹͳΔͱخ͍͠Ͱ͢ʂ
30. ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ