tag:blogger.com,1999:blog-4096588030990361518.post3047138569735381037..comments2023-10-08T19:10:45.383+09:00Comments on Zerockcode's Note: 오라클버전 P249,P253, P257 /resources/mappers/boardMapper.xml의 일부 Anonymoushttp://www.blogger.com/profile/01773558434789604986noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-4096588030990361518.post-66066892009413278342016-02-23T21:46:35.392+09:002016-02-23T21:46:35.392+09:00SQL문의 이상은 전혀 없어보입니다. 혹시 데이터베이스를 커밋하시지 않은 것은 아닐까 싶네...SQL문의 이상은 전혀 없어보입니다. 혹시 데이터베이스를 커밋하시지 않은 것은 아닐까 싶네요.. 답변이 늦어서 죄송합니다. Anonymoushttps://www.blogger.com/profile/01773558434789604986noreply@blogger.comtag:blogger.com,1999:blog-4096588030990361518.post-6461433090530161592016-02-16T16:38:49.148+09:002016-02-16T16:38:49.148+09:00listpage랑 listCriteria랑 따로 올려주시면 안될까요...?
맞는 쿼리인가요...listpage랑 listCriteria랑 따로 올려주시면 안될까요...?<br />맞는 쿼리인가요...?내용이 저도 안뜨네요...spring하자https://www.blogger.com/profile/18431571629022285672noreply@blogger.comtag:blogger.com,1999:blog-4096588030990361518.post-9354274622967213212016-02-15T21:46:32.165+09:002016-02-15T21:46:32.165+09:00왜 로그로 데이터들이 출력되지 않을까요...?
INFO : jdbc.connection ...왜 로그로 데이터들이 출력되지 않을까요...?<br /><br />INFO : jdbc.connection - 1. Connection opened<br />INFO : jdbc.audit - 1. Connection.new Connection returned <br />INFO : jdbc.audit - 1. Connection.getAutoCommit() returned true<br />INFO : jdbc.audit - 1. PreparedStatement.new PreparedStatement returned <br />INFO : jdbc.audit - 1. Connection.prepareStatement(select<br /> rn, bno, title, content, writer, regdate, viewcnt<br />from<br /> (<br /> select<br /> rownum rn, bno, title, content, writer, regdate, viewcnt<br /> from tbl_board<br /> where<br /> bno>0<br /> and rownum <= ? * 10)<br />where rn > (? -1) * 10) returned net.sf.log4jdbc.sql.jdbcapi.PreparedStatementSpy@2a3c96e3<br />INFO : jdbc.audit - 1. PreparedStatement.setInt(1, 20) returned <br />INFO : jdbc.audit - 1. PreparedStatement.setInt(2, 20) returned <br />INFO : jdbc.sqlonly - select rn, bno, title, content, writer, regdate, viewcnt from ( select rownum rn, bno, title, <br />content, writer, regdate, viewcnt from tbl_board where bno>0 and rownum <= 20 * 10) where rn <br />> (20 -1) * 10 <br /><br />INFO : jdbc.sqltiming - select rn, bno, title, content, writer, regdate, viewcnt from ( select rownum rn, bno, title, <br />content, writer, regdate, viewcnt from tbl_board where bno>0 and rownum <= 20 * 10) where rn <br />> (20 -1) * 10 <br /> {executed in 50 msec}<br />INFO : jdbc.audit - 1. PreparedStatement.execute() returned true<br />INFO : jdbc.resultset - 1. ResultSet.new ResultSet returned <br />INFO : jdbc.audit - 1. PreparedStatement.getResultSet() returned net.sf.log4jdbc.sql.jdbcapi.ResultSetSpy@59d2103b<br />INFO : jdbc.resultset - 1. ResultSet.getMetaData() returned oracle.jdbc.driver.OracleResultSetMetaData@10650953<br />INFO : jdbc.resultset - 1. ResultSet.getType() returned 1003<br />INFO : jdbc.resultsettable - <br />|---|----|------|--------|-------|--------|--------|<br />|rn |bno |title |content |writer |regdate |viewcnt |<br />|---|----|------|--------|-------|--------|--------|<br />|---|----|------|--------|-------|--------|--------|<br /><br />INFO : jdbc.resultset - 1. ResultSet.next() returned false<br />INFO : jdbc.resultset - 1. ResultSet.close() returned void<br />INFO : jdbc.audit - 1. PreparedStatement.getConnection() returned net.sf.log4jdbc.sql.jdbcapi.ConnectionSpy@7db82169<br />INFO : jdbc.audit - 1. Connection.getMetaData() returned oracle.jdbc.driver.OracleDatabaseMetaData@1992eaf4<br />INFO : jdbc.audit - 1. PreparedStatement.close() returned <br />INFO : jdbc.connection - 1. Connection closed<br />INFO : jdbc.audit - 1. Connection.close() returned <br />INFO : org.springframework.context.support.GenericApplicationContext - Closing org.springframework.context.support.GenericApplicationContext@5c7fa833: startup date [Mon Feb 15 21:44:59 KST 2016]; root of context hierarchy<br />Anonymousnoreply@blogger.com