deleteDept 콘솔 창 메시지
INFO : org.springframework.test.context.support.DefaultTestContextBootstrapper - Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener]
INFO : org.springframework.test.context.support.DefaultTestContextBootstrapper - Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@e45f292, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@5f2108b5, org.springframework.test.context.support.DependencyInjectionTestExecutionListener@31a5c39e, org.springframework.test.context.support.DirtiesContextTestExecutionListener@3f49dace, org.springframework.test.context.transaction.TransactionalTestExecutionListener@1e397ed7, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@490ab905]
INFO : org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [config/applicationContext.xml]
INFO : org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [config/transactionContext.xml]
INFO : org.springframework.context.support.GenericApplicationContext - Refreshing org.springframework.context.support.GenericApplicationContext@3701eaf6: startup date [Tue Jun 19 09:41:36 KST 2018]; root of context hierarchy
INFO : org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor - JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Mapped "{[/getBoardList]}" onto public java.lang.String com.yedam.web.board.view.BoardController.getBoardList(javax.servlet.http.HttpServletRequest)
INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Mapped "{[/getEmpList]}" onto public java.lang.String com.yedam.web.emp.view.EmpController.getEmpList(javax.servlet.http.HttpServletRequest)
INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Mapped "{[/insertEmp],methods=[POST]}" onto public java.lang.String com.yedam.web.emp.view.EmpController.insertEmp(javax.servlet.http.HttpServletRequest,com.yedam.web.emp.EmpVO)
INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Mapped "{[/],methods=[GET]}" onto public java.lang.String com.yedam.web.HomeController.home(java.util.Locale,org.springframework.ui.Model)
INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter - Looking for @ControllerAdvice: org.springframework.context.support.GenericApplicationContext@3701eaf6: startup date [Tue Jun 19 09:41:36 KST 2018]; root of context hierarchy
INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter - Looking for @ControllerAdvice: org.springframework.context.support.GenericApplicationContext@3701eaf6: startup date [Tue Jun 19 09:41:36 KST 2018]; root of context hierarchy
INFO : jdbc.connection - 1. Connection opened
INFO : jdbc.audit - 1. Connection.new Connection returned
INFO : jdbc.audit - 1. Connection.getAutoCommit() returned true
INFO : jdbc.audit - 1. PreparedStatement.new PreparedStatement returned
INFO : jdbc.audit - 1. Connection.prepareStatement(DELETE FROM HR.DEPARTMENTS
WHERE DEPARTMENT_ID IN
(
?
,
?
,
?
)) returned net.sf.log4jdbc.PreparedStatementSpy@bae47a0
INFO : jdbc.audit - 1. PreparedStatement.setString(1, "460") returned
INFO : jdbc.audit - 1. PreparedStatement.setString(2, "330") returned
INFO : jdbc.audit - 1. PreparedStatement.setString(3, "320") returned
INFO : jdbc.sqlonly - SQL:::DELETE FROM HR.DEPARTMENTS
WHERE DEPARTMENT_ID IN
(
'460'
,
'330'
,
'320'
)
DEBUG: jdbc.sqltiming - org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)
1. DELETE FROM HR.DEPARTMENTS WHERE DEPARTMENT_ID IN ( '460' , '330' , '320' ) {executed in 84 msec}
INFO : jdbc.audit - 1. PreparedStatement.execute() returned false
INFO : jdbc.audit - 1. PreparedStatement.getUpdateCount() returned 3
INFO : jdbc.audit - 1. PreparedStatement.isClosed() returned false
INFO : jdbc.audit - 1. PreparedStatement.close() returned
INFO : jdbc.connection - 1. Connection closed
INFO : jdbc.audit - 1. Connection.close() returned
INFO : org.springframework.context.support.GenericApplicationContext - Closing org.springframework.context.support.GenericApplicationContext@3701eaf6: startup date [Tue Jun 19 09:41:36 KST 2018]; root of context hierarchy