Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Developers List" <torque-dev@db.apache.org>
Received-SPF: pass (herse.apache.org: domain of Greg.Monroe@dukece.com
 designates 65.112.55.73 as permitted sender)
Content-Class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Status of the test project
Date: Wed, 15 Nov 2006 17:59:33 -0500
Message-ID: <8F5843B903F59D4C8C6806BB49A3911901E9281F@dukece-mail3.dukece.com>
In-Reply-To: <20061115141530.T99116@minotaur.apache.org>
Thread-Topic: Status of the test project
Thread-Index: AccJBfm1jEY4lRZfSSC9d030NVj3AwAAgndQ
From: "Greg Monroe" <Greg.Monroe@DukeCE.com>
To: "Apache Torque Developers List" <torque-dev@db.apache.org>

Just ran tests on MS-SQL 2000 and it almost worked... it fails
looking for author 'a\\c' rather than 'a\c' (before the LIKE
tests).=20

I found that the '\' was being escaped by SqlExpression and it
will pass all the tests, if you add the following to the=20
DBSybase.java adaptor:

    /**
     * Sybase (and MSSQL) doesn't define a default escape character.
     *=20
     * @see org.apache.torque.adapter.AbstractDBAdapter#escapeText()
     */
    public boolean escapeText()
    {
        return false;
    }

Re: Derby

Just to see if it worked, I created a patched Village that ignored
the isReadOnly() meta-data flag and used this against a NetServer
install.

Derby passed all the tests using the V10.2.1.6 JDBC driver/server.
(Didn't test the older version).

I also did what I think you did and tested the Embedded driver by
running the DB create, Table setup, and then test cases as individual
steps. (commenting out stuff in the maven.xml). Everything ran fine
here.

=20

> -----Original Message-----
> From: Thomas Fischer [mailto:tfischer@apache.org]=20
> Sent: Wednesday, November 15, 2006 5:32 PM
> To: Apache Torque Developers List
> Subject: RE: Status of the test project
>=20
>=20
> > Ok, I have applied most of the changes in Torque-64 and now the test
> > project runs through for mysql 5, mysql 4.1 and postgresql.
> > Hsqldb fail on
> > the escaping test, and oracle and derby run into the same
> > strange error:
> >      [junit] Cannot delete test data for LargeSelectTest.
> >      [junit] junit.framework.AssertionFailedError: Cannot
> > delete test data
> > for LargeSelectTest.
> >
> > Firebird fails on the BooleanSelect test.
>=20
> Most of the issues are resolved now. HSQL and Firebird=20
> adaptors now handle=20
> escaping correctly; I also changed the mssql adaptor, maybe this also=20
> works now. The oracle problem was due to a wrong driver class=20
> name in the=20
> test profiles, this is fixed. The derby problem is that it=20
> does not shut=20
> down the database correctly after one test and then cannot=20
> restart the=20
> database on the next test. So the first test always works, the second=20
> fails. I did not find a solution for this, a workaround is to run the=20
> tests manually one after another from eclipse.
>=20
> The trouble with the BooleanSelectTest and firebird is that=20
> firebird does=20
> not handle self-joins correctly, so I skipped that particular=20
> test for=20
> firebird. But there is other trouble with firebird resp.=20
> interbase. It=20
> does not create the ifc_table (I still have to find out why,=20
> it seems that=20
> the trouble is an addditional comma in te create table=20
> statement) and it=20
> also fails on the data dump task.
>=20
> I'll try to find and fix that trouble in the next few days.
>=20
>       Thomas
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-dev-help@db.apache.org
>=20
>=20

Duke CE Privacy Statement
Please be advised that this e-mail and any files transmitted with it are =
confidential communication or may otherwise be privileged or =
confidential and are intended solely for the individual or entity to =
whom they are addressed.  If you are not the intended recipient you may =
not rely on the contents of this email or any attachments, and we ask =
that you  please not read, copy or retransmit this communication, but =
reply to the sender and destroy the email, its contents, and all copies =
thereof immediately.  Any unauthorized dissemination, distribution or =
copying of this communication is strictly prohibited.


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org