I think you should start with the usual suspect - max Java heap size.
Use "-Xmx" JVM startup switch to increase max allowed memory for
Tomcat (you can edit Tomcat startup script to add this switch). E.g.
"-Xmx512m". If this (or even bigger memory setting) doesn't solve the
problem, then you should start looking at the actual code.
BTW other errors may be related to the app running out of memory as
well.
Andrus
On Oct 24, 2005, at 5:49 AM, Lothar Krenzien wrote:
> Hi there,
>
> I'm using cayenne (don't know which version) with Java 5 and Tomcat
> 5.5 in a servlet environment to access a MS SQL 2000 database over
> a LAN network. The servlets takes a xml files as input and calls a
> SQL procedure which takes the file as argument, parse the file and
> write the content into the database. The procedure uses a cursor so
> I think, the execution time of that procedure is not the best.
>
> Some times, mostly at weekend, the servlet is very heavenly
> called. A lot of files are posted and also a lot database queries
> are made. After a while I get an OutOfMemory exception in Java and
> I have to restart Tomcat. Of course I'm not sure, if is it a
> cayenne probleme. But maybe someone else had have this problem or
> know of it.
>
> Here's an except of the tomcat log:
>
> 2005-10-23 04:42:54,109 [DEBUG]
> org.objectstyle.cayenne.event.EventManager.Event dispatch error,
> ignoring.
> java.lang.OutOfMemoryError: Java heap space
>
> 2005-10-23 04:51:59,343 [ERROR]
> struts.actions.portal.OutputGenAction.callFormEventMethod: Error
> calling: efbChartGenEvent>
> at org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:105)
> Caused by: java.lang.OutOfMemoryError: Java heap space
>
>
> I see also a lot of database exceptions:
>
> 2005-10-23 01:50:26,390 [ERROR]
> org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/
> DataLoggerGate].Servlet.service() for servlet DataLoggerGate threw
> exception
> base.exception.SystemErrorException: :
> at org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:105)
> at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken
> (Unknown Source)
>
> 2005-10-23 01:50:27,921 [INFO ]
> org.objectstyle.cayenne.access.QueryLogger.*** error.
> at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken
> (Unknown Source)
> at org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:105)
>
> 2005-10-23 01:50:27,921 [ERROR] DataLoggerGate.doPost: >
> base.exception.SystemErrorException: :
> at org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:105)
> at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken
> (Unknown Source)
>
> Thanks for any suggestion
> Lothar
>
This archive was generated by hypermail 2.0.0 : Mon Oct 24 2005 - 10:08:12 EDT