Author: aadamchik
Date: Fri Sep 1 13:56:58 2006
New Revision: 439477
URL: http://svn.apache.org/viewvc?rev=439477&view=rev
Log:
chugging along with itests
Added:
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/java/org/apache/cayenne/jpa/itest1/entity/PropertyDefaultsDatesEntity.java
Modified:
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/java/org/apache/cayenne/jpa/itest1/entity/PropertyDefaultsOtherEntity.java
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/java/org/apache/cayenne/jpa/itest1/entity/SerializableType.java
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/resources/META-INF/persistence.xml
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/java/org/apache/cayenne/jpa/itest/entity/_2_1_1_PeristentFieldsAndPropertiesTest.java
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/java/org/apache/cayenne/jpa/itest/entity/_2_1_4_PrimaryKeyAndIdentityTest.java
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/java/org/apache/cayenne/jpa/itest/entity/_2_1_6_MappingDefaultsNonRelationshipTest.java
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/resources/unit1-schema-hsqldb.sql
Added:
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/java/org/apache/cayenne/jpa/itest1/entity/PropertyDefaultsDatesEntity.java
URL:
http://svn.apache.org/viewvc/incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/java/org/apache/cayenne/jpa/itest1/entity/PropertyDefaultsDatesEntity.java?rev=439477&view=auto
==============================================================================
---
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/java/org/apache/cayenne/jpa/itest1/entity/PropertyDefaultsDatesEntity.java
(added)
+++
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/java/org/apache/cayenne/jpa/itest1/entity/PropertyDefaultsDatesEntity.java
Fri Sep 1 13:56:58 2006
@@ -0,0 +1,58 @@
+/*****************************************************************
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ ****************************************************************/
+package org.apache.cayenne.jpa.itest1.entity;
+
+import java.sql.Time;
+import java.sql.Timestamp;
+
+import javax.persistence.Entity;
+import javax.persistence.Id;
+
[EMAIL PROTECTED]
+public class PropertyDefaultsDatesEntity {
+
+ @Id
+ protected int id;
+
+ protected java.util.Date utilDate;
+ protected java.util.Calendar calendar;
+ protected java.sql.Date sqlDate;
+ protected Time sqlTime;
+ protected Timestamp sqlTimestamp;
+
+ public void setCalendar(java.util.Calendar calendar) {
+ this.calendar = calendar;
+ }
+
+ public void setSqlDate(java.sql.Date sqlDate) {
+ this.sqlDate = sqlDate;
+ }
+
+ public void setSqlTime(Time sqlTime) {
+ this.sqlTime = sqlTime;
+ }
+
+ public void setSqlTimestamp(Timestamp sqlTimestamp) {
+ this.sqlTimestamp = sqlTimestamp;
+ }
+
+ public void setUtilDate(java.util.Date utilDate) {
+ this.utilDate = utilDate;
+ }
+}
Modified:
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/java/org/apache/cayenne/jpa/itest1/entity/PropertyDefaultsOtherEntity.java
URL:
http://svn.apache.org/viewvc/incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/java/org/apache/cayenne/jpa/itest1/entity/PropertyDefaultsOtherEntity.java?rev=439477&r1=439476&r2=439477&view=diff
==============================================================================
---
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/java/org/apache/cayenne/jpa/itest1/entity/PropertyDefaultsOtherEntity.java
(original)
+++
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/java/org/apache/cayenne/jpa/itest1/entity/PropertyDefaultsOtherEntity.java
Fri Sep 1 13:56:58 2006
@@ -20,8 +20,6 @@
import java.math.BigDecimal;
import java.math.BigInteger;
-import java.sql.Time;
-import java.sql.Timestamp;
import javax.persistence.Entity;
import javax.persistence.Id;
@@ -35,11 +33,6 @@
protected String string;
protected BigInteger bigInt;
protected BigDecimal bigDecimal;
- protected java.util.Date utilDate;
- protected java.util.Calendar calendar;
- protected java.sql.Date sqlDate;
- protected Time sqlTime;
- protected Timestamp sqlTimestamp;
protected byte[] byteArray;
protected Byte[] byteWrapperArray;
@@ -65,10 +58,6 @@
this.byteWrapperArray = byteWrapperArray;
}
- public void setCalendar(java.util.Calendar calendar) {
- this.calendar = calendar;
- }
-
public void setCharArray(char[] charArray) {
this.charArray = charArray;
}
@@ -85,23 +74,7 @@
this.serializableType = serializableType;
}
- public void setSqlDate(java.sql.Date sqlDate) {
- this.sqlDate = sqlDate;
- }
-
- public void setSqlTime(Time sqlTime) {
- this.sqlTime = sqlTime;
- }
-
- public void setSqlTimestamp(Timestamp sqlTimestamp) {
- this.sqlTimestamp = sqlTimestamp;
- }
-
public void setString(String string) {
this.string = string;
- }
-
- public void setUtilDate(java.util.Date utilDate) {
- this.utilDate = utilDate;
}
}
Modified:
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/java/org/apache/cayenne/jpa/itest1/entity/SerializableType.java
URL:
http://svn.apache.org/viewvc/incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/java/org/apache/cayenne/jpa/itest1/entity/SerializableType.java?rev=439477&r1=439476&r2=439477&view=diff
==============================================================================
---
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/java/org/apache/cayenne/jpa/itest1/entity/SerializableType.java
(original)
+++
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/java/org/apache/cayenne/jpa/itest1/entity/SerializableType.java
Fri Sep 1 13:56:58 2006
@@ -23,6 +23,10 @@
public class SerializableType implements Serializable {
protected String key;
+
+ public SerializableType(String key) {
+ this.key = key;
+ }
public String getKey() {
return key;
Modified:
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/resources/META-INF/persistence.xml
URL:
http://svn.apache.org/viewvc/incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/resources/META-INF/persistence.xml?rev=439477&r1=439476&r2=439477&view=diff
==============================================================================
---
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/resources/META-INF/persistence.xml
(original)
+++
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/main/resources/META-INF/persistence.xml
Fri Sep 1 13:56:58 2006
@@ -35,6 +35,7 @@
<class>org.apache.cayenne.jpa.itest1.entity.EmbeddedEntity</class>
<class>org.apache.cayenne.jpa.itest1.entity.EmbeddedImpliedEntity</class>
<class>org.apache.cayenne.jpa.itest1.entity.PropertyDefaultsPrimitiveEntity</class>
+
<class>org.apache.cayenne.jpa.itest1.entity.PropertyDefaultsDatesEntity</class>
<class>org.apache.cayenne.jpa.itest1.entity.PropertyDefaultsOtherEntity</class>
<class>org.apache.cayenne.jpa.itest1.entity.PropertyDefaultsInvalidEntity</class>
</persistence-unit>
Modified:
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/java/org/apache/cayenne/jpa/itest/entity/_2_1_1_PeristentFieldsAndPropertiesTest.java
URL:
http://svn.apache.org/viewvc/incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/java/org/apache/cayenne/jpa/itest/entity/_2_1_1_PeristentFieldsAndPropertiesTest.java?rev=439477&r1=439476&r2=439477&view=diff
==============================================================================
---
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/java/org/apache/cayenne/jpa/itest/entity/_2_1_1_PeristentFieldsAndPropertiesTest.java
(original)
+++
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/java/org/apache/cayenne/jpa/itest/entity/_2_1_1_PeristentFieldsAndPropertiesTest.java
Fri Sep 1 13:56:58 2006
@@ -41,7 +41,7 @@
getEntityManager().persist(o1);
getEntityManager().getTransaction().commit();
- assertEquals(FieldPersistenceEntity.INITIAL_VALUE,
ItestDBUtils.getSingleValue(
+ assertEquals(FieldPersistenceEntity.INITIAL_VALUE,
ItestDBUtils.getObject(
"FieldPersistenceEntity",
"property1"));
}
Modified:
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/java/org/apache/cayenne/jpa/itest/entity/_2_1_4_PrimaryKeyAndIdentityTest.java
URL:
http://svn.apache.org/viewvc/incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/java/org/apache/cayenne/jpa/itest/entity/_2_1_4_PrimaryKeyAndIdentityTest.java?rev=439477&r1=439476&r2=439477&view=diff
==============================================================================
---
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/java/org/apache/cayenne/jpa/itest/entity/_2_1_4_PrimaryKeyAndIdentityTest.java
(original)
+++
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/java/org/apache/cayenne/jpa/itest/entity/_2_1_4_PrimaryKeyAndIdentityTest.java
Fri Sep 1 13:56:58 2006
@@ -63,7 +63,7 @@
getEntityManager().persist(o1);
getEntityManager().getTransaction().commit();
- assertEquals("p1", ItestDBUtils.getSingleValue("IdClassEntity",
"property1"));
+ assertEquals("p1", ItestDBUtils.getObject("IdClassEntity",
"property1"));
}
// TODO: andrus 8/10/2006 - fails
@@ -73,6 +73,6 @@
getEntityManager().persist(o1);
getEntityManager().getTransaction().commit();
- assertEquals("p1", ItestDBUtils.getSingleValue("EmbeddedIdEntity",
"property1"));
+ assertEquals("p1", ItestDBUtils.getObject("EmbeddedIdEntity",
"property1"));
}
}
Modified:
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/java/org/apache/cayenne/jpa/itest/entity/_2_1_6_MappingDefaultsNonRelationshipTest.java
URL:
http://svn.apache.org/viewvc/incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/java/org/apache/cayenne/jpa/itest/entity/_2_1_6_MappingDefaultsNonRelationshipTest.java?rev=439477&r1=439476&r2=439477&view=diff
==============================================================================
---
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/java/org/apache/cayenne/jpa/itest/entity/_2_1_6_MappingDefaultsNonRelationshipTest.java
(original)
+++
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/java/org/apache/cayenne/jpa/itest/entity/_2_1_6_MappingDefaultsNonRelationshipTest.java
Fri Sep 1 13:56:58 2006
@@ -18,11 +18,24 @@
****************************************************************/
package org.apache.cayenne.jpa.itest.entity;
+import java.io.ByteArrayInputStream;
+import java.io.ObjectInputStream;
+import java.math.BigDecimal;
+import java.math.BigInteger;
+import java.sql.Time;
+import java.sql.Timestamp;
+import java.util.Calendar;
+import java.util.GregorianCalendar;
+
import org.apache.cayenne.jpa.itest.EntityManagerCase;
import org.apache.cayenne.jpa.itest.ItestDBUtils;
import org.apache.cayenne.jpa.itest1.entity.Embeddable1;
import org.apache.cayenne.jpa.itest1.entity.EmbeddedImpliedEntity;
+import org.apache.cayenne.jpa.itest1.entity.EnumType;
+import org.apache.cayenne.jpa.itest1.entity.PropertyDefaultsDatesEntity;
+import org.apache.cayenne.jpa.itest1.entity.PropertyDefaultsOtherEntity;
import org.apache.cayenne.jpa.itest1.entity.PropertyDefaultsPrimitiveEntity;
+import org.apache.cayenne.jpa.itest1.entity.SerializableType;
public class _2_1_6_MappingDefaultsNonRelationshipTest extends
EntityManagerCase {
@@ -51,15 +64,195 @@
o1.setPrimitiveBoolean(true);
o1.setBooleanWrapper(Boolean.TRUE);
+ o1.setPrimitiveByte((byte) 3);
+ o1.setByteWrapper(new Byte("3"));
+
+ o1.setPrimitiveShort((short) 2);
+ o1.setShortWrapper(new Short("2"));
+
+ o1.setPrimitiveInt(4);
+ o1.setIntWrapper(new Integer("4"));
+
+ o1.setPrimitiveChar('a');
+ o1.setCharWrapper(new Character('a'));
+
+ o1.setPrimitiveLong(1234567890l);
+ o1.setLongWrapper(new Long(1234567890l));
+
+ o1.setPrimitiveFloat(5.5f);
+ o1.setFloatWrapper(new Float("5.5"));
+
+ o1.setPrimitiveDouble(6.5d);
+ o1.setDoubleWrapper(new Double("6.5"));
+
getEntityManager().persist(o1);
getEntityManager().getTransaction().commit();
- // TODO: andrus 8/10/2006 - fails
- assertTrue(ItestDBUtils.getSingleBoolean(
+ assertTrue(ItestDBUtils.getBoolean(
"PropertyDefaultsPrimitiveEntity",
"primitiveBoolean"));
- assertTrue(ItestDBUtils.getSingleBoolean(
+ assertTrue(ItestDBUtils.getBoolean(
"PropertyDefaultsPrimitiveEntity",
"booleanWrapper"));
+
+ assertEquals(2, ItestDBUtils.getInt(
+ "PropertyDefaultsPrimitiveEntity",
+ "primitiveShort"));
+ assertEquals(2, ItestDBUtils.getInt(
+ "PropertyDefaultsPrimitiveEntity",
+ "shortWrapper"));
+
+ assertEquals(3, ItestDBUtils.getInt(
+ "PropertyDefaultsPrimitiveEntity",
+ "primitiveByte"));
+ assertEquals(3, ItestDBUtils.getInt(
+ "PropertyDefaultsPrimitiveEntity",
+ "byteWrapper"));
+
+ assertEquals(4, ItestDBUtils.getInt(
+ "PropertyDefaultsPrimitiveEntity",
+ "primitiveInt"));
+ assertEquals(4, ItestDBUtils.getInt(
+ "PropertyDefaultsPrimitiveEntity",
+ "intWrapper"));
+
+ assertEquals("a", ItestDBUtils.getObject(
+ "PropertyDefaultsPrimitiveEntity",
+ "primitiveChar"));
+ assertEquals("a", ItestDBUtils.getObject(
+ "PropertyDefaultsPrimitiveEntity",
+ "charWrapper"));
+
+ assertEquals(1234567890l, ItestDBUtils.getLong(
+ "PropertyDefaultsPrimitiveEntity",
+ "primitiveLong"));
+ assertEquals(1234567890l, ItestDBUtils.getLong(
+ "PropertyDefaultsPrimitiveEntity",
+ "longWrapper"));
+
+ assertEquals(5.5d, ItestDBUtils.getDouble(
+ "PropertyDefaultsPrimitiveEntity",
+ "primitiveFloat"));
+ assertEquals(5.5d, ItestDBUtils.getDouble(
+ "PropertyDefaultsPrimitiveEntity",
+ "doubleFloat"));
+
+ assertEquals(6.5d, ItestDBUtils.getDouble(
+ "PropertyDefaultsPrimitiveEntity",
+ "primitiveDouble"));
+ assertEquals(6.5d, ItestDBUtils.getDouble(
+ "PropertyDefaultsPrimitiveEntity",
+ "doubleWrapper"));
+ }
+
+ public void testDatesDefaults() throws Exception {
+ ItestDBUtils.deleteAll("PropertyDefaultsDatesEntity");
+
+ java.util.Date utilDate = new
java.util.Date(System.currentTimeMillis() - 1000);
+ java.util.Calendar calendar = new java.util.GregorianCalendar();
+
+ java.sql.Date sqlDate = new java.sql.Date(new GregorianCalendar(2005,
4, 3)
+ .getTimeInMillis());
+
+ Calendar timeCal = new GregorianCalendar();
+ timeCal.clear();
+ timeCal.set(Calendar.HOUR_OF_DAY, 4);
+ timeCal.set(Calendar.MINUTE, 44);
+ timeCal.set(Calendar.SECOND, 32);
+ Time time = new Time(timeCal.getTimeInMillis());
+ Timestamp timestamp = new Timestamp(utilDate.getTime() - 50);
+
+ PropertyDefaultsDatesEntity o1 = new PropertyDefaultsDatesEntity();
+ o1.setUtilDate(utilDate);
+ o1.setCalendar(calendar);
+ o1.setSqlDate(sqlDate);
+ o1.setSqlTime(time);
+ o1.setSqlTimestamp(timestamp);
+
+ getEntityManager().persist(o1);
+ getEntityManager().getTransaction().commit();
+
+ assertEquals(utilDate, ItestDBUtils.getUtilDate(
+ "PropertyDefaultsDatesEntity",
+ "utilDate"));
+ assertEquals(calendar.getTimeInMillis(), ItestDBUtils.getTimestamp(
+ "PropertyDefaultsDatesEntity",
+ "calendar").getTime());
+ assertEquals(sqlDate, ItestDBUtils.getSqlDate(
+ "PropertyDefaultsDatesEntity",
+ "sqlDate"));
+ assertEquals(time, ItestDBUtils.getTime("PropertyDefaultsDatesEntity",
"sqlTime"));
+ assertEquals(timestamp, ItestDBUtils.getTimestamp(
+ "PropertyDefaultsDatesEntity",
+ "sqlTimestamp"));
+ }
+
+ // TODO: andrus 8/10/2006 - fails
+ public void _testOtherDefaults() throws Exception {
+ ItestDBUtils.deleteAll("PropertyDefaultsOtherEntity");
+
+ PropertyDefaultsOtherEntity o1 = new PropertyDefaultsOtherEntity();
+ o1.setString("abc");
+ o1.setBigInt(new BigInteger("2"));
+ o1.setBigDecimal(new BigDecimal("3.5"));
+ o1.setByteArray(new byte[] {
+ 1, 2
+ });
+ o1.setByteWrapperArray(new Byte[] {
+ new Byte("1"), new Byte("2")
+ });
+
+ o1.setCharArray(new char[] {
+ 'a', 'b'
+ });
+ o1.setCharWrapperArray(new Character[] {
+ new Character('a'), new Character('b')
+ });
+
+ o1.setEnumType(EnumType.b);
+ o1.setSerializableType(new SerializableType("c"));
+
+ getEntityManager().persist(o1);
+ getEntityManager().getTransaction().commit();
+
+ assertEquals("abc", ItestDBUtils.getObject(
+ "PropertyDefaultsOtherEntity",
+ "string"));
+ assertEquals(2, ItestDBUtils.getInt("PropertyDefaultsOtherEntity",
"bigInt"));
+ assertEquals(3.5d, ItestDBUtils.getDouble(
+ "PropertyDefaultsOtherEntity",
+ "bigDecimal"));
+
+ byte[] b1 = ItestDBUtils.getBytes("PropertyDefaultsOtherEntity",
"byteArray");
+ assertNotNull(b1);
+ assertEquals(2, b1.length);
+ assertEquals((byte) 1, b1[0]);
+ assertEquals((byte) 2, b1[1]);
+
+ byte[] b2 = ItestDBUtils.getBytes(
+ "PropertyDefaultsOtherEntity",
+ "byteWrapperArray");
+ assertNotNull(b2);
+ assertEquals(2, b2.length);
+ assertEquals((byte) 1, b2[0]);
+ assertEquals((byte) 2, b2[1]);
+
+ assertEquals("ab", ItestDBUtils.getObject(
+ "PropertyDefaultsOtherEntity",
+ "charArray"));
+
+ assertEquals("ab", ItestDBUtils.getObject(
+ "PropertyDefaultsOtherEntity",
+ "charWrapperArray"));
+ assertEquals(2, ItestDBUtils.getInt("PropertyDefaultsOtherEntity",
"enumType"));
+
+ byte[] ser = ItestDBUtils.getBytes(
+ "PropertyDefaultsOtherEntity",
+ "serializableType");
+ assertNotNull(ser);
+ SerializableType so = (SerializableType) new ObjectInputStream(
+ new ByteArrayInputStream(ser)).readObject();
+ assertNotNull(so);
+ assertEquals("c", so.getKey());
}
}
Modified:
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/resources/unit1-schema-hsqldb.sql
URL:
http://svn.apache.org/viewvc/incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/resources/unit1-schema-hsqldb.sql?rev=439477&r1=439476&r2=439477&view=diff
==============================================================================
---
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/resources/unit1-schema-hsqldb.sql
(original)
+++
incubator/cayenne/main/trunk/integration-test/jpa-unit1/src/test/resources/unit1-schema-hsqldb.sql
Fri Sep 1 13:56:58 2006
@@ -10,6 +10,8 @@
insert into AUTO_PK_SUPPORT (TABLE_NAME, NEXT_ID) VALUES ('EmbeddedEntity', 1);
insert into AUTO_PK_SUPPORT (TABLE_NAME, NEXT_ID) VALUES
('EmbeddedImpliedEntity', 1);
insert into AUTO_PK_SUPPORT (TABLE_NAME, NEXT_ID) VALUES
('PropertyDefaultsPrimitiveEntity', 1);
+insert into AUTO_PK_SUPPORT (TABLE_NAME, NEXT_ID) VALUES
('PropertyDefaultsDatesEntity', 1);
+insert into AUTO_PK_SUPPORT (TABLE_NAME, NEXT_ID) VALUES
('PropertyDefaultsOtherEntity', 1);
create table FieldPersistenceEntity (id int not null, property1 VARCHAR(100),
primary key(id));
create table PropertyPersistenceEntity (id int not null, property1
VARCHAR(100), property2 BOOLEAN, primary key(id));
@@ -25,4 +27,5 @@
create table EmbeddedEntity (id int not null, property1 VARCHAR(100), primary
key(id));
create table EmbeddedImpliedEntity (id int not null, property1 VARCHAR(100),
primary key(id));
create table PropertyDefaultsPrimitiveEntity (id INT not null,
primitiveBoolean BOOLEAN, primitiveByte TINYINT, primitiveShort SMALLINT,
primitiveChar CHAR(1), primitiveLong BIGINT, primitiveFloat FLOAT,
primitiveDouble DOUBLE, booleanWrapper BOOLEAN, byteWrapper TINYINT,
shortWrapper SMALLINT, charWrapper CHAR(1), longWrapper BIGINT, floatWrapper
FLOAT, doubleWrapper DOUBLE, primary key(id));
-create table PropertyDefaultsOtherEntity (id int not null, string
VARCHAR(100), bigInt BIGINT, bigDecimal NUMERIC, utilDate TIMESTAMP, calendar
TIMESTAMP, sqlDate DATE, sqlTime TIME, sqlTimestamp TIMESTAMP, byteArray
VARBINARY(100), byteWrapperArray VARBINARY(100), charArray VARCHAR(100),
charWrapperArray VARCHAR(100), enumType INT, serializableType VARBINARY(200),
primary key(id));
\ No newline at end of file
+create table PropertyDefaultsDatesEntity (id int not null, utilDate TIMESTAMP,
calendar TIMESTAMP, sqlDate DATE, sqlTime TIME, sqlTimestamp TIMESTAMP, primary
key(id));
+create table PropertyDefaultsOtherEntity (id int not null, string
VARCHAR(100), bigInt BIGINT, bigDecimal NUMERIC, byteArray VARBINARY(100),
byteWrapperArray VARBINARY(100), charArray VARCHAR(100), charWrapperArray
VARCHAR(100), enumType INT, serializableType VARBINARY(200), primary key(id));
\ No newline at end of file