You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openjpa.apache.org by al...@apache.org on 2013/02/13 16:14:07 UTC
svn commit: r1445652 - in /openjpa/branches/2.1.x/openjpa-integration/tck: sql/db2.sql tck2-20110815.xml

Author: allee8285
Date: Wed Feb 13 15:14:06 2013
New Revision: 1445652

URL: http://svn.apache.org/r1445652
Log:
OPENJPA-2326 - Fixed StoreCharAsInteger property for DB2.

Modified:
    openjpa/branches/2.1.x/openjpa-integration/tck/sql/db2.sql
    openjpa/branches/2.1.x/openjpa-integration/tck/tck2-20110815.xml

Modified: openjpa/branches/2.1.x/openjpa-integration/tck/sql/db2.sql
URL: http://svn.apache.org/viewvc/openjpa/branches/2.1.x/openjpa-integration/tck/sql/db2.sql?rev=1445652&r1=1445651&r2=1445652&view=diff
==============================================================================
--- openjpa/branches/2.1.x/openjpa-integration/tck/sql/db2.sql (original)
+++ openjpa/branches/2.1.x/openjpa-integration/tck/sql/db2.sql Wed Feb 13 15:14:06 2013
@@ -1,4 +1,175 @@
 -- =======================================================================
+-- Drop All tables and recreate using default SynchronziedMappings properties
+DROP TABLE ACCOUNT  !
+DROP TABLE ACCOUNT !
+DROP TABLE ADDRESS!
+DROP TABLE AEC !
+DROP TABLE AEJB_1X1_BI_CASCADE!
+DROP TABLE AEJB_1X1_UNI_BTOB!
+DROP TABLE AEJB_1XM_BI_CASCADE!
+DROP TABLE AEJB_1XM_BI_DELETE!
+DROP TABLE AEJB_1XM_UNI_BTOB!
+DROP TABLE AEJB_MX1_UNI_DELETE!
+DROP TABLE AEJB_MXM_BI_BTOB!
+DROP TABLE AEJB_MXM_BI_DELETE!
+DROP TABLE AEJB_MXM_UNI_BTOB!
+DROP TABLE ALIAS_TABLE!
+DROP TABLE ANE_1XM_BI_BTOB !
+DROP TABLE ANNUALREVIEW !
+DROP TABLE A_ADDRESS!
+DROP TABLE A_BASIC !
+DROP TABLE BEANEJB_1X1_BI_BTOB!
+DROP TABLE BEANEJB_1X1_BI_CASCADE!
+DROP TABLE BEANEJB_1X1_UNI_BTOB!
+DROP TABLE BEANEJB_1XM_BI_BTOB!
+DROP TABLE BEANEJB_1XM_BI_CASCADE!
+DROP TABLE BEANEJB_1XM_BI_DELETE!
+DROP TABLE BEANEJB_1XM_UNI_BTOB!
+DROP TABLE BEANEJB_MX1_UNI_BTOB!
+DROP TABLE BEANEJB_MX1_UNI_DELETE!
+DROP TABLE BEANEJB_MXM_BI_BTOB!
+DROP TABLE BEANEJB_MXM_BI_DELETE!
+DROP TABLE BEANEJB_MXM_UNI_BTOB!
+DROP TABLE BEJB_1X1_BI_CASCADE!
+DROP TABLE BEJB_1X1_UNI_BTOB!
+DROP TABLE BEJB_1XM_BI_CASCADE!
+DROP TABLE BEJB_1XM_BI_DELETE!
+DROP TABLE BEJB_1XM_UNI_BTOB!
+DROP TABLE BEJB_MX1_UNI_DELETE!
+DROP TABLE BEJB_MXM_BI_BTOB!
+DROP TABLE BEJB_MXM_BI_DELETE!
+DROP TABLE BEJB_MXM_UNI_BTOB!
+DROP TABLE BIDIR1X1PERSON !
+DROP TABLE BIDIR1X1PROJECT !
+DROP TABLE BIDIR1XMPERSON !
+DROP TABLE BIDIR1XMPROJECT !
+DROP TABLE BIDIRMX1PERSON !
+DROP TABLE BIDIRMX1PROJECT !
+DROP TABLE BIDIRMXMPERSON !
+DROP TABLE BIDIRMXMPERSON_BIDIRMXMPROJECT !
+DROP TABLE BIDIRMXMPROJECT !
+DROP TABLE BNE_1XM_BI_BTOB !
+DROP TABLE BOOK !
+DROP TABLE BOOKSTORE !
+DROP TABLE B_EMBEDDABLE !
+DROP TABLE COFFEE !
+DROP TABLE COLTAB !
+DROP TABLE COLTAB_ADDRESS!
+DROP TABLE COMPANY !
+DROP TABLE COMPLAINT !
+DROP TABLE CONSUMER !
+DROP TABLE COURSE !
+DROP TABLE COURSE_2 !
+DROP TABLE COURSE_STUDENT!
+DROP TABLE CREDITCARD_TABLE!
+DROP TABLE CUBICLE !
+DROP TABLE CUSTOMER1 !
+DROP TABLE CUSTOMERS !
+DROP TABLE CUSTOMER_TABLE !
+DROP TABLE CUST_ORDER !
+DROP TABLE DATATYPES !
+DROP TABLE DATATYPES2 !
+DROP TABLE DEPARTMENT !
+DROP TABLE DEPARTMENT_2 !
+DROP TABLE DID1BDEPENDENT !
+DROP TABLE DID1BEMPLOYEE !
+DROP TABLE DID1DEPENDENT !
+DROP TABLE DID1EMPLOYEE !
+DROP TABLE DID2BDEPENDENT !
+DROP TABLE DID2BEMPLOYEE !
+DROP TABLE DID2DEPENDENT !
+DROP TABLE DID2EMPLOYEE !
+DROP TABLE DID3BDEPENDENT !
+DROP TABLE DID3BEMPLOYEE !
+DROP TABLE DID3DEPENDENT !
+DROP TABLE DID3EMPLOYEE !
+DROP TABLE DID4BMEDICALHISTORY !
+DROP TABLE DID4BPERSON !
+DROP TABLE DID4MEDICALHISTORY !
+DROP TABLE DID4PERSON !
+DROP TABLE DID5BMEDICALHISTORY !
+DROP TABLE DID5BPERSON !
+DROP TABLE DID5MEDICALHISTORY !
+DROP TABLE DID5PERSON !
+DROP TABLE DID6BMEDICALHISTORY !
+DROP TABLE DID6BPERSON !
+DROP TABLE DID6MEDICALHISTORY !
+DROP TABLE DID6PERSON !
+DROP TABLE EMPLOYEE !
+DROP TABLE EMPLOYEE_2 !
+DROP TABLE EMP_MAPKEYCOL !
+DROP TABLE ENROLLMENTS !
+DROP TABLE FKEYS_MXM_BI_BTOB!
+DROP TABLE FKEYS_MXM_BI_DELETE!
+DROP TABLE FKEYS_MXM_UNI_BTOB!
+DROP TABLE FKS_ALIAS_CUSTOMER!
+DROP TABLE GENERATOR_TABLE !
+DROP TABLE HARDWARE !
+DROP TABLE INSURANCE !
+DROP TABLE ITEM !
+DROP TABLE LAWBOOK !
+DROP TABLE LINEITEM_TABLE!
+DROP TABLE MEMBER !
+DROP TABLE MEMBER !
+DROP TABLE MOVIETICKET !
+DROP TABLE NAMEONLYINANNOTATION !
+DROP TABLE NAMEONLYINXML !
+DROP TABLE NAMEOVERRIDE !
+DROP TABLE NOENTITYANNOTATION !
+DROP TABLE NOENTITYLISTENER_TABLE !
+DROP TABLE ORDER_TABLE!
+DROP TABLE PARTTIMEEMPLOYEE !
+DROP TABLE PERSON !
+DROP TABLE PERSON_ANNUALREVIEW !
+DROP TABLE PERSON_INSURANCE !
+DROP TABLE PHONE_TABLE!
+DROP TABLE PKEY !
+DROP TABLE PRICED_PRODUCT_TABLE !
+DROP TABLE PRODUCT_DETAILS !
+DROP TABLE PRODUCT_TABLE !
+DROP TABLE PROJECT!
+DROP TABLE PROJECT_PERSON !
+DROP TABLE PURCHASE_ORDER !
+DROP TABLE RETAILORDER !
+DROP TABLE RETAILORDER1 !
+DROP TABLE RETAILORDER2 !
+DROP TABLE RETAILORDER_CONSUMER !
+DROP TABLE SEMESTER !
+DROP TABLE SEQUENCE !
+DROP TABLE STORE !
+DROP TABLE STUDENT !
+DROP TABLE STUDENT_2 !
+DROP TABLE STUDENT_2_COURSE_2 !
+DROP TABLE STUDENT_COURSE !
+DROP TABLE TEAM !
+DROP TABLE THEATRECOMPANY !
+DROP TABLE THEATRECOMPANY1 !
+DROP TABLE THEATRELOCATION !
+DROP TABLE THEATRELOCATION1 !
+DROP TABLE THEATRELOCATION_THEATRECOMPANY !
+DROP TABLE UNI1X1PERSON !
+DROP TABLE UNI1X1PROJECT !
+DROP TABLE UNI1XMPERSON !
+DROP TABLE UNI1XMPERSON !
+DROP TABLE UNI1XMPERSON_UNI1XMPROJECT !
+DROP TABLE UNI1XMPERSON_UNI1XMPROJECT !
+DROP TABLE UNI1XMPROJECT !
+DROP TABLE UNI1XMPROJECT !
+DROP TABLE UNIMX1PERSON !
+DROP TABLE UNIMX1PERSON !
+DROP TABLE UNIMX1PROJECT !
+DROP TABLE UNIMX1PROJECT !
+DROP TABLE UNIMXMPERSON !
+DROP TABLE UNIMXMPERSON_UNIMXMPROJECT !
+DROP TABLE UNIMXMPROJECT !
+DROP table FKS_ANOOP_CNOOP !
+DROP table INFO_TABLE !
+DROP table ORDER1 !
+DROP table ORDER2 !
+DROP table ORDER3 !
+DROP table SPOUSE_TABLE !
+
+-- =======================================================================
 -- com.sun.ts.tests.ejb30.persistence.entitytest.cascadeall.oneXone
 DROP TABLE AEJB_1X1_BI_BTOB !
 CREATE TABLE AEJB_1X1_BI_BTOB (id VARCHAR(255) NOT NULL, name VARCHAR(255), value INTEGER, PRIMARY KEY (id)) !

Modified: openjpa/branches/2.1.x/openjpa-integration/tck/tck2-20110815.xml
URL: http://svn.apache.org/viewvc/openjpa/branches/2.1.x/openjpa-integration/tck/tck2-20110815.xml?rev=1445652&r1=1445651&r2=1445652&view=diff
==============================================================================
--- openjpa/branches/2.1.x/openjpa-integration/tck/tck2-20110815.xml (original)
+++ openjpa/branches/2.1.x/openjpa-integration/tck/tck2-20110815.xml Wed Feb 13 15:14:06 2013
@@ -116,9 +116,7 @@ openjpa.FetchBatchSize: -1
 openjpa.Compatibility: StrictIdentityValues=true
 openjpa.Sequence: time
 openjpa.Log: ${openjpa.Log}
-openjpa.jdbc.DBDictionary: NumericTypeName="DECIMAL(18,2)"
-# openjpa.jdbc.DBDictionary: StoreCharsAsNumbers=true
-# openjpa.jdbc.DBDictionary: (StoreCharsAsNumbers=true,NumericTypeName=DECIMAL)
+openjpa.jdbc.DBDictionary: (StoreCharsAsNumbers=true,NumericTypeName="DECIMAL(18,2)")
 openjpa.jdbc.SchemaFactory: native(ForeignKeys=true)
 openjpa.jdbc.SynchronizeMappings: buildSchema(ForeignKeys=true)
 openjpa.ConnectionFactoryProperties: PrintParameters=True