Also,
If we know that certain tests won't pass with MSSQL, can we do for those
tests what we do in MasterDetailTest.testIncomingOutgoing and do:
if (dialect instanceof SybaseDialect) return;
??
At least that way all the tests would run, with the caveat that certain
understood things won't work with Hibernate.
Eric
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Eric
Pugh
Sent: Wednesday, August 13, 2003 1:48 PM
To: [EMAIL PROTECTED]
Subject: [Hibernate] Closer to Date problem with MSSQL
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
-------------------------------------------------------
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
