Hi all, I am updating the Supported Database page (http://hibernate.bluemars.net/80.html) with the results of testing MSSQL and hibernate.
At any rate, I think I found the problem with the dates... SQL Server stores dates in this format: YYYY-MM-DD HH:MM:SS:milliseconds. So for example, this is a date: 2003-08-13 13:20:28.550. Now, if I do a query, but only have a string that looks like this: 'Aug 13 2003 1:20PM', then it won't find it. I would have to use a LIKE command. So, in running the FumTest, the SQL that fails looks like this: select string_, short_, date_, lastUpdated as lastUpda4_, fum, fo_string, fo_short, fo_date from Fum where string_ ='fum' and short_ =12 and date_ ='Aug 13 2003 1:20PM' Where as it should either use the LIKE command: select string_, short_, date_, lastUpdated as lastUpda4_, fum, fo_string, fo_short, fo_date from Fum where string_ ='fum' and short_ =12 and date_ LIKE 'Aug 13 2003 1:20PM' or be totally explicit: select string_, short_, date_, lastUpdated as lastUpda4_, fum, fo_string, fo_short, fo_date from Fum where string_ ='fum' and short_ =12 and date_ ='2003-08-13 13:20:28.550' Now, I am not sure if a date object pulled from hibernate, and saved back has this level of detail or not? I also don't quite understand how, if sql matches all the way to millisecond, but the conversion to Date object and back means that the same millisecond value is there how to every use date's as part of a composite key. The FumTest I *think* would work fine, except for the converting back and forth of Date objects to SQL dates and back again.. Maybe if you mapped the date object as a string instead? so when you get it and save it, you are just using strings? Eric Pugh ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
