Hi David,

Regarding the UTF-8 problem. I am using this with MySQL 5.0.83 innodb
jdbc:mysql://hostname/databasename? capitalizeTypenames=true&useUnicode=true&characterEncoding=UTF-8

BTW, I use Connector/J 5.0.8, InnoDB, and have configured the /etc/ my.cnf to give mysql as much memory as can be afforded depending on the server it is on.


Kieran





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/kieran_lists%40mac.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/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to