IIRC the last time I tested on SQLServer 2005. It was before the OUTER JOINS support. Currently I don't have access to SQLServer, so the OUTER JOIN stuff went untested against this DB. Now I guess I need to find it somewhere and see what's wrong.

Andrus


On Jul 5, 2008, at 10:04 PM, Tore Halset wrote:

Hello.

For some reason, DataContextEJBQLQueryTest hang when testing on sql server. I have tried with jtds and the jdbc driver for SQL Server 2005. The database I am testing on is SQL Server 2000. I had to delete that test to be able to continue.

I fixed add/drop null for merging, so all of the merge stuff should work for sqlserver now.

At the bottom, you will see the remaining fails.

The last two are for case sensitive searching. Perhaps the database I am testing on is configured wrong? We had some problems with this when we converted from MS SQL Server to PostgreSQL as searching is case sensitive in PostgreSQL.

- Tore.

framework/cayenne-jdk1.5-unpublished/target/surefire-reports/ org.apache.cayenne.access.DataContextEJBQLArrayResultTest.txt:Tests run: 3, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.179 sec <<< FAILURE! framework/cayenne-jdk1.5-unpublished/target/surefire-reports/ org.apache.cayenne.access.DataContextOuterJoinsTest.txt:Tests run: 4, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.206 sec <<< FAILURE! framework/cayenne-jdk1.5-unpublished/target/surefire-reports/ org .apache .cayenne .access .DataContextOuterJoinsTest .txt:testSelectWithOuterJoin (org.apache.cayenne.access.DataContextOuterJoinsTest) Time elapsed: 0.055 sec <<< FAILURE! framework/cayenne-jdk1.5-unpublished/target/surefire-reports/ org .apache .cayenne .access .DataContextOuterJoinsTest .txt:testSelectWithOuterJoinFromString (org.apache.cayenne.access.DataContextOuterJoinsTest) Time elapsed: 0.042 sec <<< FAILURE! framework/cayenne-jdk1.5-unpublished/target/surefire-reports/ org.apache.cayenne.query.SelectQueryTest.txt:Tests run: 27, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 1.145 sec <<< FAILURE! framework/cayenne-jdk1.5-unpublished/target/surefire-reports/ org .apache .cayenne .query .SelectQueryTest .txt:testSelectLikeCaseSensitive (org.apache.cayenne.query.SelectQueryTest) Time elapsed: 0.042 sec <<< FAILURE!



Reply via email to