Groups > comp.lang.java.databases > #444

Re: Problem with JDBC driver and MySQL date_format function

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From	"John B. Matthews" <nospam@nospam.invalid>
Newsgroups	comp.lang.java.databases
Subject	Re: Problem with JDBC driver and MySQL date_format function
Date	Sat, 14 May 2011 18:19:36 -0400
Organization	The Wasteland
Lines	32
Message-ID	<nospam-CC3166.18193614052011@news.aioe.org> (permalink)
References	<9340c7F40hU1@mid.individual.net>
NNTP-Posting-Host	LQJtZWzu+iKlBROuDg+IUg.user.speranza.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	7bit
X-Complaints-To	abuse@aioe.org
User-Agent	MT-NewsWatcher/3.5.3b3 (Intel Mac OS X)
X-Notice	Filtered by postfilter v. 0.8.2
Xref	x330-a1.tempe.blueboxinc.net comp.lang.java.databases:444

Show key headers only | View raw

In article <9340c7F40hU1@mid.individual.net>,
 Jens Riedel <JensRie@gmx.de> wrote:

> 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.
> 
> When I execute the statement with HeidiSQL or another DB client 
> directly everything is working fine, also when I switch back to 
> mysql-connector-java-3.1.12-bin.jar.
> 
> Does anybody know this problem and a solution for this?

I haven't used MySQL recently enough to give a specific answer, but 
incorrect character encoding is the first thing that leaps to mind. 
Unfortunately, the "funny strings" usually have a different appearance. 
What this _does_ look like is a reference to a byte array, mentioned 
here:

<http://stackoverflow.com/questions/2558031>

The "@b57546" part is akin to a memory pointer or handle. It is possible 
that the byte array contains the result for code points that are not 
decipherable using the character encoding in effect.

-- 
John B. Matthews
trashgod at gmail dot com
<http://sites.google.com/site/drjohnbmatthews>

Thread

Problem with JDBC driver and MySQL date_format function Jens Riedel <JensRie@gmx.de> - 2011-05-13 08:11 +0200
  Re: Problem with JDBC driver and MySQL date_format function "John B. Matthews" <nospam@nospam.invalid> - 2011-05-14 18:19 -0400
    Re: Problem with JDBC driver and MySQL date_format function Lew <noone@lewscanon.com> - 2011-05-15 06:59 -0400
  Re: Problem with JDBC driver and MySQL date_format function Hans Castorp <REWYRLXHEGHO@spammotel.com> - 2011-05-15 13:37 +0200
    Re: Problem with JDBC driver and MySQL date_format function "John B. Matthews" <nospam@nospam.invalid> - 2011-05-15 19:51 -0400
      Re: Problem with JDBC driver and MySQL date_format function Stanimir Stamenkov <s7an10@netscape.net> - 2011-05-16 08:35 +0300
        Re: Problem with JDBC driver and MySQL date_format function Lew <noone@lewscanon.com> - 2011-05-16 01:42 -0400
          Re: Problem with JDBC driver and MySQL date_format function "John B. Matthews" <nospam@nospam.invalid> - 2011-05-16 08:46 -0400
            Re: Problem with JDBC driver and MySQL date_format function Lew <noone@lewscanon.com> - 2011-05-16 10:23 -0400
  Re: Problem with JDBC driver and MySQL date_format function Jens Riedel <JensRie@gmx.de> - 2011-05-15 21:17 +0200

csiph-web