Re: Ibatis crashing MySQL when I use DATE_FORMAT

2006-09-11 Thread vc_ace
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

Ibatis crashing MySQL when I use DATE_FORMAT

2006-09-09 Thread vc_ace
This is very strange but it appears as though Ibatis is crashing my MySql instance when I use the DATE_FORMAT function in SQL. Please note: it only crashes when I use a format string that resolves to text like %a (Abbreviated weekday name) , %b (Abbreviated month name). The problem doesn’t seem