Hi,

I have the following problem with a java application:

Since I updated my mysql driver version 3 to version 5
(mysql-connector-java-5.1.7-bin.jar) I get funny strings like
"[B@b57546" when I format datetime columns with the date_format function
instead of the correct formatted date string.

Meanwhile I found out that this seems to be an issue that's known and
described here:

http://bugs.mysql.com/bug.php?id=32505

I checked it with DB Visualizer and I also get a BLOB there for "select
date_format(now(), '%Y%m%d')", for example.

The problem is: as long as I work on my local Windows Mysql DB version
5.0.67, everything is working fine; when I try on one of our both Linux
MySQL 5.0.27 DBs I get this problem.
As it is a customer system an update to the same version would be much
effort; what configuration settings should I check first to try to get
rid of this problem for the Linux DBs?

Thanks for any ideas
Jens

On 17-05-2011 21:48, Jens Riedel wrote:
This is a follow-up on a discussion in: comp.lang.java.databases

see:
http://groups.google.com/group/comp....d7860f23588d99


--
Luuk