Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: Problem with JDBC driver and MySQL date_format function

Show all headers | View raw

In article <iqqdg9$lj7$1@news.albasani.net>, Lew <noone@lewscanon.com> 
wrote:

> On 05/16/2011 01:35 AM, Stanimir Stamenkov wrote:
> > Sun, 15 May 2011 19:51:49 -0400, /John B. Matthews/:
> >> In article <939s7hFsqnU1@mid.individual.net>, Hans Castorp wrote:
> >>> 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
> >>
> >> No, java.lang.Object looks like this: java.lang.Object@771c8a71
> >
> > That looks like the output of java.lang.Object.toString() invoked 
> > on a byte[] instance:
> >
> > getClass().getName() + '@' + Integer.toHexString(hashCode())
> >
> > http://download.oracle.com/javase/6/docs/api/java/lang/Object.html#toString%28%29
> >
> > http://download.oracle.com/javase/6/docs/api/java/lang/Class.html#getName%28%29
> 
> You guys are talking at cross purposes because you're using different 
> definitions of 'java.lang.Object.toString()'.  Stanimir means the 
> method as implemented in 'Object' and not overridden by 'byte[]'.  
> John means the method as applied to 'Object' itself.  Both of you are 
> correct.  Now you can stop arguing.

Stanimir: I never noticed the correspondence between the numeric 
portion and the result from hashCode(), but it's right there in the 
source, as quoted in the API. Thanks.

Lew: This looks like another good argument for continually reviewing 
APIs, even familiar ones.

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

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