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.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:

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:

This email sent to [EMAIL PROTECTED]

--
Robert Walker



 _______________________________________________
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