Breaking java/mysql mapping

1 Sep

I was receiving the following error in my Tomcat logs:

— The error occurred in org/imvs/qc/server/dao/ibatis/maps/Result.xml.
— The error occurred while applying a result map.
— Check the Result.materialLotNumberFromResultByTestInstrument.
— Check the result mapping for the 'lotNumbers' property.
— Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in org/imvs/qc/server/dao/ibatis/maps/Result.xml.
— The error occurred while applying a result map.
— Check the getLotNumberByMaterialIdLotNumberId-AutoResultMap.
— Check the result mapping for the 'expiryDate' property.
— Cause: java.sql.SQLException: Cannot convert value '2006-03-16 09:53:58' from column 3(2006-03-16 09:53:58 ) to TIMESTAMP. Caused by: java.sql.SQLException: Cannot convert value '2006-03-16 09:53:58' from column 3(2006-03-16 09:53:58 ) to TIMESTAMP.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in org/imvs/qc/server/dao/ibatis/maps/Result.xml.

Its because java had been updated to jdk1.5.0_07 (from jdk1.5.0_03).

When we rolled it back, it worked again.

Looks like _07 breaks some java-mysql connector things.

(We tried both mysql-connector-java-3.0.x and mysql-connector-java-3.1.x)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: