sqlserver testing

[Tore Halset <ha...@pvv.ntnu.no>]

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!

Re: sqlserver testing

[Andrus Adamchik <an...@objectstyle.org>]

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!
>
>