This suggestion is definitely not as complete as using Jprofiler, but it is simple. Add SQL Debugging/Logging to your launch parameters: "-DEOAdaptorDebugEnabled=true". I usually add it on my development machine and then connect to production but if the issue is one of growing over time, you may have to add it to a production instance. Be prepared to wade through large amounts of output looking for a fetch that is retrieving way too many rows. Obviously, if the issue is not SQL related, this won't help at all.
Chris -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mike Schrag Sent: Thursday, September 24, 2009 7:20 AM To: Development WebObjects Subject: Re: Connector/J 5.1, Euro Symbol as '?' Get the 15 day trial of JProfiler and use remote profiling to connect to your app -- you can see where the memory is going and who is holding references. On your remote server, just copy up your JProfiler bin folder, then add: export DYLD_LIBRARY_PATH="/path/to/jprofiler/bin/macos:$ {DYLD_LIBRARY_PATH}"; and in your java launch line, add: -agentlib:jprofilerti=port=8849 -Xbootclasspath/a:/path/to/jprofiler/ bin/agent.jar to the launch script ... you can then remotely connect to your app instance w/ JProfiler. On Sep 24, 2009, at 4:36 AM, David Griffith wrote: > Hi all, > > I've been having a real problem over the past 12 months with my > WebObjects and mySQL installation. It has been getting gradually > worse to the point now where the apps crash every 10 or 15 mins. > The are crashing out with Java.OutOfHeapSpace errors. We've tried > everything to increase the heap space but has made no difference. > The fact that it is has gradually gotten worse over time indicates to > me that as the database is growing the problem is getting worse. > > I tried last night to update the Connecter/J adaptor to version 5.1 as > we were using an older one and I thought that might help. It hasn't > in fact, and what it has done is make all the € symbols appear as '?'. > I know this has to do with the encoding and I want it all to be UTF8 > but I can't seem to work out how the hell to get them to display > properly. They all displayed perfectly before I changed the adaptor. > > On the other hand, I really need to find a solution to this problem > where the apps are crashing and I am very tight for time. I am > prepared to pay someone to track down this problem for me. Any > takers? > > Kind regards, > David. _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40mdimen > sion.com > > This email sent to [email protected] _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/chris.lonie%40pateam.com This email sent to [email protected] ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
