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

Re: Problem with JDBC driver and MySQL date_format function

Path	csiph.com!x330-a1.tempe.blueboxinc.net!aioe.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From	Hans Castorp <REWYRLXHEGHO@spammotel.com>
Newsgroups	comp.lang.java.databases
Subject	Re: Problem with JDBC driver and MySQL date_format function
Date	Sun, 15 May 2011 13:37:30 +0200
Lines	12
Message-ID	<939s7hFsqnU1@mid.individual.net> (permalink)
References	<9340c7F40hU1@mid.individual.net>
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding	7bit
X-Trace	individual.net sfbeib8ytqj11twOcF/2uQOH9GesqhrXb6uiAmZrree53s58I=
Cancel-Lock	sha1:wFwOr9b7kDyiF8GqcHwz+O5WPy0=
User-Agent	Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666
In-Reply-To	<9340c7F40hU1@mid.individual.net>
Xref	x330-a1.tempe.blueboxinc.net comp.lang.java.databases:446

Show key headers only | View raw

Jens Riedel wrote on 13.05.2011 08:11:
> 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.
>

That sure looks like the default toString() output of java.lang.Object

What exactly are you passing to the date_format() function?
Show us your SQL statement and the Java code

Back to comp.lang.java.databases | Previous | Next — Previous in thread | Next in thread | Find similar

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