Hello David;

If I add a duplicate EOModel to my project which uses a different adaptor setting to connect to FrontBase, can I connect to mySQL with one of the EOModels and FrontBase with the other and using the custom java classes just load the data from mySQL via one and write to FrontBase via the other?

There's a utility called "eoutil" (I have not used this tool myself actually) which does most of this work. Here are some details online in a mailing list post...

        http://www.mail-archive.com/[email protected]/msg00836.html

Although it is hard to isolate any concrete answers on this matter, it is my belief that the MySQL JDBC driver has a memory leak which may cause trouble in this process. I have spent an substantial amount of time trying to identify a means of avoiding this, but have not solved it.

It seems like originally all the data was in Latin 1 encoding. When I change everything back to Latin 1, the € symbol appears fine again. However I still see all the '?' in any data the comes from a BLOB.

I don't have all the details now, but around version 4 there were some big changes with encoding which caused some folk awful trouble. I currently use the following arguments to the driver to get it to behave itself...

...? useUnicode=true&characterEncoding=UTF&autoReconnect=true&useUnbufferedIn put=true

Guess what database product I'm trying to avoid these days? :-)

cheers.

___
Andrew Lindesay
www.lindesay.co.nz



_______________________________________________
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