MySQL date column conversion

[ericbrunson]

I'm getting the following error after upgrading MySQL form 4.0.x to 4.1.5:

javax.ejb.EJBException: Cannot convert value '2004-09-27 11:38:45' from column 40(2004-09-27 11:38:45 ) to DATE.
        at qcigs.ejb.AdminBean.getOrders(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)

I'm using mysql-connector-java-3.0.15

Do I need to upgrade my jdbc driver or is this something I can fix in my schema?

Thanks

 

[sedj]

How are you setting the Date field via JDBC ? Using the java.sql.Timestamp class ?

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[ericbrunson]

It was the class doing it automatically. It seems it was trying to convert a timestamp field to a date and puking. I converted the field to a datetime and the code works now, but I lose the benefits of a timestamp field in mysql.

 

[ericbrunson]

Can someone post me a simple snippet of how to set a mysql date field to the current date. So far I've waded through the manual pages for Date, Calendar, SimpleDateFormat, Java.sql, java.txt, java.util and about a dozen other pages. The simplest example I've found so far seems to involve about a 6 function calls and don't really work in my object structure.

Thanks

 

[sedj]

// eg with PreparedStatement
int index ...
PreparedStatement ps = ...
java.util.Date d = new java.util.Date();
long dNow = d.getTime();
java.sql.Timestamp ts = new java.sql.Timestamp(dNow);
ps.setTimestamp(index, ts);

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk