Hi there,

I'm using the mysql-connector version 3.0.15-ga, and server 4.1.4-gamma-standard-log. I'm finding that I can't retrieve TIMESTAMP columns, and get the following exception:

Exception in thread "main" java.sql.SQLException: Cannot convert value '2004-09-20 00:00:00' from column 1(2004-09-20 00:00:00 ) to DATE. at com.mysql.jdbc.ResultSet.getDate(ResultSet.java:1036) at com.mysql.jdbc.ResultSet.getDate(ResultSet.java:905) at com.mysql.jdbc.ResultSet.getDate(ResultSet.java:919) at DateTest.main(DateTest.java:36)

I've made a simple standalone class that shows this behavoiour, the main function of which is as follows:

public static void main(String args[]) throws Exception { Connection dbConn = getConnection(); PreparedStatement dbQuery; ResultSet dbResult;

/* Create table */ dbQuery = dbConn.prepareStatement( "CREATE TABLE test ( val TIMESTAMP )"); dbQuery.executeUpdate(); dbQuery.close();

/* Insert value */ dbQuery = dbConn.prepareStatement( "INSERT INTO test(val) VALUES(?)"); dbQuery.setDate(1, new Date(System.currentTimeMillis())); dbQuery.executeUpdate(); dbQuery.close();

/* Select value */ dbQuery = dbConn.prepareStatement( "SELECT val AS v FROM test"); dbResult = dbQuery.executeQuery();

if(dbResult.first()) { do { System.out.println(dbResult.getDate("v").toString()); } while(dbResult.next()); }

dbQuery.close(); dbConn.close(); }

If I try using the 3.1.4-beta connector, I find that the above test is okay and I get no exception and the expected output. I'd really like to not use the beta connector in a production environment though. I was wondering, are there plans to back port the fix to get the .15-ga connector to work with the 4.1.4-gamma server?

Thanks,

Mike