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

Re: Problem with JDBC driver and MySQL date_format function

Path	csiph.com!x330-a1.tempe.blueboxinc.net!aioe.org!feeder.news-service.com!news.albasani.net!.POSTED!not-for-mail
From	Lew <noone@lewscanon.com>
Newsgroups	comp.lang.java.databases
Subject	Re: Problem with JDBC driver and MySQL date_format function
Date	Sun, 15 May 2011 06:59:24 -0400
Organization	albasani.net
Lines	38
Message-ID	<iqoblv$ugm$1@news.albasani.net> (permalink)
References	<9340c7F40hU1@mid.individual.net> <nospam-CC3166.18193614052011@news.aioe.org>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding	7bit
X-Trace	news.albasani.net wKyDw6CwSLl/346PBKg42eVzCkiBub9xopDXoMPOZiwU01b+2qJe0a1gMLVlqCmCDi3Hw6MJ/wAwfc9CSEXHra7TPFoa2AdTIMbadbOqgNjoUZBkh5T7Yl2S930kK3zG
NNTP-Posting-Date	Sun, 15 May 2011 10:59:11 +0000 (UTC)
Injection-Info	news.albasani.net; logging-data="m4RQaTgSKQdyi1qso/hCPNwos25J2HGRyMFzOI0kXLkxJMTu80WgAHNJkQ6i/wbN3Jj50CtpzU4p6ZwQX5Mmuuljf6/kuYAQm+HScmhZtSX1TTFRR60RnQmzYPmowm0o"; mail-complaints-to="abuse@albasani.net"
User-Agent	Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.17) Gecko/20110424 Thunderbird/3.1.10
In-Reply-To	<nospam-CC3166.18193614052011@news.aioe.org>
Cancel-Lock	sha1:BhRESE13qw68ca+264z1RmenFaM=
Xref	x330-a1.tempe.blueboxinc.net comp.lang.java.databases:445

Show key headers only | View raw

On 05/14/2011 06:19 PM, John B. Matthews wrote:
> 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.

We need to see code, otherwise we're pissing into the wind.

Best would be an SSCCE.
<http://sscce.org/>

-- 
Lew
Honi soit qui mal y pense.
http://upload.wikimedia.org/wikipedia/commons/c/cf/Friz.jpg

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