Is it possible to deploy somwhere Oracle Database Express Edition and run Hudsun Unit test on it? Better if it will be near Hudson builder.... could Apache provide some server for that purposes? Of couse I can deploy Oracle server at my home computer but this Hudson test are not going to be stable :)
Just thoughts... it's really cool that we are adding new DBs but it's sad that we don't try most popular and serious among them. In production are usually used Oracle, MS SQL, DB2 and Sybase. My gol is to provide support of this data bases. Evgeny. -----Original Message----- From: Andrus Adamchik [mailto:[email protected]] Sent: Friday, December 11, 2009 4:00 PM To: [email protected] Subject: Re: Hudson unit test runs I agree with the general statement (and indeed on many DB's we suppress certain tests, as the DB simply doesn't provide needed capability). But I think we need to classify this specific case differently, since Cayenne can still potentially generate the right single column SQL in this case. Andrus On Dec 11, 2009, at 7:52 AM, Andrey Razumovsky wrote: > We're testing Cayenne, not Derby.. Derby limitations is not our > fault.. > ideally we should exclude that per DB, but I'd prefer that until we > have > such mechanism in our test framework, tests stiil run fine > > 2009/12/11 Andrus Adamchik <[email protected]> > >> >> On Dec 11, 2009, at 3:32 AM, Andrey Razumovsky wrote: >> >> OK, may I suggest we just slightly change the test, so that it >> works on >>> Derby as well. Current problem is that Derby does not allow more >>> than one >>> column in subquery result. >>> So if wwe replace >>> "SELECT a FROM Artist a WHERE EXISTS (SELECT DISTINCT p1 ...) " >>> with >>> "SELECT a FROM Artist a WHERE EXISTS (SELECT DISTINCT >>> p1.paintingTitle >>> ...) >>> " >>> >>> it will work with same sense >>> >> >> Then how do we know that the other syntax variant is broken? >> >> We clearly need an exclude list per DB... >> >> Andrus >> >> > > > -- > Andrey
