db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject RE: Status of the test project
Date Thu, 16 Nov 2006 09:07:50 GMT
Thanks, Greg. I'll change the Sybase adapter.

      Thomas

"Greg Monroe" <Greg.Monroe@DukeCE.com> schrieb am 15.11.2006 23:59:33:

> 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).
>
> 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
> 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.
>
>
>
> > -----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
>


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


Mime
View raw message