게시글 삭제 질문입니다

Question

DEBUG: org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession DEBUG: org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1078db33] was not registered for synchronization because synchronization is not active DEBUG: org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource DEBUG: org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [HikariProxyConnection@830595600 wrapping net.sf.log4jdbc.sql.jdbcapi.ConnectionSpy@11e055b] will not be managed by Spring DEBUG: org.leedh.mapper.PjtMapper.deletePjt - ==> Preparing: DELETE FL_PROJECT WHERE NO = ? DEBUG: org.leedh.mapper.PjtMapper.deletePjt - ==> Parameters: null DEBUG: jdbc.sqlonly - com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) 1. DELETE FL_PROJECT WHERE NO = NULL DEBUG: jdbc.sqltiming - com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) 1. DELETE FL_PROJECT WHERE NO = NULL {executed in 2 msec} DEBUG: org.leedh.mapper.PjtMapper.deletePjt - <== Updates: 0 DEBUG: org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1078db33] DEBUG: org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession DEBUG: org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@721e2d67] was not registered for synchronization because synchronization is not active DEBUG: org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource DEBUG: org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [HikariProxyConnection@1912421624 wrapping net.sf.log4jdbc.sql.jdbcapi.ConnectionSpy@11e055b] will not be managed by Spring DEBUG: org.leedh.mapper.PjtMapper.deletePjtCode - ==> Preparing: DELETE FL_PJT_CODE WHERE NO = ? DEBUG: org.leedh.mapper.PjtMapper.deletePjtCode - ==> Parameters: null DEBUG: jdbc.sqlonly - com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) 1. DELETE FL_PJT_CODE WHERE NO = NULL DEBUG: jdbc.sqltiming - com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) 1. DELETE FL_PJT_CODE WHERE NO = NULL {executed in 2 msec} DEBUG: org.leedh.mapper.PjtMapper.deletePjtCode - <== Updates: 0 DEBUG: org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@721e2d67] DEBUG: org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession DEBUG: org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2c788b8] was not registered for synchronization because synchronization is not active DEBUG: org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource DEBUG: org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [HikariProxyConnection@1204098692 wrapping net.sf.log4jdbc.sql.jdbcapi.ConnectionSpy@11e055b] will not be managed by Spring DEBUG: org.leedh.mapper.PjtMapper.pjtShow - ==> Preparing: SELECT PJT_C as pjtC, PJT_CLIENT as pjtClient, PJT_NM as pjtNm, PJT_EMP_LIST as pjtEmpList, PJT_PM as pjtPm, PJT_START_DATE as pjtStartDate, PJT_End_DATE as pjtEndDate, PJT_END_YN as pjtEndYn, PJT_ST_C as pjtStC FROM FL_PROJECT DEBUG: org.leedh.mapper.PjtMapper.pjtShow - ==> Parameters: DEBUG: jdbc.sqlonly - com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) 1. SELECT PJT_C as pjtC, PJT_CLIENT as pjtClient, PJT_NM as pjtNm, PJT_EMP_LIST as pjtEmpList, PJT_PM as pjtPm, PJT_START_DATE as pjtStartDate, PJT_End_DATE as pjtEndDate, PJT_END_YN as pjtEndYn, PJT_ST_C as pjtStC FROM FL_PROJECT DEBUG: jdbc.sqltiming - com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) 1. SELECT PJT_C as pjtC, PJT_CLIENT as pjtClient, PJT_NM as pjtNm, PJT_EMP_LIST as pjtEmpList, PJT_PM as pjtPm, PJT_START_DATE as pjtStartDate, PJT_End_DATE as pjtEndDate, PJT_END_YN as pjtEndYn, PJT_ST_C as pjtStC FROM FL_PROJECT {executed in 2 msec} INFO : jdbc.resultsettable - |----------|----------|---------|-----------|------|-------------|-----------|---------|-------| |pjtc |pjtclient |pjtnm |pjtemplist |pjtpm |pjtstartdate |pjtenddate |pjtendyn |pjtstc | |----------|----------|---------|-----------|------|-------------|-----------|---------|-------| |001ECM004 |하하하은 |아아아아아아아아 |박ㅇㅁ으,자아자 |아아ㅏ르 |2021-02-04 |2021-02-23 |1 |B00 | |----------|----------|---------|-----------|------|-------------|-----------|---------|-------| DEBUG: org.leedh.mapper.PjtMapper.pjtShow - <== Total: 1 DEBUG: org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2c788b8] DEBUG: com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=10, active=0, idle=10, waiting=0) DEBUG: com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=10, active=0, idle=10, waiting=0) 이렇게 계속 null값이 넘어오는데.. controller @RequestMapping(value="/delete", method=RequestMethod.POST) public String delete(@RequestParam("delList") int no) { pjtService.deletePjt(no); pjtService.deletePjtCode(no); return "redirect:/project/pjtShow"; } service //프로젝트 삭제 void deletePjtCode(int no); void deletePjt(int no); // 프로젝트 삭제 @Override public void deletePjtCode(int no) { projectDao.deletePjtCode(no); } @Override public void deletePjt(int no) { projectDao.deletePjt(no); } dao //프로젝트 삭제 void deletePjtCode(int no); void deletePjt(int no); @Override public void deletePjtCode(int no) { sqlSession.delete(NAMESPACE + ".deletePjtCode"); } @Override public void deletePjt(int no) { sqlSession.delete(NAMESPACE + ".deletePjt"); }controller @RequestMapping(value="/delete", method=RequestMethod.POST) public String delete(@RequestParam("delList") int no) { pjtService.deletePjt(no); pjtService.deletePjtCode(no); return "redirect:/project/pjtShow"; }mapper DELETE FL_PJT_CODE WHERE NO = #{no} DELETE FL_PROJECT WHERE NO = #{no} 왜 계속 null값이 넘어올까요...

웹개발자 화이팅 · Accepted Answer

저렇게 안될떈 void보단 리턴타입을 int로 바꿔보시고 int result &#61; sqlSession.~~ log result 찍고 return result; 로 찍히는지 확인해보면 확실히 알거같네요

웹개발자 화이팅 · Answer

dao 로직에서 ~~~~~ (NAME_SPACE &#43; &#34;.특정 메소드명&#34;, no) 로 넘겨보세요~

초보늅늅 · Answer

웹개발자 화이팅 덕분에 해결했습니다 감사합니다

게시글 삭제 질문입니다

3개의 답변

Q&A 목록