Doing a query by date, where the date field is persisted as a varchar, fails to find the row. Looking at the logs I can see that values are inserted correctly, but it is searching in the wrong timezone, and formatting the date incorrectly. This leads me to believe that the query is not using the specified mapping to translate query parameters.
I am attempting to investigate this right now, but what would really help are a few pointers in the right direction.
A patch to the tests in SVN to demonstrate this issue will also be attached in a moment.
Below I also attach logged sql statements, that demonstrate the mis-match.
INSERT INTO g_pc_98mbjzp8_datecont (g_ia_sequence,g_ia_frozen,g_at_ovvtecif_date,g_at_2zj4at3w_identity,g_ia_version) VALUES (<2>,<false>,<'2009-08-09 14:17:01.000'>,<'9dc4f500-85bc-4fa2-a413-561b5759a60d'>,<1>)
SELECT 'com.assethouse.goya.test.bugs.bug166.DateContainer' AS JPOXMETADATA,this.g_ia_version,this.g_at_ovvtecif_date,this.g_at_2zj4at3w_identity,this.g_ia_frozen,this.g_ia_sequence FROM g_pc_98mbjzp8_datecont this WHERE this.g_at_ovvtecif_date = <2009-08-09 15:17:01.0>