Re: sqlserver testing

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Sat Jul 05 2008 - 15:33:37 EDT

  • Next message: Andrey Razumovsky (JIRA): "[jira] Updated: (CAY-1077) ObjRelationship Mapping Dialog Improvements"

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



    This archive was generated by hypermail 2.0.0 : Sat Jul 05 2008 - 15:34:09 EDT