| Kieran,
Thanks, very useful information. Maybe I've never seen that because when I do similar things I either "zip" the serialized objects and store the zip archives as blobs, or I Base64 encode them before inserting them into the blob field. But definitely good to know. On Jul 21, 2006, at 11:03 PM, Kieran Kelleher wrote: Hi Robert,
When I dropped in 3.1.XX many months ago without any reason other than I was upgrading my dev machine from MySQL 4.0 to 4.1, I had problems with a serialized NSDictionary custom attribute mapped to a BLOB. At this stage I have forgotten exactly the problem symptoms and I don't have time to reproduce it. Process of elimination (it was either the 3.1 driver or the MySQL version 4.1) showed the 3.1.XX driver to be the contributor to the problem. I stuck with 3.0 and never looked back since I had no compelling reason to dedicate time to why 3.1 was causing an issue since my apps run fine with 3.0 driver and mysql 4.1.
Regards, Kieran
On Jul 21, 2006, at 4:43 PM, Robert Walker wrote: Hi all,
Can someone explain what the problems are supposed to be with Connector-J 3.1.x? I've seen this mentioned on the list a few times, but I've been using that version with both MySQL 4.x and MySQL 5.x with no apparent problems at all.
One issues I did notice with Connector-J 3.1 has to do with dates being defaulted when inserting records directly into MySQL, where the default value for a date field not allowing null was "0000-00-00."
The newer Connector-J complains about that, but IMHO that was a "bug fix" in Connect-J 3.1. Obviously there is no year 0000 month 00 and day 00 so this should throw an exception in the connector. MySQL should not allow a record to be saved where a mandatory date field is left empty. Sounds to me more like a bug in MySQL rather than in the MySQL JDBC connector.
Am I missing something else? Should I be concerned about this?
On Jul 21, 2006, at 2:49 PM, Kieran Kelleher wrote: Try getting rid of the 3.1.XX version connector and use the *latest* 3.0.XX version exclusively
HTH
-Kieran ________________________________________________________________ Dev Config = OS X 10.4.6 i686-C.Duo / Java 1.4.2_09 / WO 5.3.1 & P. Wonder / XCode v2.2.1 / MySQL 4.1.18-std / Connector-J 3.0.17 Deploy Config = OS X 10.3.9 Server G4-PPC / Java 1.4.2_09 / WO 5.2.3 / MySQL 4.0.26 / Connector-J 3.0.17
On Jul 21, 2006, at 6:40 AM, Gino Pacitti wrote:
Hi All
Has anyone encountered this error on using OS 10.4.7 with mysql 4.1?
java.lang.ArrayIndexOutOfBoundsException 40
This happens when a connection is attempted using the JDBC adaptors.
I have the jdbc2_0-stdext.jar, mysql-connector-java-3.0.9-stable-bin.jar and mysql-connector-java-3.1.13-bin.jar in the class path?
Any ideas or pointers
Gino _______________________________________________ Do not post admin requests to the list. They will be ignored. Help/Unsubscribe/Update your Subscription:
_______________________________________________ Do not post admin requests to the list. They will be ignored. Help/Unsubscribe/Update your Subscription:
_______________________________________________ Do not post admin requests to the list. They will be ignored. Help/Unsubscribe/Update your Subscription:
|
_______________________________________________
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]
