I just wanted to thank everyone for their input and let you know there was a
bug reported with the mysql team. I sent that info to my host so hopefully
they get the patch in. But I agree that it is much safer to handle the
formatting in the Java code. On the to do list...
vc_ace wrote:
>
> I
http://bugs.mysql.com/bug.php?id=20729
Is this the issue you are seeing? If you're stuck with a broken version of MySQL, seems like the thing to do is not use the date_format() function in your query, and then use Java code to format the date.
Jeff Butler
On 9/9/06, vc_ace <[EMAIL PROTECTED]>
Try mysql-4.1.19, it won’t
crash.
Zsolt
From: Clinton Begin
[mailto:[EMAIL PROTECTED]
Sent: Sunday, September 10, 2006
4:52 PM
To: user-java@ibatis.apache.org
Subject: Re: Ibatis crashing MySQL
when I use DATE_FORMAT
I agree with Brandon on
this oneespecially
Have you tried it from the mysql command line client? That's
interesting bug with MySQL that I'm sure they'd want to hear about :)
-Jerome
On 9/10/06, Clinton Begin <[EMAIL PROTECTED]> wrote:
I agree with Brandon on this oneespecially because it happens with
iBATIS 1.x and 2.x, which are a
I agree with Brandon on this oneespecially because it happens with iBATIS 1.x and 2.x, which are about as different as iBATIS vs. JDBC. I'd be very surprised if this turned out to be iBATIS. It's most likely the JDBC driver. Think about it this way though: _no_ client should be able to cras
I would encourage you to first try it with pure jdbc and run the exact sql statement that is executed. IBatis does nothing magical in regards to the database. It simply calls standard JDBC.Brandon
On 9/9/06, vc_ace <[EMAIL PROTECTED]> wrote:
This is very strange but it appears as though Ibatis is c
