Problems using newer JDBC drivers with MySQL

[llyr]

Hope someone can help!

We have recently upgraded our JDBC driver in our development environment to version 5.1.10 but have been experiencing problems as a result. In addition, our ebase development environment has forms facing off to MySQL databases on two different servers. One server is MySQL 5.0.33 and the other is 5.1.48. We are only experiencing these issues on version 5.0.33.

The error we are getting is whilst we are running a form and we are using any functions in queries such as TIME_FORMAT or DATE_FORMAT we get an error saying:-

* Unable to set value for field TBLREPORTS2-DESCRIPTION, value [B@149b1dd not compatible with type CHAR *

Anyone with any ideas please?

Thanks,
Llyr

[llyr]

Surely someone must have had a similar issue??

[Vircos]

Hope someone can help!
...
we are using any functions in queries such as TIME_FORMAT or DATE_FORMAT
...

Perhaps those functions are not supported by later versions of MySQL. We have faced similar problems with MS SQL Server 2000 and 2005 because of this.

[llyr]

Perhaps those functions are not supported by later versions of MySQL. We have faced similar problems with MS SQL Server 2000 and 2005 because of this.

But these functions work fine with both MySQL 5.0.33 and 5.1.48 using the current JDBC version in live which is 3.0.15. It's only when we've upgraded to JDBC version 5.1.10 that these functions then stop working in MYSQL 5.0.33.

Anyone with any ideas please?

[Vircos]

I think I do understand your problem now.

Within your form you use a table with a field named "TBLREPORTS2-DESCRIPTION". I assume that this field is a date field, correct?

If I do understand the documentation of MySQL correctly the TIME_FORMAT and DATE_FORMAT functions both returns a string.

So, if my assumption is right, you are trying to put a string into a date field and that will generate the error mentioned by you.

If you change the field "TBLREPORTS2-DESCRIPTION" from Date to Character your problem should be solved.

[llyr]

I think I do understand your problem now.

Within your form you use a table with a field named "TBLREPORTS2-DESCRIPTION". I assume that this field is a date field, correct?

If I do understand the documentation of MySQL correctly the TIME_FORMAT and DATE_FORMAT functions both returns a string.

So, if my assumption is right, you are trying to put a string into a date field and that will generate the error mentioned by you.

If you change the field "TBLREPORTS2-DESCRIPTION" from Date to Character your problem should be solved.

No, TBLREPORTS2-DESCRIPTION is a Char.

These forms have been working fine in live using JDBC version 3.0.15. It's since we've upgraded the JDBC drivers to 5.1.10 we've had these errors

[AJDulk]

These forms have been working fine in live using JDBC version 3.0.15. It's since we've upgraded the JDBC drivers to 5.1.10 we've had these errors

Maybe a silly question but, if the old JDBC drivers work and the new not, why do the upgrade?

[llyr]

Because we need to be able to execute stored procedures in MySQL. Can only do this with newer JDBC drivers....

[ehmd]

There appears to have been some changes introduced in Mysql 5.1 which may affect the DATE_FORMAT function and may produce different results to the 5.0 version.

These are documented at http://dev.mysql.com/doc/refman/5.1/en/ ... pport.html

Have you tried the 5.0.x version of the JDBC driver which is available from here ?

http://dev.mysql.com/downloads/connecto ... #downloads

This might resolve your problem for the 5.0.x issues but introduce problems in 5.1.

It's a while since I used Mysql in earnest but I would guess that there is some configuration discrepancy between the 5.0.x and 5.1.x in the storage and formatting of dates.