db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Greg Monroe" <Greg.Mon...@DukeCE.com>
Subject RE: Status of the test project
Date Wed, 15 Nov 2006 22:59:33 GMT
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

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

     * Sybase (and MSSQL) doesn't define a default escape character.
     * @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

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


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

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

View raw message