db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeffrey Clary" <jcl...@actuate.com>
Subject RE: Running test suites and interpreting results
Date Tue, 27 Mar 2007 14:24:57 GMT
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: V.Narayanan@Sun.COM [mailto:V.Narayanan@Sun.COM] 
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) );
>>   
>


Mime
View raw message