openjpa-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From allee8...@apache.org
Subject svn commit: r1443753 - in /openjpa/trunk/openjpa-integration/tck: sql/db2.sql sql/derby.sql tck2-20110815.xml
Date Thu, 07 Feb 2013 22:10:44 GMT
Author: allee8285
Date: Thu Feb  7 22:10:43 2013
New Revision: 1443753

URL: http://svn.apache.org/r1443753
Log:
OPENJPA-2326: Remove table PROJECT in create.sql; add dictionary property Decimal(18,2) and
minor fixes.

Modified:
    openjpa/trunk/openjpa-integration/tck/sql/db2.sql
    openjpa/trunk/openjpa-integration/tck/sql/derby.sql
    openjpa/trunk/openjpa-integration/tck/tck2-20110815.xml

Modified: openjpa/trunk/openjpa-integration/tck/sql/db2.sql
URL: http://svn.apache.org/viewvc/openjpa/trunk/openjpa-integration/tck/sql/db2.sql?rev=1443753&r1=1443752&r2=1443753&view=diff
==============================================================================
--- openjpa/trunk/openjpa-integration/tck/sql/db2.sql (original)
+++ openjpa/trunk/openjpa-integration/tck/sql/db2.sql Thu Feb  7 22:10:43 2013
@@ -26,12 +26,11 @@ CREATE INDEX I_BJMX1TB_A1 ON BEJB_MX1_UN
 -- ALTER TABLE BEJB_MX1_UNI_BTOB ADD CONSTRAINT FK_FOR_AEJB_MX1_UN FOREIGN KEY (FK_FOR_AEJB_MX1_UNI_BTOB)
REFERENCES AEJB_MX1_UNI_BTOB (ID) !
 
 -- =======================================================================
---
-DROP TABLE PROJECT!
-CREATE TABLE PROJECT (PROJID INT NOT NULL, NAME VARCHAR(25), BUDGET DECIMAL(18,0), CONSTRAINT
PK_PROJECT PRIMARY KEY (PROJID))!
+-- com/sun/ts/tests/ejb30/persistence/entitytest/biginteger
+DROP TABLE A_BIGINTEGER !
+CREATE TABLE A_BIGINTEGER ( ID VARCHAR(255), NAME VARCHAR(255) , VALUE INT, BASICINTEGER
INT, BASICSHORT SMALLINT, BASICBIGSHORT SMALLINT, BASICFLOAT FLOAT, BASICBIGFLOAT FLOAT, BASICLONG
BIGINT, BASICBIGLONG BIGINT, BASICDOUBLE DOUBLE, BASICBIGDOUBLE DOUBLE, BASICCHAR INTEGER,
BASICCHARARRAY VARCHAR(448), BASICBIGCHARARRAY VARCHAR(448), BASICBYTEARRAY  LONG VARCHAR
FOR BIT DATA, BASICBIGBYTEARRAY LONG VARCHAR FOR BIT DATA, BASICBIGINTEGER DECIMAL(18,0) PRIMARY
KEY NOT NULL, BASICBIGDECIMAL DECIMAL(18,0), BASICDATE DATE, BASICTIME TIME, BASICCALENDAR
DATE, BASICTIMESTAMP TIMESTAMP ) !
 
 -- =======================================================================
--- DROP TABLE A_BIGINTEGER!
--- CREATE TABLE A_BIGINTEGER ( ID VARCHAR(255), NAME VARCHAR(255) , VALUE INT, BASICINTEGER
INT, BASICSHORT SMALLINT, BASICBIGSHORT SMALLINT, BASICFLOAT FLOAT, BASICBIGFLOAT FLOAT, BASICLONG
BIGINT, BASICBIGLONG BIGINT, BASICDOUBLE DOUBLE, BASICBIGDOUBLE DOUBLE, BASICCHAR CHAR, BASICCHARARRAY
VARCHAR(448), BASICBIGCHARARRAY VARCHAR(448), BASICBYTEARRAY  LONG VARCHAR FOR BIT DATA, BASICBIGBYTEARRAY
LONG VARCHAR FOR BIT DATA, BASICBIGINTEGER DECIMAL(18,0) PRIMARY KEY NOT NULL, BASICBIGDECIMAL
DECIMAL(18,0), BASICDATE DATE, BASICTIME TIME, BASICCALENDAR DATE, BASICTIMESTAMP TIMESTAMP
)!
--- DROP TABLE A_BIGDECIMAL!
--- CREATE TABLE A_BIGDECIMAL ( ID VARCHAR(255), NAME VARCHAR(255) , VALUE INT, BASICINTEGER
INT, BASICSHORT SMALLINT, BASICBIGSHORT SMALLINT, BASICFLOAT FLOAT, BASICBIGFLOAT FLOAT, BASICLONG
BIGINT, BASICBIGLONG BIGINT, BASICDOUBLE DOUBLE, BASICBIGDOUBLE DOUBLE, BASICCHAR CHAR, BASICCHARARRAY
VARCHAR(448), BASICBIGCHARARRAY VARCHAR(448), BASICBYTEARRAY  LONG VARCHAR FOR BIT DATA, BASICBIGBYTEARRAY
LONG VARCHAR FOR BIT DATA, BASICBIGINTEGER DECIMAL(18,0), BASICBIGDECIMAL DECIMAL(18,0) PRIMARY
KEY NOT NULL, BASICDATE DATE, BASICTIME TIME, BASICCALENDAR DATE, BASICTIMESTAMP TIMESTAMP
)!
+-- com/sun/ts/tests/ejb30/persistence/entitytest/bigdecimal
+DROP TABLE A_BIGDECIMAL !
+CREATE TABLE A_BIGDECIMAL ( ID VARCHAR(255), NAME VARCHAR(255) , VALUE INT, BASICINTEGER
INT, BASICSHORT SMALLINT, BASICBIGSHORT SMALLINT, BASICFLOAT FLOAT, BASICBIGFLOAT FLOAT, BASICLONG
BIGINT, BASICBIGLONG BIGINT, BASICDOUBLE DOUBLE, BASICBIGDOUBLE DOUBLE, BASICCHAR INTEGER,
BASICCHARARRAY VARCHAR(448), BASICBIGCHARARRAY VARCHAR(448), BASICBYTEARRAY  LONG VARCHAR
FOR BIT DATA, BASICBIGBYTEARRAY LONG VARCHAR FOR BIT DATA, BASICBIGINTEGER DECIMAL(18,0),
BASICBIGDECIMAL DECIMAL(18,0) PRIMARY KEY NOT NULL, BASICDATE DATE, BASICTIME TIME, BASICCALENDAR
DATE, BASICTIMESTAMP TIMESTAMP ) !

Modified: openjpa/trunk/openjpa-integration/tck/sql/derby.sql
URL: http://svn.apache.org/viewvc/openjpa/trunk/openjpa-integration/tck/sql/derby.sql?rev=1443753&r1=1443752&r2=1443753&view=diff
==============================================================================
--- openjpa/trunk/openjpa-integration/tck/sql/derby.sql (original)
+++ openjpa/trunk/openjpa-integration/tck/sql/derby.sql Thu Feb  7 22:10:43 2013
@@ -26,12 +26,11 @@ CREATE INDEX I_BJMX1TB_A1 ON BEJB_MX1_UN
 -- ALTER TABLE BEJB_MX1_UNI_BTOB ADD CONSTRAINT FK_FOR_AEJB_MX1_UN FOREIGN KEY (FK_FOR_AEJB_MX1_UNI_BTOB)
REFERENCES AEJB_MX1_UNI_BTOB (ID) ;
 
 -- =======================================================================
--- 
-DROP TABLE PROJECT;
-CREATE TABLE PROJECT (PROJID INT NOT NULL, NAME VARCHAR(25), BUDGET DECIMAL(18,0), CONSTRAINT
PK_PROJECT PRIMARY KEY (PROJID));
+-- com/sun/ts/tests/ejb30/persistence/entitytest/biginteger
+DROP TABLE A_BIGINTEGER ;
+CREATE TABLE A_BIGINTEGER ( ID VARCHAR(255), NAME VARCHAR(255) , VALUE INT, BASICINTEGER
INT, BASICSHORT SMALLINT, BASICBIGSHORT SMALLINT, BASICFLOAT FLOAT, BASICBIGFLOAT FLOAT, BASICLONG
BIGINT, BASICBIGLONG BIGINT, BASICDOUBLE DOUBLE, BASICBIGDOUBLE DOUBLE, BASICCHAR INTEGER,
BASICCHARARRAY VARCHAR(448), BASICBIGCHARARRAY VARCHAR(448), BASICBYTEARRAY  LONG VARCHAR
FOR BIT DATA, BASICBIGBYTEARRAY LONG VARCHAR FOR BIT DATA, BASICBIGINTEGER DECIMAL(18,0) PRIMARY
KEY NOT NULL, BASICBIGDECIMAL DECIMAL(18,0), BASICDATE DATE, BASICTIME TIME, BASICCALENDAR
DATE, BASICTIMESTAMP TIMESTAMP ) ;
 
 -- =======================================================================
--- DROP TABLE A_BIGINTEGER;
--- CREATE TABLE A_BIGINTEGER ( ID VARCHAR(255), NAME VARCHAR(255) , VALUE INT, BASICINTEGER
INT, BASICSHORT SMALLINT, BASICBIGSHORT SMALLINT, BASICFLOAT FLOAT, BASICBIGFLOAT FLOAT, BASICLONG
BIGINT, BASICBIGLONG BIGINT, BASICDOUBLE DOUBLE, BASICBIGDOUBLE DOUBLE, BASICCHAR CHAR, BASICCHARARRAY
VARCHAR(448), BASICBIGCHARARRAY VARCHAR(448), BASICBYTEARRAY  LONG VARCHAR FOR BIT DATA, BASICBIGBYTEARRAY
LONG VARCHAR FOR BIT DATA, BASICBIGINTEGER DECIMAL(18,0) PRIMARY KEY NOT NULL, BASICBIGDECIMAL
DECIMAL(18,0), BASICDATE DATE, BASICTIME TIME, BASICCALENDAR DATE, BASICTIMESTAMP TIMESTAMP
);
--- DROP TABLE A_BIGDECIMAL;
--- CREATE TABLE A_BIGDECIMAL ( ID VARCHAR(255), NAME VARCHAR(255) , VALUE INT, BASICINTEGER
INT, BASICSHORT SMALLINT, BASICBIGSHORT SMALLINT, BASICFLOAT FLOAT, BASICBIGFLOAT FLOAT, BASICLONG
BIGINT, BASICBIGLONG BIGINT, BASICDOUBLE DOUBLE, BASICBIGDOUBLE DOUBLE, BASICCHAR CHAR, BASICCHARARRAY
VARCHAR(448), BASICBIGCHARARRAY VARCHAR(448), BASICBYTEARRAY  LONG VARCHAR FOR BIT DATA, BASICBIGBYTEARRAY
LONG VARCHAR FOR BIT DATA, BASICBIGINTEGER DECIMAL(18,0), BASICBIGDECIMAL DECIMAL(18,0) PRIMARY
KEY NOT NULL, BASICDATE DATE, BASICTIME TIME, BASICCALENDAR DATE, BASICTIMESTAMP TIMESTAMP
);
+-- com/sun/ts/tests/ejb30/persistence/entitytest/bigdecimal
+DROP TABLE A_BIGDECIMAL ;
+CREATE TABLE A_BIGDECIMAL ( ID VARCHAR(255), NAME VARCHAR(255) , VALUE INT, BASICINTEGER
INT, BASICSHORT SMALLINT, BASICBIGSHORT SMALLINT, BASICFLOAT FLOAT, BASICBIGFLOAT FLOAT, BASICLONG
BIGINT, BASICBIGLONG BIGINT, BASICDOUBLE DOUBLE, BASICBIGDOUBLE DOUBLE, BASICCHAR INTEGER,
BASICCHARARRAY VARCHAR(448), BASICBIGCHARARRAY VARCHAR(448), BASICBYTEARRAY  LONG VARCHAR
FOR BIT DATA, BASICBIGBYTEARRAY LONG VARCHAR FOR BIT DATA, BASICBIGINTEGER DECIMAL(18,0),
BASICBIGDECIMAL DECIMAL(18,0) PRIMARY KEY NOT NULL, BASICDATE DATE, BASICTIME TIME, BASICCALENDAR
DATE, BASICTIMESTAMP TIMESTAMP ) ;

Modified: openjpa/trunk/openjpa-integration/tck/tck2-20110815.xml
URL: http://svn.apache.org/viewvc/openjpa/trunk/openjpa-integration/tck/tck2-20110815.xml?rev=1443753&r1=1443752&r2=1443753&view=diff
==============================================================================
--- openjpa/trunk/openjpa-integration/tck/tck2-20110815.xml (original)
+++ openjpa/trunk/openjpa-integration/tck/tck2-20110815.xml Thu Feb  7 22:10:43 2013
@@ -116,7 +116,7 @@ openjpa.FetchBatchSize: -1
 openjpa.Compatibility: StrictIdentityValues=true
 openjpa.Sequence: time
 openjpa.Log: ${openjpa.Log}
-openjpa.jdbc.DBDictionary: NumericTypeName=DECIMAL
+openjpa.jdbc.DBDictionary: NumericTypeName="DECIMAL(18,2)"
 # openjpa.jdbc.DBDictionary: StoreCharsAsNumbers=true
 # openjpa.jdbc.DBDictionary: (StoreCharsAsNumbers=true,NumericTypeName=DECIMAL)
 openjpa.jdbc.SchemaFactory: native(ForeignKeys=true)
@@ -155,10 +155,14 @@ toplink.properties=${toplink.properties}
 # actually work for a given environment.
 sigTestClasspath=${javart.property}${path.separator}${cp.property}
 persistence.unit.properties.file.full.path=${provider.properties}
+javax.persistence.jdbc.driver: ${db.driver}
+javax.persistence.jdbc.url: ${db.url}
+javax.persistence.jdbc.user: ${db.username}
+javax.persistence.jdbc.password: ${db.password}
+database.driver=${db.driver}
+database.url=${db.url}
 database.user=${db.username}
 database.passwd=${db.password}
-database.url=${db.url}
-database.driver=${db.driver}
 databaseName=${db.name}
 jdbc.lib.classpath=${cp.test.classpath}
 # disable initdb.xml table creation



Mime
View raw message