Thanks for the pointers so far. I've got several JDKs on my system, and I verified that I was indeed running 1.6. I modified my environment and rebuilt everything using 1.4 (I think). Meanwhile I also set the jdk16 property in ant.properties. I still seem to be getting the same results from derbyall. Many of the test cases run fine, but the same set fails. It sure seems like I am probably missing something simple.
Here is the contents of my ant.properties file: j14lib=C:/j2sdk1.4.2_13/jre/lib jdk16=C:/Program Files/Java/jdk1.6.0 sane=false Here is what happened when I tried to run just the jdk14 test suite: C:\projects\svn\derby-testing2>java -version java version "1.4.2_13" Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_13-b06) Java HotSpot(TM) Client VM (build 1.4.2_13-b06, mixed mode) C:\projects\svn\derby-testing2>java org.apache.derbyTesting.functionTests.harness.RunSuite jdbc4 Top suite: jdbc4 Suite to run: jdbc4:jdbc4 Now do RunList Suite runall file not found for jdbc4 Generated report: jdbc4_report.txt -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 26, 2007 10:27 AM To: derby-dev@db.apache.org Subject: Re: Running test suites and interpreting results If derbyall takes a long time to run, please set the jdk16 variable and run the jdbc4 suite alone. You can do this by java org.apache.derbyTesting.functionTests.harness.RunSuite jdbc4 and check if the failures occur. If they don't then you can continue with derbyall. Hope this helps! :-) Narayanan V Narayanan wrote: > Hi Jeffrey, > > From what you have pasted you seem to be running with 1.6. While doing > a build of the code base can you check if you have set the jdk16 > property in ant.properties file? If you have not done so can you do it > and run derbyall again and check if you are getting the failures you > have mentioned? > > My guess is you have not built with jdk16 variable but are trying to > run the tests with 1.6. > > Can you please confirm this? > > Narayanan > > Jeffrey Clary wrote: >> I could use some hints getting my basic build/test environment set up. >> I am getting the code as documented using "svn co >> https://svn.apache.org/repos/asf/db/derby/code/trunk derby" and building >> successfully. I invoke ant all, ant testing, and ant buildjars without >> errors. >> >> I'm trying to run the derbyall test suite based on what I read at >> http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/README.htm >> ?view=co, but I think I still don't have something set up properly. I >> get a lot of test files listed in derbyall_fail.txt (listed at the >> bottom of this message). Derbyall_diff.txt is too long to attach, but I >> have clipped the first few lines from it. It looks like I might be >> missing an SQL script and the toursDB demo database is not getting built >> properly. >> >> I'm going to go dig into checkToursDB.java when I get a chance, but if >> someone can point out something silly I might be missing, it would save >> me some time. >> >> Thanks, >> Jeff >> >> >> >> >> Here is derbyall_fail.txt: >> >> derbyall/demo/demo.fail:demo/checkToursDB.java >> derbyall/derbyall.fail:jdbcapi/metadata.java >> derbyall/derbyall.fail:jdbcapi/odbc_metadata.java >> derbyall/derbyall.fail:lang/closed.java >> derbyall/derbyall.fail:lang/grantRevokeDDL2.sql >> derbyall/derbyall.fail:lang/procedureInTrigger.sql >> derbyall/derbyall.fail:lang/releaseCompileLocks.sql >> derbyall/derbyall.fail:jdbc4/TestConnectionMethods.java >> derbyall/derbyall.fail:jdbc4/TestDbMetaData.java >> derbyall/derbyall.fail:jdbc4/TestJDBC40Exception.java >> derbyall/derbyall.fail:jdbc4/TestPreparedStatementMethods.java >> derbyall/derbyall.fail:jdbc4/TestResultSetMethods.java >> derbyall/derbyall.fail:jdbc4/AutoloadBooting.junit >> derbyall/derbyall.fail:jdbc4/AutoloadTest.junit >> derbyall/derbyall.fail:jdbc4/VerifySignatures.junit >> derbyall/derbyall.fail:jdbc4/_Suite.junit >> derbyall/derbyall.fail:jdbcapi/dbMetaDataJdbc30.java >> derbyall/derbyall.fail:upgradeTests/Upgrade_10_1_10_2.java >> derbyall/derbynetclientmats/derbynetclientmats.fail:junitTests/derbyNet/ >> CompatibilityTest.java >> derbyall/derbynetclientmats/derbynetclientmats.fail:jdbc4/TestConnection >> Methods.java >> derbyall/derbynetclientmats/derbynetclientmats.fail:jdbc4/TestPreparedSt >> atementMethods.java >> derbyall/derbynetclientmats/derbynetclientmats.fail:jdbc4/TestResultSetM >> ethods.java >> derbyall/derbynetclientmats/derbynetclientmats.fail:jdbc4/AutoloadBootin >> g.junit >> derbyall/derbynetclientmats/derbynetclientmats.fail:jdbc4/AutoloadTest.j >> unit >> derbyall/derbynetclientmats/derbynetclientmats.fail:jdbc4/VerifySignatur >> es.junit >> derbyall/derbynetclientmats/derbynetclientmats.fail:jdbc4/_Suite.junit >> derbyall/derbynetclientmats/derbynetmats.fail:derbynet/NSinSameJVM.java >> derbyall/derbynetclientmats/derbynetmats.fail:derbynet/checkSecMgr.java >> derbyall/derbynetclientmats/derbynetmats.fail:derbynet/testProperties.ja >> va >> derbyall/derbynetclientmats/derbynetmats.fail:jdbcapi/metadata.java >> derbyall/derbynetclientmats/derbynetmats.fail:jdbcapi/odbc_metadata.java >> derbyall/derbynetclientmats/derbynetmats.fail:lang/procedure.java >> derbyall/derbynetclientmats/derbynetmats.fail:tools/importExport.java >> derbyall/derbynetclientmats/derbynetmats.fail:tools/ieptests.sql >> derbyall/derbynetclientmats/derbynetmats.fail:jdbcapi/dbMetaDataJdbc30.j >> ava >> >> >> >> Here are the first few lines of derbyall_diff.txt: >> >> ********* Diff file derbyall/demo/demo/checkToursDB.diff >> *** Start: checkToursDB jdk1.6.0 demo:demo 2007-03-23 11:08:35 *** >> 1 del >> < CONNECTION0* - jdbc:derby:toursDB >> 2 del >> < * = current connection >> 3 del >> < ij> -- Licensed to the Apache Software Foundation (ASF) under one or >> more >> 4 del >> < -- contributor license agreements. See the NOTICE file distributed >> with >> 5 del >> < -- this work for additional information regarding copyright ownership. >> 6 del >> < -- The ASF licenses this file to You under the Apache License, Version >> 2.0 >> 7 del >> < -- (the "License"); you may not use this file except in compliance >> with >> 8 del >> < -- the License. You may obtain a copy of the License at >> 9 del >> < -- >> 10 del >> < -- http://www.apache.org/licenses/LICENSE-2.0 >> 11 del >> < -- >> 12 del >> < -- Unless required by applicable law or agreed to in writing, software >> 13 del >> < -- distributed under the License is distributed on an "AS IS" BASIS, >> 14 del >> < -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or >> implied. >> 15 del >> < -- See the License for the specific language governing permissions and >> 16 del >> < -- limitations under the License. >> 17 del >> < CREATE TABLE AIRLINES >> 18 del >> < ( >> 19 del >> < AIRLINE CHAR(2) NOT NULL , >> 20 del >> < AIRLINE_FULL VARCHAR(24), >> 21 del >> < BASIC_RATE DOUBLE PRECISION, >> 22 del >> < DISTANCE_DISCOUNT DOUBLE PRECISION, >> 23 del >> < BUSINESS_LEVEL_FACTOR DOUBLE PRECISION, >> 24 del >> < FIRSTCLASS_LEVEL_FACTOR DOUBLE PRECISION, >> 25 del >> < ECONOMY_SEATS INTEGER, >> 26 del >> < BUSINESS_SEATS INTEGER, >> 27 del >> < FIRSTCLASS_SEATS INTEGER >> 28 del >> < ); >> 29 del >> < 0 rows inserted/updated/deleted >> 30 del >> < ij> ALTER TABLE AIRLINES >> 31 del >> < ADD CONSTRAINT AIRLINES_PK Primary Key ( >> 32 del >> < AIRLINE); >> 33 del >> < 0 rows inserted/updated/deleted >> 34 del >> < ij> -- \************************************************************\ >> 35 del >> < CREATE TABLE COUNTRIES >> 36 del >> < ( >> 37 del >> < COUNTRY VARCHAR(26) NOT NULL, >> 38 del >> < COUNTRY_ISO_CODE CHAR(2) NOT NULL , >> 39 del >> < REGION VARCHAR(26) >> 40 del >> < ); >> 41 del >> < 0 rows inserted/updated/deleted >> 42 del >> < ij> ALTER TABLE COUNTRIES >> 43 del >> < ADD CONSTRAINT COUNTRIES_PK Primary Key ( >> 44 del >> < COUNTRY_ISO_CODE); >> 45 del >> < 0 rows inserted/updated/deleted >> 46 del >> < ij> ALTER TABLE COUNTRIES >> 47 del >> < ADD CONSTRAINT COUNTRIES_UNQ_NM Unique ( >> 48 del >> < COUNTRY); >> 49 del >> < 0 rows inserted/updated/deleted >> 50 del >> < ij> ALTER TABLE COUNTRIES >> 51 del >> < ADD CONSTRAINT COUNTRIES_UC >> 52 del >> < CHECK (country_ISO_code = upper(country_ISO_code) ); >> >
