SQL Logging Error! - with log4sql

ErrorMessage...

[2010-06-18 11:08:56] [ERROR]『java.lang.Thread:run(-1)』
java.lang.OutOfMemoryError
SQL Logging Error!
Java heap space
 at java.util.Arrays.copyOf(Unknown Source)
 at java.lang.AbstractStringBuilder.expandCapacity(Unknown Source)
 at java.lang.AbstractStringBuilder.append(Unknown Source)
 at java.lang.StringBuffer.append(Unknown Source)
 at core.log.logger.LoggingQuery.queryLog(LoggingQuery.java:72)
 at core.log.logger.LoggingQuery.log(LoggingQuery.java:36)
 at core.log.logger.LoggingQuery.log(LoggingQuery.java:24)
 at core.log.aop.handler.DaoInfo.sqlLogging(DaoInfo.java:162)
 at core.log.aop.handler.DaoInfo.doAround(DaoInfo.java:92)
 at core.log.aop.reflection.profiler.AroundProfiler.invoke(AroundProfiler.java:19)
 at $Proxy0.setString(Unknown Source)
 at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:132)
 at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:132)
 at org.apache.jsp.provider.viewsave.view_005fsave_005fobject_jsp._jspService(view_005fsave_005fobject_jsp.java:145)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
 at java.lang.Thread.run(Unknown Source)

원인:

PreparedStatement pstmt = conn.prepareStatement(query);
....
pstmt.addBatch();
....
pstmt.executeBatch();

batch 를 걸어버리면 문제가 생김...


해결:

log4sql 꼭 필요할때만 적용...