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


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

Re: Problem with JDBC driver and MySQL date_format function

From Jens Riedel <JensRie@gmx.de>
Newsgroups comp.lang.java.databases
Subject Re: Problem with JDBC driver and MySQL date_format function
Date 2011-05-15 21:17 +0200
Message-ID <93an6mFmd3U1@mid.individual.net> (permalink)
References <9340c7F40hU1@mid.individual.net>

Show all headers | View raw


Thanks for your answers so far.
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

Back to comp.lang.java.databases | Previous | NextPrevious 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