Thanks, Greg. I'll change the Sybase adapter.
Thomas
"Greg Monroe" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]
> > 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
