Index: cpactf/src/test/java/org/castor/cpa/test/test881/Test881.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test881/Test881.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test881/Test881.java (revision 8436) @@ -38,6 +38,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenSequenceString.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenSequenceString.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenSequenceString.java (revision 8436) @@ -35,6 +35,7 @@ // DERBY and MYSQL do not support sequence key generator public boolean exclude(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL); } Index: cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenHighLow.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenHighLow.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenHighLow.java (revision 8436) @@ -29,6 +29,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.MYSQL) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.ORACLE); } Index: cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenTrigger.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenTrigger.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenTrigger.java (revision 8436) @@ -35,6 +35,7 @@ // DERBY and MYSQL do not support sequence key generator public boolean exclude(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL); } Index: cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenUuid.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenUuid.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenUuid.java (revision 8436) @@ -29,6 +29,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenSequence.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenSequence.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenSequence.java (revision 8436) @@ -35,6 +35,7 @@ // DERBY and MYSQL do not support sequence key generator public boolean exclude(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL); } Index: cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenReturning.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenReturning.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenReturning.java (revision 8436) @@ -35,6 +35,7 @@ // DERBY and MYSQL do not support sequence key generator public boolean exclude(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL); } Index: cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenMax.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenMax.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test20/TestKeyGenMax.java (revision 8436) @@ -29,6 +29,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test25/TestDependent.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test25/TestDependent.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test25/TestDependent.java (revision 8436) @@ -51,6 +51,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test26/TestDependentKeyGen.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test26/TestDependentKeyGen.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test26/TestDependentKeyGen.java (revision 8436) @@ -51,6 +51,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test27/TestDependentUpdate.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test27/TestDependentUpdate.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test27/TestDependentUpdate.java (revision 8436) @@ -48,6 +48,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test1206/TestDirtyIgnore.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test1206/TestDirtyIgnore.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test1206/TestDirtyIgnore.java (revision 8436) @@ -35,6 +35,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test28/TestDependentKeyGenUpdate.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test28/TestDependentKeyGenUpdate.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test28/TestDependentKeyGenUpdate.java (revision 8436) @@ -52,6 +52,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test2177/Test2177.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test2177/Test2177.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test2177/Test2177.java (revision 8436) @@ -28,6 +28,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test972/Test972.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test972/Test972.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test972/Test972.java (revision 8436) @@ -35,6 +35,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test30/TestOQLCondition.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test30/TestOQLCondition.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test30/TestOQLCondition.java (revision 8436) @@ -46,6 +46,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test30/TestOQLPassThrough.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test30/TestOQLPassThrough.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test30/TestOQLPassThrough.java (revision 8436) @@ -43,6 +43,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test30/TestOQLCountFunction.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test30/TestOQLCountFunction.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test30/TestOQLCountFunction.java (revision 8436) @@ -49,6 +49,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test31/TestPersistenceWithExtends.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test31/TestPersistenceWithExtends.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test31/TestPersistenceWithExtends.java (revision 8436) @@ -43,6 +43,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test32/TestLimitClause.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test32/TestLimitClause.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test32/TestLimitClause.java (revision 8436) @@ -43,7 +43,8 @@ // Test are only included/excluded for engines that have been tested with this test suite. public boolean include(final DatabaseEngineType engine) { - return (engine == DatabaseEngineType.MYSQL) + return (engine == DatabaseEngineType.HSQL) + || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); } Index: cpactf/src/test/java/org/castor/cpa/test/test32/TestLimitWithOffsetClause.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test32/TestLimitWithOffsetClause.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test32/TestLimitWithOffsetClause.java (revision 8436) @@ -45,7 +45,8 @@ // Test are only included/excluded for engines that have been tested with this test suite. public boolean include(final DatabaseEngineType engine) { - return (engine == DatabaseEngineType.MYSQL) + return (engine == DatabaseEngineType.HSQL) + || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); } Index: cpactf/src/test/java/org/castor/cpa/test/test70/TestCollections.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test70/TestCollections.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test70/TestCollections.java (revision 8436) @@ -41,6 +41,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE); } Index: cpactf/src/test/java/org/castor/cpa/test/test71/TestSpecialCollections.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test71/TestSpecialCollections.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test71/TestSpecialCollections.java (revision 8436) @@ -41,6 +41,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test35/TestSize.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test35/TestSize.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test35/TestSize.java (revision 8436) @@ -44,6 +44,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test72/TestSortedContainer.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test72/TestSortedContainer.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test72/TestSortedContainer.java (revision 8436) @@ -41,6 +41,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test73/TestManyToMany.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test73/TestManyToMany.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test73/TestManyToMany.java (revision 8436) @@ -69,6 +69,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test37/TestAbsolute.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test37/TestAbsolute.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test37/TestAbsolute.java (revision 8436) @@ -50,6 +50,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test74/TestManyToManyKeyGen.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test74/TestManyToManyKeyGen.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test74/TestManyToManyKeyGen.java (revision 8436) @@ -70,6 +70,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test38/TestCallSql.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test38/TestCallSql.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test38/TestCallSql.java (revision 8436) @@ -38,6 +38,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test1217/TestTimestampChange.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test1217/TestTimestampChange.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test1217/TestTimestampChange.java (revision 8436) @@ -36,6 +36,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test39/TestStoredProcedure.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test39/TestStoredProcedure.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test39/TestStoredProcedure.java (revision 8436) @@ -56,6 +56,7 @@ public boolean exclude(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL); } Index: cpactf/src/test/java/org/castor/cpa/test/test76/TestCachedOid.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test76/TestCachedOid.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test76/TestCachedOid.java (revision 8436) @@ -45,6 +45,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE); } Index: cpactf/src/test/java/org/castor/cpa/test/test77/TestQueryFinalize.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test77/TestQueryFinalize.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test77/TestQueryFinalize.java (revision 8436) @@ -43,6 +43,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test78/TestGetJdbcConnection.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test78/TestGetJdbcConnection.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test78/TestGetJdbcConnection.java (revision 8436) @@ -36,6 +36,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test78/TestTransactionManagedEnvironment.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test78/TestTransactionManagedEnvironment.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test78/TestTransactionManagedEnvironment.java (revision 8436) @@ -51,6 +51,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test78/TestIsPersistent.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test78/TestIsPersistent.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test78/TestIsPersistent.java (revision 8436) @@ -36,6 +36,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test78/TestIsLocked.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test78/TestIsLocked.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test78/TestIsLocked.java (revision 8436) @@ -35,6 +35,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test79/TestAutostore.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test79/TestAutostore.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test79/TestAutostore.java (revision 8436) @@ -36,6 +36,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test79/TestAutostoreMany.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test79/TestAutostoreMany.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test79/TestAutostoreMany.java (revision 8436) @@ -42,6 +42,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test1379/Test1379.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test1379/Test1379.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test1379/Test1379.java (revision 8436) @@ -17,7 +17,8 @@ // Test are only included/excluded for engines that have been tested with this test suite. public boolean include(final DatabaseEngineType engine) { - return (engine == DatabaseEngineType.DERBY) + return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.SAPDB) Index: cpactf/src/test/java/org/castor/cpa/test/test303/TestPersistentObject.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test303/TestPersistentObject.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test303/TestPersistentObject.java (revision 8436) @@ -53,6 +53,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test1499/TestNamedQueries.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test1499/TestNamedQueries.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test1499/TestNamedQueries.java (revision 8436) @@ -41,6 +41,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test2788/FindWithNewInstanceTest.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test2788/FindWithNewInstanceTest.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test2788/FindWithNewInstanceTest.java (revision 8436) @@ -52,6 +52,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test01/TestDuplicateKey.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test01/TestDuplicateKey.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test01/TestDuplicateKey.java (revision 8436) @@ -48,6 +48,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test03/TestReadOnly.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test03/TestReadOnly.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test03/TestReadOnly.java (revision 8436) @@ -46,6 +46,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test04/TestDeadlock.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test04/TestDeadlock.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test04/TestDeadlock.java (revision 8436) @@ -85,6 +85,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test05/TestUpdate.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test05/TestUpdate.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test05/TestUpdate.java (revision 8436) @@ -44,6 +44,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test07/TestCacheLeakage.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test07/TestCacheLeakage.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test07/TestCacheLeakage.java (revision 8436) @@ -100,6 +100,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test08/TestCache.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test08/TestCache.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test08/TestCache.java (revision 8436) @@ -43,6 +43,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test80/TestSelfReferentialExtend.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test80/TestSelfReferentialExtend.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test80/TestSelfReferentialExtend.java (revision 8436) @@ -40,6 +40,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test09/TestSynchronizable.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test09/TestSynchronizable.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test09/TestSynchronizable.java (revision 8436) @@ -52,6 +52,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test1503/TestNamedNativeQueries.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test1503/TestNamedNativeQueries.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test1503/TestNamedNativeQueries.java (revision 8436) @@ -37,6 +37,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test82/TestDependsNoKeyGen.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test82/TestDependsNoKeyGen.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test82/TestDependsNoKeyGen.java (revision 8436) @@ -35,6 +35,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test83/TestIdentityPerFieldMapping.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test83/TestIdentityPerFieldMapping.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test83/TestIdentityPerFieldMapping.java (revision 8436) @@ -37,6 +37,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test2550/TestCreate.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test2550/TestCreate.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test2550/TestCreate.java (revision 8436) @@ -43,6 +43,7 @@ public boolean exclude(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.POSTGRESQL) || (engine == DatabaseEngineType.SQL_SERVER); Index: cpactf/src/test/java/org/castor/cpa/test/test84/TestTransientAttribute.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test84/TestTransientAttribute.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test84/TestTransientAttribute.java (revision 8436) @@ -37,6 +37,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test85/TestEnum.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test85/TestEnum.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test85/TestEnum.java (revision 8436) @@ -34,6 +34,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test86/TestCircularRef.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test86/TestCircularRef.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test86/TestCircularRef.java (revision 8436) @@ -43,6 +43,7 @@ // Sequence key generator is not supported by DERBY and MYSQL public boolean exclude(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL); } Index: cpactf/src/test/java/org/castor/cpa/test/test87/TestExtended.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test87/TestExtended.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test87/TestExtended.java (revision 8436) @@ -52,6 +52,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test87/TestSimple.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test87/TestSimple.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test87/TestSimple.java (revision 8436) @@ -46,6 +46,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test87/TestRelation.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test87/TestRelation.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test87/TestRelation.java (revision 8436) @@ -44,6 +44,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test88/TestLazyLoading.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test88/TestLazyLoading.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test88/TestLazyLoading.java (revision 8436) @@ -52,6 +52,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test89/TestLazyEmployeeExpiration.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test89/TestLazyEmployeeExpiration.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test89/TestLazyEmployeeExpiration.java (revision 8436) @@ -61,6 +61,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test356/Test356.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test356/Test356.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test356/Test356.java (revision 8436) @@ -62,6 +62,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test11/TestTypeLOB.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test11/TestTypeLOB.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test11/TestTypeLOB.java (revision 8436) @@ -56,6 +56,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test954/Test954.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test954/Test954.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test954/Test954.java (revision 8436) @@ -58,6 +58,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test12/TestTypeConversion.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test12/TestTypeConversion.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test12/TestTypeConversion.java (revision 8436) @@ -57,6 +57,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test13/TestSerializable.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test13/TestSerializable.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test13/TestSerializable.java (revision 8436) @@ -43,6 +43,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test14/TestRollbackPrimitive.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test14/TestRollbackPrimitive.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test14/TestRollbackPrimitive.java (revision 8436) @@ -38,6 +38,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test15/TestMultiPrimKeysOnly.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test15/TestMultiPrimKeysOnly.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test15/TestMultiPrimKeysOnly.java (revision 8436) @@ -56,6 +56,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test15/TestMultiPrimKeys.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test15/TestMultiPrimKeys.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test15/TestMultiPrimKeys.java (revision 8436) @@ -61,6 +61,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) || (engine == DatabaseEngineType.MYSQL) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) || (engine == DatabaseEngineType.SAPDB); Index: cpactf/src/test/java/org/castor/cpa/test/test16/TestNestedFields.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test16/TestNestedFields.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test16/TestNestedFields.java (revision 8436) @@ -45,6 +45,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test17/TestTimeStamp.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test17/TestTimeStamp.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test17/TestTimeStamp.java (revision 8436) @@ -35,6 +35,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test18/TestPersistent.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test18/TestPersistent.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test18/TestPersistent.java (revision 8436) @@ -44,6 +44,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test90/TestLazy1to1.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test90/TestLazy1to1.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test90/TestLazy1to1.java (revision 8436) @@ -42,6 +42,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test19/TestInstanceFactory.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test19/TestInstanceFactory.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test19/TestInstanceFactory.java (revision 8436) @@ -43,6 +43,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test93/TestPolymorphismDegenerated.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test93/TestPolymorphismDegenerated.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test93/TestPolymorphismDegenerated.java (revision 8436) @@ -33,6 +33,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.POSTGRESQL); } Index: cpactf/src/test/java/org/castor/cpa/test/test94/TestPolymorphismWithUpdates.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test94/TestPolymorphismWithUpdates.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test94/TestPolymorphismWithUpdates.java (revision 8436) @@ -36,6 +36,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test95/TestPolymorphismWithKeyGen.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test95/TestPolymorphismWithKeyGen.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test95/TestPolymorphismWithKeyGen.java (revision 8436) @@ -36,6 +36,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test1158/Test1158.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test1158/Test1158.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test1158/Test1158.java (revision 8436) @@ -51,7 +51,8 @@ // Test are only included/excluded for engines that have been tested with this test suite. public boolean include(final DatabaseEngineType engine) { - return (engine == DatabaseEngineType.DERBY) + return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test96/TestPolymorphismDependendObjects.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test96/TestPolymorphismDependendObjects.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test96/TestPolymorphismDependendObjects.java (revision 8436) @@ -32,6 +32,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE); } Index: cpactf/src/test/java/org/castor/cpa/test/test2527/Test2527.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test2527/Test2527.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test2527/Test2527.java (revision 8436) @@ -33,6 +33,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test97/TestPolymorphism.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test97/TestPolymorphism.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test97/TestPolymorphism.java (revision 8436) @@ -42,6 +42,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test1196/TestLongTransaction.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test1196/TestLongTransaction.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test1196/TestLongTransaction.java (revision 8436) @@ -44,6 +44,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test98/TestPolymorphismInAThreadedEnv.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test98/TestPolymorphismInAThreadedEnv.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test98/TestPolymorphismInAThreadedEnv.java (revision 8436) @@ -42,6 +42,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test2763/VersionTest.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test2763/VersionTest.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test2763/VersionTest.java (revision 8436) @@ -52,6 +52,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test2763/TimeStampableTest.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test2763/TimeStampableTest.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test2763/TimeStampableTest.java (revision 8436) @@ -52,6 +52,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test200/TestSelfRelation.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test200/TestSelfRelation.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test200/TestSelfRelation.java (revision 8436) @@ -55,6 +55,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.POSTGRESQL); } Index: cpactf/src/test/java/org/castor/cpa/test/test99/TestPolymorphismMany2Many.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test99/TestPolymorphismMany2Many.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test99/TestPolymorphismMany2Many.java (revision 8436) @@ -34,6 +34,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test201/TestSelfRelationExtend.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test201/TestSelfRelationExtend.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test201/TestSelfRelationExtend.java (revision 8436) @@ -60,6 +60,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL); } Index: cpactf/src/test/java/org/castor/cpa/test/test2567/TestQuery.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test2567/TestQuery.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test2567/TestQuery.java (revision 8436) @@ -38,6 +38,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/java/org/castor/cpa/test/test202/TestForeignKeyFirst.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test202/TestForeignKeyFirst.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test202/TestForeignKeyFirst.java (revision 8436) @@ -31,6 +31,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL); Index: cpactf/src/test/java/org/castor/cpa/test/test241/TestObjectNotFound.java =================================================================== --- cpactf/src/test/java/org/castor/cpa/test/test241/TestObjectNotFound.java (revision 8435) +++ cpactf/src/test/java/org/castor/cpa/test/test241/TestObjectNotFound.java (revision 8436) @@ -33,6 +33,7 @@ public boolean include(final DatabaseEngineType engine) { return (engine == DatabaseEngineType.DERBY) + || (engine == DatabaseEngineType.HSQL) || (engine == DatabaseEngineType.MYSQL) || (engine == DatabaseEngineType.ORACLE) || (engine == DatabaseEngineType.POSTGRESQL) Index: cpactf/src/test/ddl/org/castor/cpa/test/test881/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test881/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test881/hsql-create.sql (revision 8436) @@ -0,0 +1,6 @@ +create table test881_prod ( + id int not null, + name varchar(200) not null +); + +insert into test881_prod values (1, 'This is the test object.'); Index: cpactf/src/test/ddl/org/castor/cpa/test/test881/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test881/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test881/hsql-drop.sql (revision 8436) @@ -0,0 +1 @@ +drop table test881_prod; Index: cpactf/src/test/ddl/org/castor/cpa/test/test1206/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test1206/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test1206/hsql-create.sql (revision 8436) @@ -0,0 +1,13 @@ +CREATE TABLE test1206_country ( + oid VARCHAR(8) NOT NULL, + name VARCHAR(60) NOT NULL, + PRIMARY KEY (oid) +); + +CREATE TABLE test1206_state ( + oid VARCHAR(8) NOT NULL, + name VARCHAR(60) NOT NULL, + country VARCHAR(8) NOT NULL, + PRIMARY KEY (oid), + FOREIGN KEY (country) REFERENCES test1206_country (oid) +); Index: cpactf/src/test/ddl/org/castor/cpa/test/test1206/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test1206/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test1206/hsql-drop.sql (revision 8436) @@ -0,0 +1,2 @@ +DROP TABLE test1206_state; +DROP TABLE test1206_country; Index: cpactf/src/test/ddl/org/castor/cpa/test/test2177/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test2177/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test2177/hsql-create.sql (revision 8436) @@ -0,0 +1,6 @@ +create table test2177_entity ( + id int not null, + name varchar(200) not null +); + +insert into test2177_entity (id, name) values (1, 'entity1'); Index: cpactf/src/test/ddl/org/castor/cpa/test/test2177/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test2177/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test2177/hsql-drop.sql (revision 8436) @@ -0,0 +1 @@ +drop table test2177_entity; Index: cpactf/src/test/ddl/org/castor/cpa/test/test972/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test972/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test972/hsql-create.sql (revision 8436) @@ -0,0 +1,18 @@ +create table test972_newprod ( + ID numeric(22) not null, + NAME varchar(200) not null, + PRICE numeric(18,2) not null, + GROUP_ID numeric(22) not null +); + +create table test972_prod ( + id int not null, + name varchar(200) not null, + price numeric(18,2) not null, + group_id int not null +); + +create table test972_prod_group ( + id int not null, + name varchar(200) not null +); Index: cpactf/src/test/ddl/org/castor/cpa/test/test972/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test972/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test972/hsql-drop.sql (revision 8436) @@ -0,0 +1,3 @@ +drop table test972_newprod; +drop table test972_prod; +drop table test972_prod_group; Index: cpactf/src/test/ddl/org/castor/cpa/test/test71/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test71/hsql-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test71/hsql-create.sql (revision 8436) @@ -4,11 +4,10 @@ PRIMARY KEY (id) ); -INSERT INTO test71_container (id, name) VALUES - (1,'Container 1'), - (2,'Container 2'), - (3,'Container 3'), - (4,'Container 4'); +INSERT INTO test71_container (id, name) VALUES (1,'Container 1'); + INSERT INTO test71_container (id, name) VALUES (2,'Container 2'); + INSERT INTO test71_container (id, name) VALUES (3,'Container 3'); + INSERT INTO test71_container (id, name) VALUES (4,'Container 4'); CREATE TABLE test71_container_item ( id int NOT NULL, @@ -17,13 +16,12 @@ PRIMARY KEY (id) ); -INSERT INTO test71_container_item (id, item, ivalue) VALUES - (1,1,'Container item 1'), - (2,2,'Container item 2'), - (3,3,'Container item 3'), - (4,4,'Container item 4'), - (5,1,'Container item 5'), - (6,2,'Container item 6'), - (7,3,'Container item 7'), - (8,4,'Container item 8'); +INSERT INTO test71_container_item (id, item, ivalue) VALUES (1,1,'Container item 1'); +INSERT INTO test71_container_item (id, item, ivalue) VALUES (2,2,'Container item 2'); +INSERT INTO test71_container_item (id, item, ivalue) VALUES (3,3,'Container item 3'); +INSERT INTO test71_container_item (id, item, ivalue) VALUES (4,4,'Container item 4'); +INSERT INTO test71_container_item (id, item, ivalue) VALUES (5,1,'Container item 5'); +INSERT INTO test71_container_item (id, item, ivalue) VALUES (6,2,'Container item 6'); +INSERT INTO test71_container_item (id, item, ivalue) VALUES (7,3,'Container item 7'); +INSERT INTO test71_container_item (id, item, ivalue) VALUES (8,4,'Container item 8'); Index: cpactf/src/test/ddl/org/castor/cpa/test/test1217/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test1217/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test1217/hsql-create.sql (revision 8436) @@ -0,0 +1,29 @@ +CREATE TABLE test1217_person ( + oid VARCHAR(8) NOT NULL, + name VARCHAR(60) NOT NULL, + PRIMARY KEY (oid) +); + +CREATE TABLE test1217_base ( + oid VARCHAR(8) NOT NULL, + name VARCHAR(60) NOT NULL, + PRIMARY KEY (oid) +); + +CREATE TABLE test1217_extended ( + oid VARCHAR(8) NOT NULL, + exnum VARCHAR(20) NOT NULL, + PRIMARY KEY (oid), + FOREIGN KEY (oid) REFERENCES test1217_base (oid) +); + +CREATE TABLE test1217_product ( + oid VARCHAR(8) NOT NULL, + code VARCHAR(12) NOT NULL, + price NUMERIC(12,2) NOT NULL, + company VARCHAR(8) NOT NULL, + part VARCHAR(8) NOT NULL, + PRIMARY KEY (oid), + FOREIGN KEY (company) REFERENCES test1217_person (oid), + FOREIGN KEY (part) REFERENCES test1217_base (oid) +); Index: cpactf/src/test/ddl/org/castor/cpa/test/test1217/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test1217/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test1217/hsql-drop.sql (revision 8436) @@ -0,0 +1,4 @@ +DROP TABLE test1217_product; +DROP TABLE test1217_person; +DROP TABLE test1217_extended; +DROP TABLE test1217_base; Index: cpactf/src/test/ddl/org/castor/cpa/test/test1379/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test1379/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test1379/hsql-create.sql (revision 8436) @@ -0,0 +1,10 @@ +create table test1379_prod ( + id int not null, + name varchar(200) not null, + price numeric(18,2) not null +); + +create table test1379_computer ( + id int not null, + cpu varchar(200) not null +); Index: cpactf/src/test/ddl/org/castor/cpa/test/test1379/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test1379/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test1379/hsql-drop.sql (revision 8436) @@ -0,0 +1,2 @@ +drop table test1379_prod; +drop table test1379_computer; Index: cpactf/src/test/ddl/org/castor/cpa/test/test303/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test303/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test303/hsql-create.sql (revision 8436) @@ -0,0 +1,12 @@ +create table test303_entity2( + id integer, + name varchar(255) not null, + primary key (id), + UNIQUE (name) +); + +create table test303_entity1( + id integer, + related integer, + primary key (id) +); \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test303/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test303/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test303/hsql-drop.sql (revision 8436) @@ -0,0 +1,2 @@ +drop table test303_entity1; +drop table test303_entity2; Index: cpactf/src/test/ddl/org/castor/cpa/test/test2788/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test2788/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test2788/hsql-create.sql (revision 8436) @@ -0,0 +1,3 @@ +CREATE TABLE test2788_book ( + id INTEGER PRIMARY KEY +); \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test2788/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test2788/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test2788/hsql-drop.sql (revision 8436) @@ -0,0 +1 @@ +DROP TABLE test2788_book; Index: cpactf/src/test/ddl/org/castor/cpa/test/test81/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test81/hsql-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test81/hsql-create.sql (revision 8436) @@ -1,13 +1,12 @@ -CREATE TABLE test81_test_depends_ns ( - id int(11) NOT NULL, - master_id int(11) NOT NULL default '0', - descrip varchar(50) NOT NULL default '', - PRIMARY KEY (id), - KEY master_id (master_id) +CREATE TABLE test81_test_depends_ns ( + id int IDENTITY, + master_id int, + descrip varchar(50) default '', + primary key (id) ); -CREATE TABLE test81_test_master_ns ( - id int(11) NOT NULL, - descrip varchar(50) NOT NULL default '', - PRIMARY KEY (id) +CREATE TABLE test81_test_master_ns ( + id int IDENTITY, + descrip varchar(50) default '', + primary key (id) ); \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test82/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test82/hsql-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test82/hsql-create.sql (revision 8436) @@ -1,13 +1,12 @@ CREATE TABLE test82_test_depends_ns_nokg ( - id int(11) NOT NULL, - master_id int(11) NOT NULL default '0', - descrip varchar(50) NOT NULL default '', - PRIMARY KEY (id), - KEY master_id (master_id) + id int IDENTITY, + master_id int DEFAULT 0, + descrip varchar(50) default '', + PRIMARY KEY (id) ); CREATE TABLE test82_test_master_ns_nokg ( - id int(11) NOT NULL, - descrip varchar(50) NOT NULL default '', + id int IDENTITY, + descrip varchar(50) default '', PRIMARY KEY (id) ); \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test87/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test87/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test87/hsql-create.sql (revision 8436) @@ -0,0 +1,43 @@ +create table test87_entity ( + id int not null, + name varchar(200) not null, + time_stamp bigint not null +); + +create unique index test87_entity_pk on test87_entity ( id ); + + + +create table test87_product ( + id int not null, + name varchar(200) not null, + group_id int not null, + time_stamp bigint not null +); + +create unique index test87_product_pk on test87_product ( id ); + +create table test87_group ( + id int not null, + name varchar(200) not null, + time_stamp bigint not null +); + +create unique index test87_group_pk on test87_group ( id ); + + + +create table test87_base ( + id int not null, + name varchar(200) not null, + time_stamp bigint not null +); + +create unique index test87_base_pk on test87_base ( id ); + +create table test87_extended ( + id int not null, + note varchar(200) not null +); + +create unique index test87_extended_pk on test87_extended ( id ); Index: cpactf/src/test/ddl/org/castor/cpa/test/test87/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test87/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test87/hsql-drop.sql (revision 8436) @@ -0,0 +1,7 @@ +drop table test87_entity; + +drop table test87_product; +drop table test87_group; + +drop table test87_extended; +drop table test87_base; Index: cpactf/src/test/ddl/org/castor/cpa/test/test356/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test356/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test356/hsql-create.sql (revision 8436) @@ -0,0 +1,11 @@ +create table test356_entity ( + id int not null, + prop int, + primary key (id) +); + +insert into test356_entity (id, prop) values (1, 100); +insert into test356_entity (id, prop) values (2, 200); +insert into test356_entity (id, prop) values (3, 300); +insert into test356_entity (id, prop) values (4, 400); +insert into test356_entity (id, prop) values (5, null); Index: cpactf/src/test/ddl/org/castor/cpa/test/test356/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test356/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test356/hsql-drop.sql (revision 8436) @@ -0,0 +1 @@ +drop table test356_entity; Index: cpactf/src/test/ddl/org/castor/cpa/test/test954/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test954/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test954/hsql-create.sql (revision 8436) @@ -0,0 +1,6 @@ +create table test954_prod ( + id int not null, + name varchar(200) not null +); + +insert into test954_prod values (1, 'This is the test object.'); Index: cpactf/src/test/ddl/org/castor/cpa/test/test954/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test954/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test954/hsql-drop.sql (revision 8436) @@ -0,0 +1 @@ +drop table test954_prod; Index: cpactf/src/test/ddl/org/castor/cpa/test/test93/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test93/hsql-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test93/hsql-create.sql (revision 8436) @@ -22,10 +22,10 @@ create table test93_subscription ( id int not null, - createddate timestamp, + created_date timestamp, description varchar(200), customer_id int not null ); -insert into test93_subscription (id, createddate, customer_id) values (1, CURRENT_TIMESTAMP, 2); -insert into test93_subscription (id, createddate, customer_id) values (2, CURRENT_TIMESTAMP, 2); \ No newline at end of file +insert into test93_subscription (id, created_date, customer_id) values (1, CURRENT_TIMESTAMP, 2); +insert into test93_subscription (id, created_date, customer_id) values (2, CURRENT_TIMESTAMP, 2); \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test1355/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test1355/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test1355/hsql-create.sql (revision 8436) @@ -0,0 +1,142 @@ +CREATE TABLE test1355_country ( + id BIGINT NOT NULL, + name VARCHAR(100) NOT NULL, + iso3_country_code VARCHAR(3) , + record_created_by_id BIGINT , + record_last_mod_by_id BIGINT , + record_create_date TIMESTAMP , + record_last_mod_date TIMESTAMP +); + +CREATE TABLE test1355_state_prov ( + id BIGINT NOT NULL, + code VARCHAR(3) , + name VARCHAR(100) NOT NULL, + country_id BIGINT NOT NULL, + record_created_by_id BIGINT , + record_last_mod_by_id BIGINT , + record_create_date TIMESTAMP , + record_last_mod_date TIMESTAMP +); + +CREATE TABLE test1355_city ( + id BIGINT NOT NULL, + name VARCHAR(100) NOT NULL, + state_prov_id BIGINT NOT NULL, + record_created_by_id BIGINT , + record_last_mod_by_id BIGINT , + record_create_date TIMESTAMP , + record_last_mod_date TIMESTAMP +); + +CREATE TABLE test1355_golf_course ( + id BIGINT NOT NULL, + course_name VARCHAR(100) NOT NULL, + holes INTEGER NOT NULL, + city_id BIGINT , + record_created_by_id BIGINT , + record_last_mod_by_id BIGINT , + record_create_date TIMESTAMP , + record_last_mod_date TIMESTAMP +); + +CREATE TABLE test1355_golf_course_tees ( + id BIGINT NOT NULL, + course_id BIGINT NOT NULL, + tees_name VARCHAR(100) NOT NULL, + tees_color VARCHAR(25) , + mens_slope INTEGER , + mens_rating DOUBLE , + womens_slope INTEGER , + womens_rating DOUBLE , + yardage INTEGER , + record_created_by_id BIGINT , + record_last_mod_by_id BIGINT , + record_create_date TIMESTAMP , + record_last_mod_date TIMESTAMP +); + +CREATE TABLE test1355_golf_course_holes ( + id BIGINT NOT NULL, + course_tees_id BIGINT NOT NULL, + num INTEGER NOT NULL, + hole_name VARCHAR(100) , + par INTEGER , + yardage INTEGER , + record_created_by_id BIGINT , + record_last_mod_by_id BIGINT , + record_create_date TIMESTAMP , + record_last_mod_date TIMESTAMP +); + +insert into test1355_country (id, name, iso3_country_code) values (1, 'USA', 'USA'); +insert into test1355_state_prov (id, code, name, country_id) values (1, 'WA', 'Washington', 1); +insert into test1355_city (id, name, state_prov_id) values (1, 'Seattle', 1); + +insert into test1355_golf_course (id, course_name, holes, city_id) values (1, 'West Seattle', 18, 1); +insert into test1355_golf_course_tees (id, course_id, tees_name, tees_color) values (1, 1, 'White', 'white'); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (1, 1, 1, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (2, 1, 2, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (3, 1, 3, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (4, 1, 4, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (5, 1, 5, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (6, 1, 6, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (7, 1, 7, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (8, 1, 8, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (9, 1, 9, 4); + +insert into test1355_golf_course_tees (id, course_id, tees_name, tees_color) values (2, 1, 'Blue', 'blue'); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (10, 2, 1, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (11, 2, 2, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (12, 2, 3, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (13, 2, 4, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (14, 2, 5, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (15, 2, 6, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (16, 2, 7, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (17, 2, 8, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (18, 2, 9, 4); + +insert into test1355_golf_course_tees (id, course_id, tees_name, tees_color) values (3, 1, 'Red', 'red'); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (19, 3, 1, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (20, 3, 2, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (21, 3, 3, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (22, 3, 4, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (23, 3, 5, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (24, 3, 6, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (25, 3, 7, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (26, 3, 8, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (27, 3, 9, 4); + +insert into test1355_golf_course (id, course_name, holes, city_id) values (2, 'Jackson Park', 18, 1); +insert into test1355_golf_course_tees (id, course_id, tees_name, tees_color) values (4, 2, 'White', 'white'); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (28, 4, 1, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (29, 4, 2, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (30, 4, 3, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (31, 4, 4, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (32, 4, 5, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (33, 4, 6, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (34, 4, 7, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (35, 4, 8, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (36, 4, 9, 4); + +insert into test1355_golf_course_tees (id, course_id, tees_name, tees_color) values (5, 2, 'Blue', 'blue'); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (37, 5, 1, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (38, 5, 2, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (39, 5, 3, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (40, 5, 4, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (41, 5, 5, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (42, 5, 6, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (43, 5, 7, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (44, 5, 8, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (45, 5, 9, 4); + +insert into test1355_golf_course_tees (id, course_id, tees_name, tees_color) values (6, 2, 'Red', 'red'); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (46, 6, 1, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (47, 6, 2, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (48, 6, 3, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (49, 6, 4, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (50, 6, 5, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (51, 6, 6, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (52, 6, 7, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (53, 6, 8, 4); +insert into test1355_golf_course_holes (id, course_tees_id, num, par) values (54, 6, 9, 4); Index: cpactf/src/test/ddl/org/castor/cpa/test/test1355/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test1355/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test1355/hsql-drop.sql (revision 8436) @@ -0,0 +1,6 @@ +DROP TABLE test1355_country; +DROP TABLE test1355_state_prov; +DROP TABLE test1355_city; +DROP TABLE test1355_golf_course; +DROP TABLE test1355_golf_course_tees; +DROP TABLE test1355_golf_course_holes; Index: cpactf/src/test/ddl/org/castor/cpa/test/test1158/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test1158/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test1158/hsql-create.sql (revision 8436) @@ -0,0 +1,16 @@ +CREATE TABLE test1158_extended ( + id int NOT NULL, + description2 varchar(50) NOT NULL, + PRIMARY KEY (id) +); + +INSERT INTO test1158_extended VALUES (1, 'This is the extended object.'); + +CREATE TABLE test1158_object ( + id int NOT NULL, + description varchar(50) NOT NULL, + saved char(1), + PRIMARY KEY (id) +); + +INSERT INTO test1158_object VALUES (1, 'This is the test object.', ''); Index: cpactf/src/test/ddl/org/castor/cpa/test/test1158/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test1158/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test1158/hsql-drop.sql (revision 8436) @@ -0,0 +1,2 @@ +DROP TABLE test1158_extended; +DROP TABLE test1158_object; Index: cpactf/src/test/ddl/org/castor/cpa/test/test96/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test96/hsql-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test96/hsql-create.sql (revision 8436) @@ -1,14 +1,14 @@ CREATE TABLE test96_poly_extend_object ( - id int NOT NULL default 0, - description2 varchar(50) NOT NULL default '', + id int default 0, + description2 varchar(50) NOT NULL, PRIMARY KEY (id) ); INSERT INTO test96_poly_extend_object VALUES (1, 'This is the extended object.'); CREATE TABLE test96_poly_base_object ( - id int NOT NULL default 0, - description varchar(50) NOT NULL default '', + id int default 0, + description varchar(50) NOT NULL, saved char(1) default '0', PRIMARY KEY (id) ); @@ -16,9 +16,9 @@ INSERT INTO test96_poly_base_object VALUES (1, 'This is the test object.', '0'); CREATE TABLE test96_poly_depend_object ( - id int NOT NULL default 0, - parentId int NOT NULL default 0, - description varchar(50) NOT NULL default '', + id int default 0, + parentId int default 0, + description varchar(50) NOT NULL , PRIMARY KEY (id) ); Index: cpactf/src/test/ddl/org/castor/cpa/test/test2527/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test2527/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test2527/hsql-create.sql (revision 8436) @@ -0,0 +1,60 @@ +CREATE TABLE test2527_log ( + id INT NOT NULL, + time_stamp TIMESTAMP NOT NULL, + source VARCHAR(100) NOT NULL, + llevel VARCHAR(10) NOT NULL, + message VARCHAR(500) DEFAULT NULL, + PRIMARY KEY (id) +); + +CREATE TABLE test2527_log_exception ( + id INT NOT NULL, + entry_id INT NOT NULL, + stacktrace LONGVARCHAR NOT NULL, + PRIMARY KEY (id) +); + +ALTER TABLE test2527_log_exception +ADD CONSTRAINT test2527_log_exception_fk +FOREIGN KEY (entry_id) REFERENCES test2527_log (id); + +CREATE TABLE test2527_log_reference ( + id INT NOT NULL, + rtype VARCHAR(100) NOT NULL, + rvalue VARCHAR(100) NOT NULL, + PRIMARY KEY (id) +); + +ALTER TABLE test2527_log_reference +ADD CONSTRAINT test2527_log_reference_fk +FOREIGN KEY (id) REFERENCES test2527_log (id); + + +INSERT INTO test2527_log VALUES (1, '2008-12-31 12:34:56', 'test1', 'level', 'simple log entry 1'); +INSERT INTO test2527_log VALUES (2, '2008-12-31 12:34:56', 'test1', 'level', 'simple log entry 2'); + +INSERT INTO test2527_log VALUES (3, '2008-12-31 12:34:56', 'test2', 'level', 'exception log entry 1'); +INSERT INTO test2527_log_exception VALUES (1, 3, 'stacktrace for exception log entry 1'); +INSERT INTO test2527_log VALUES (4, '2008-12-31 12:34:56', 'test2', 'level', 'exception log entry 2'); +INSERT INTO test2527_log_exception VALUES (2, 4, 'stacktrace for exception log entry 2'); + +INSERT INTO test2527_log VALUES (5, '2008-12-31 12:34:56', 'test3', 'level', 'refering log entry 1'); +INSERT INTO test2527_log_reference VALUES (5, 'type', 'ref 1'); +INSERT INTO test2527_log VALUES (6, '2008-12-31 12:34:56', 'test3', 'level', 'refering log entry 2'); +INSERT INTO test2527_log_reference VALUES (6, 'type', 'ref 2'); + +INSERT INTO test2527_log VALUES (7, '2008-12-31 12:34:56', 'test4', 'level', 'simple and exception log entry 1'); +INSERT INTO test2527_log VALUES (8, '2008-12-31 12:34:56', 'test4', 'level', 'simple and exception log entry 2'); +INSERT INTO test2527_log_exception VALUES (3, 8, 'stacktrace for simple and exception log entry 2'); +INSERT INTO test2527_log VALUES (9, '2008-12-31 12:34:56', 'test4', 'level', 'simple and exception log entry 3'); + +INSERT INTO test2527_log VALUES (10, '2008-12-31 12:34:56', 'test5', 'level', 'simple and refering log entry 1'); +INSERT INTO test2527_log VALUES (11, '2008-12-31 12:34:56', 'test5', 'level', 'simple and refering log entry 2'); +INSERT INTO test2527_log_reference VALUES (11, 'type', 's+r 2'); +INSERT INTO test2527_log VALUES (12, '2008-12-31 12:34:56', 'test5', 'level', 'simple and refering log entry 3'); + +INSERT INTO test2527_log VALUES (13, '2008-12-31 12:34:56', 'test6', 'level', 'exception, refering and simple log entry 1'); +INSERT INTO test2527_log_exception VALUES (4, 13, 'stacktrace for exception, refering and simple log entry 1'); +INSERT INTO test2527_log VALUES (14, '2008-12-31 12:34:56', 'test6', 'level', 'exception, refering and simple log entry 2'); +INSERT INTO test2527_log_reference VALUES (14, 'type', 'e+r+s 2'); +INSERT INTO test2527_log VALUES (15, '2008-12-31 12:34:56', 'test6', 'level', 'exception, refering and simple log entry 3'); Index: cpactf/src/test/ddl/org/castor/cpa/test/test2527/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test2527/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test2527/hsql-drop.sql (revision 8436) @@ -0,0 +1,3 @@ +DROP TABLE test2527_log_reference; +DROP TABLE test2527_log_exception; +DROP TABLE test2527_log; Index: cpactf/src/test/ddl/org/castor/cpa/test/test97/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test97/hsql-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test97/hsql-create.sql (revision 8436) @@ -36,7 +36,7 @@ create table test97_poly_server ( id int not null, - numberOfCPUs int not null, + number_of_cpus int not null, support int not null ); @@ -74,7 +74,7 @@ create table test97_poly_server_multi ( id1 int not null, id2 int not null, - numberOfCPUs int not null, + number_of_cpus int not null, support int not null ); @@ -115,11 +115,11 @@ insert into test97_poly_prod (id, name, detail, owner) values (3, 'server 3', 3, 3); insert into test97_poly_computer (id, cpu) values (3, 'pentium 4'); -insert into test97_poly_server (id, numberOfCPUs, support) values (3, 4, 3); +insert into test97_poly_server (id, number_of_cpus, support) values (3, 4, 3); insert into test97_poly_prod (id, name, detail, owner) values (4, 'server 4', 4, 4); insert into test97_poly_computer (id, cpu) values (4, 'pentium 4'); -insert into test97_poly_server (id, numberOfCPUs, support) values (4, 16,5); +insert into test97_poly_server (id, number_of_cpus, support) values (4, 16,5); insert into test97_poly_prod (id, name, detail, owner) values (5, 'truck 5', 5, 5); insert into test97_poly_car (id, kw, make) values (5, 60, 'make 5'); @@ -135,11 +135,11 @@ insert into test97_poly_prod_multi (id1, id2, name) values (3, 3, 'server 3'); insert into test97_poly_computer_multi (id1, id2, cpu) values (3, 3, 'pentium 4'); -insert into test97_poly_server_multi (id1, id2, numberOfCPUs, support) values (3, 3, 4, 3); +insert into test97_poly_server_multi (id1, id2, number_of_cpus, support) values (3, 3, 4, 3); insert into test97_poly_prod_multi (id1, id2, name) values (4, 4, 'server 4'); insert into test97_poly_computer_multi (id1, id2, cpu) values (4, 4, 'pentium 4'); -insert into test97_poly_server_multi (id1, id2, numberOfCPUs, support) values (4, 4, 16,5); +insert into test97_poly_server_multi (id1, id2, number_of_cpus, support) values (4, 4, 16,5); insert into test97_poly_owner (id, name, product) values (1, 'owner 1', 1); insert into test97_poly_owner (id, name, product) values (2, 'owner 2', 2); Index: cpactf/src/test/ddl/org/castor/cpa/test/test1196/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test1196/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test1196/hsql-create.sql (revision 8436) @@ -0,0 +1,83 @@ +CREATE TABLE test1196_country ( + oid VARCHAR(8) NOT NULL, + name VARCHAR(60) NOT NULL, + PRIMARY KEY (oid) +); + +CREATE TABLE test1196_state ( + oid VARCHAR(8) NOT NULL, + name VARCHAR(60) NOT NULL, + country VARCHAR(8) NOT NULL, + PRIMARY KEY (oid) +); + +ALTER TABLE test1196_state +ADD FOREIGN KEY (country) +REFERENCES test1196_country (oid); + + +CREATE TABLE test1196_car ( + oid VARCHAR(8) NOT NULL, + name VARCHAR(60) NOT NULL, + driver VARCHAR(8), + PRIMARY KEY (oid) +); + +CREATE TABLE test1196_driver ( + oid VARCHAR(8) NOT NULL, + name VARCHAR(60) NOT NULL, + car VARCHAR(8), + PRIMARY KEY (oid) +); + +ALTER TABLE test1196_car +ADD CONSTRAINT test1196_driver_fk FOREIGN KEY (driver) +REFERENCES test1196_driver (oid); + +ALTER TABLE test1196_driver +ADD CONSTRAINT test1196_car_fk FOREIGN KEY (car) +REFERENCES test1196_car (oid); + + +CREATE TABLE test1196_order ( + oid VARCHAR(8) NOT NULL, + onum INTEGER NOT NULL, + PRIMARY KEY (oid) +); + +CREATE TABLE test1196_product ( + oid VARCHAR(8) NOT NULL, + name VARCHAR(60) NOT NULL, + PRIMARY KEY (oid) +); + +CREATE TABLE test1196_orderitem ( + oid VARCHAR(8) NOT NULL, + quantity INTEGER NOT NULL, + product VARCHAR(8), + parent VARCHAR(8) NOT NULL, + PRIMARY KEY (oid) +); + +ALTER TABLE test1196_orderitem +ADD FOREIGN KEY (product) +REFERENCES test1196_product (oid); + +ALTER TABLE test1196_orderitem +ADD FOREIGN KEY (parent) +REFERENCES test1196_order (oid); + +CREATE TABLE test1196_computer ( + oid VARCHAR(8) NOT NULL, + snum VARCHAR(20) NOT NULL, + orderitem VARCHAR(8), + PRIMARY KEY (oid) +); + +ALTER TABLE test1196_computer +ADD FOREIGN KEY (oid) +REFERENCES test1196_product (oid); + +ALTER TABLE test1196_computer +ADD FOREIGN KEY (orderitem) +REFERENCES test1196_orderitem (oid); Index: cpactf/src/test/ddl/org/castor/cpa/test/test1196/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test1196/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test1196/hsql-drop.sql (revision 8436) @@ -0,0 +1,13 @@ +DROP TABLE test1196_state; +DROP TABLE test1196_country; + +ALTER TABLE test1196_car DROP FOREIGN KEY test1196_driver_fk; +ALTER TABLE test1196_driver DROP FOREIGN KEY test1196_car_fk; + +DROP TABLE test1196_car; +DROP TABLE test1196_driver; + +DROP TABLE test1196_computer; +DROP TABLE test1196_orderitem; +DROP TABLE test1196_product; +DROP TABLE test1196_order; Index: cpactf/src/test/ddl/org/castor/cpa/test/test98/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test98/hsql-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test98/hsql-create.sql (revision 8436) @@ -1,5 +1,5 @@ CREATE TABLE test98_poly_base ( - id varchar(64) NOT NULL default '', + id varchar(64) NOT NULL, color varchar(64), PRIMARY KEY (ID) ) ; @@ -7,7 +7,7 @@ INSERT INTO test98_poly_base VALUES ('100','red'); CREATE TABLE test98_poly_derived ( - id varchar(64) NOT NULL default '', + id varchar(64) NOT NULL, scent varchar(64), PRIMARY KEY (ID) ) ; @@ -15,7 +15,7 @@ INSERT INTO test98_poly_derived VALUES ('100','vanilla'); CREATE TABLE test98_poly_container ( - id varchar(64) NOT NULL default '', + id varchar(64) NOT NULL, reference varchar(64), PRIMARY KEY (ID) ) ; Index: cpactf/src/test/ddl/org/castor/cpa/test/test2763/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test2763/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test2763/hsql-create.sql (revision 8436) @@ -0,0 +1,11 @@ +CREATE TABLE test2763_book ( + id INTEGER PRIMARY KEY, + title VARCHAR(100) NOT NULL, + ts INTEGER NOT NULL +); + +CREATE TABLE test2763_employee ( + id BIGINT PRIMARY KEY, + name VARCHAR(100) NOT NULL, + version BIGINT NOT NULL +); \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test2763/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test2763/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test2763/hsql-drop.sql (revision 8436) @@ -0,0 +1,2 @@ +DROP TABLE test2763_book; +DROP TABLE test2763_employee; \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test200/sybase-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test200/sybase-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test200/sybase-create.sql (revision 8436) @@ -1,4 +1,4 @@ -create table test200_self_relation_folder ( +create table test200_self_rel_folder ( id int not null, name varchar(255) not null, parent_id int Index: cpactf/src/test/ddl/org/castor/cpa/test/test200/sybase-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test200/sybase-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test200/sybase-drop.sql (revision 8436) @@ -1,2 +1,2 @@ -drop table test200_self_relation_folder +drop table test200_self_rel_folder go \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test200/sapdb-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test200/sapdb-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test200/sapdb-create.sql (revision 8436) @@ -1,4 +1,4 @@ -create table test200_self_relation_folder ( +create table test200_self_rel_folder ( id int not null, name varchar(255) not null, parent_id int Index: cpactf/src/test/ddl/org/castor/cpa/test/test200/sapdb-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test200/sapdb-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test200/sapdb-drop.sql (revision 8436) @@ -1,2 +1,2 @@ -drop table test200_self_relation_folder +drop table test200_self_rel_folder // Index: cpactf/src/test/ddl/org/castor/cpa/test/test200/sql-server-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test200/sql-server-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test200/sql-server-create.sql (revision 8436) @@ -1,4 +1,4 @@ -create table test200_self_relation_folder ( +create table test200_self_rel_folder ( id int not null, name varchar(255) not null, parent_id int Index: cpactf/src/test/ddl/org/castor/cpa/test/test200/progress-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test200/progress-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test200/progress-create.sql (revision 8436) @@ -1,4 +1,4 @@ -create table test200_self_relation_folder ( +create table test200_self_rel_folder ( id int not null, name varchar(255) not null, parent_id int Index: cpactf/src/test/ddl/org/castor/cpa/test/test200/sql-server-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test200/sql-server-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test200/sql-server-drop.sql (revision 8436) @@ -1,2 +1,2 @@ -drop table test200_self_relation_folder +drop table test200_self_rel_folder go \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test200/progress-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test200/progress-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test200/progress-drop.sql (revision 8436) @@ -1 +1 @@ -drop table test200_self_relation_folder; +drop table test200_self_rel_folder; Index: cpactf/src/test/ddl/org/castor/cpa/test/test200/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test200/hsql-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test200/hsql-create.sql (revision 8436) @@ -1,4 +1,4 @@ -create table test200_self_relation_folder ( +create table test200_self_rel_folder ( id int not null, name varchar(255) not null, parent_id int Index: cpactf/src/test/ddl/org/castor/cpa/test/test200/db2-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test200/db2-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test200/db2-create.sql (revision 8436) @@ -1,4 +1,4 @@ -create table test200_self_relation_folder ( +create table test200_self_rel_folder ( id int not null, name varchar(255) not null, parent_id int Index: cpactf/src/test/ddl/org/castor/cpa/test/test200/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test200/hsql-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test200/hsql-drop.sql (revision 8436) @@ -1 +1 @@ -drop table test200_self_relation_folder; +drop table if exists test200_self_rel_folder; Index: cpactf/src/test/ddl/org/castor/cpa/test/test200/db2-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test200/db2-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test200/db2-drop.sql (revision 8436) @@ -1 +1 @@ -drop table test200_self_relation_folder; +drop table test200_self_rel_folder; Index: cpactf/src/test/ddl/org/castor/cpa/test/test99/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test99/hsql-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test99/hsql-create.sql (revision 8436) @@ -1,22 +1,24 @@ -CREATE TABLE test99_poly_Product( - IdProd int not null PRIMARY KEY, - NameProd VARCHAR(30) default NULL, - DescProd VARCHAR(30) default NULL +CREATE TABLE test99_poly_product( + idprod int not null PRIMARY KEY, + nameprod VARCHAR(30) default NULL, + descprod VARCHAR(30) default NULL ); -CREATE TABLE test99_poly_ActProduct( - IdAct int not null PRIMARY KEY REFERENCES test99_poly_Product (IdProd), - BestSeason VARCHAR(30) default NULL +CREATE TABLE test99_poly_actproduct( + idact int not null PRIMARY KEY , + bestseason VARCHAR(30) default NULL, + FOREIGN KEY(idact) REFERENCES test99_poly_product (idprod) ); -CREATE TABLE test99_poly_ComposedOffer( - IdCOffer int not null PRIMARY KEY REFERENCES test99_poly_Product (IdProd), - NameCO VARCHAR(30) default NULL, - DescCO VARCHAR(30) default NULL +CREATE TABLE test99_poly_composedoffer( + idcoffer int not null PRIMARY KEY , + nameco VARCHAR(30) default NULL, + descco VARCHAR(30) default NULL, + FOREIGN KEY(idcoffer) REFERENCES test99_poly_product (idprod) ); -CREATE TABLE test99_poly_OfferComposition( - Offer NUMERIC(10) not null, - Product NUMERIC(10) not null, - CONSTRAINT unique_rel UNIQUE (Offer, Product) +CREATE TABLE test99_poly_offercomposition( + offer int not null, + product int not null, + CONSTRAINT unique_rel UNIQUE (offer, product) ); Index: cpactf/src/test/ddl/org/castor/cpa/test/test201/pointbase-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test201/pointbase-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test201/pointbase-create.sql (revision 8436) @@ -1,9 +1,9 @@ -create table test201_self_relation_parent ( +create table test201_self_rel_parent ( id int not null, name varchar(255) not null ); -create table test201_self_relation_extend ( +create table test201_self_rel_extend ( id int not null, parent_id int ); Index: cpactf/src/test/ddl/org/castor/cpa/test/test201/pointbase-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test201/pointbase-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test201/pointbase-drop.sql (revision 8436) @@ -1,2 +1,2 @@ -drop table test201_self_relation_extend; -drop table test201_self_relation_parent; +drop table test201_self_rel_extend; +drop table test201_self_rel_parent; Index: cpactf/src/test/ddl/org/castor/cpa/test/test201/sybase-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test201/sybase-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test201/sybase-create.sql (revision 8436) @@ -1,10 +1,10 @@ -create table test201_self_relation_parent ( +create table test201_self_rel_parent ( id int not null, name varchar(255) not null ) go -create table test201_self_relation_extend ( +create table test201_self_rel_extend ( id int not null, parent_id int ) Index: cpactf/src/test/ddl/org/castor/cpa/test/test201/sybase-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test201/sybase-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test201/sybase-drop.sql (revision 8436) @@ -1,4 +1,4 @@ -drop table test201_self_relation_extend +drop table test201_self_rel_extend go -drop table test201_self_relation_parent +drop table test201_self_rel_parent go Index: cpactf/src/test/ddl/org/castor/cpa/test/test201/sapdb-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test201/sapdb-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test201/sapdb-create.sql (revision 8436) @@ -1,10 +1,10 @@ -create table test201_self_relation_parent ( +create table test201_self_rel_parent ( id int not null, name varchar(255) not null ) // -create table test201_self_relation_extend ( +create table test201_self_rel_extend ( id int not null, parent_id int ) Index: cpactf/src/test/ddl/org/castor/cpa/test/test201/sapdb-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test201/sapdb-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test201/sapdb-drop.sql (revision 8436) @@ -1,4 +1,4 @@ -drop table test201_self_relation_extend +drop table test201_self_rel_extend // -drop table test201_self_relation_parent +drop table test201_self_rel_parent // Index: cpactf/src/test/ddl/org/castor/cpa/test/test201/sql-server-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test201/sql-server-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test201/sql-server-create.sql (revision 8436) @@ -1,10 +1,10 @@ -create table test201_self_relation_parent ( +create table test201_self_rel_parent ( id int not null, name varchar(255) not null ) go -create table test201_self_relation_extend ( +create table test201_self_rel_extend ( id int not null, parent_id int ) Index: cpactf/src/test/ddl/org/castor/cpa/test/test201/progress-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test201/progress-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test201/progress-create.sql (revision 8436) @@ -1,9 +1,9 @@ -create table test201_self_relation_parent ( +create table test201_self_rel_parent ( id int not null, name varchar(255) not null ); -create table test201_self_relation_extend ( +create table test201_self_rel_extend ( id int not null, parent_id int ); Index: cpactf/src/test/ddl/org/castor/cpa/test/test201/sql-server-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test201/sql-server-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test201/sql-server-drop.sql (revision 8436) @@ -1,4 +1,4 @@ -drop table test201_self_relation_extend +drop table test201_self_rel_extend go -drop table test201_self_relation_parent +drop table test201_self_rel_parent go Index: cpactf/src/test/ddl/org/castor/cpa/test/test201/progress-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test201/progress-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test201/progress-drop.sql (revision 8436) @@ -1,2 +1,2 @@ -drop table test201_self_relation_extend; -drop table test201_self_relation_parent; +drop table test201_self_rel_extend; +drop table test201_self_rel_parent; Index: cpactf/src/test/ddl/org/castor/cpa/test/test201/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test201/hsql-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test201/hsql-create.sql (revision 8436) @@ -1,9 +1,9 @@ -create table test201_self_relation_parent ( +create table test201_self_rel_parent ( id int not null, name varchar(255) not null ); -create table test201_self_relation_extend ( +create table test201_self_rel_extend ( id int not null, parent_id int ); Index: cpactf/src/test/ddl/org/castor/cpa/test/test201/db2-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test201/db2-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test201/db2-create.sql (revision 8436) @@ -1,9 +1,9 @@ -create table test201_self_relation_parent ( +create table test201_self_rel_parent ( id int not null, name varchar(255) not null ); -create table test201_self_relation_extend ( +create table test201_self_rel_extend ( id int not null, parent_id int ); \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test201/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test201/hsql-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test201/hsql-drop.sql (revision 8436) @@ -1,2 +1,2 @@ -drop table test201_self_relation_extend; -drop table test201_self_relation_parent; +drop table test201_self_rel_parent; +drop table test201_self_rel_parent; Index: cpactf/src/test/ddl/org/castor/cpa/test/test201/db2-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test201/db2-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test201/db2-drop.sql (revision 8436) @@ -1,2 +1,2 @@ -drop table test201_self_relation_extend; -drop table test201_self_relation_parent; +drop table test201_self_rel_extend; +drop table test201_self_rel_parent; Index: cpactf/src/test/ddl/org/castor/cpa/test/test2567/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test2567/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test2567/hsql-create.sql (revision 8436) @@ -0,0 +1,12 @@ +CREATE TABLE test2567_entity ( + partname VARCHAR (29), + origdatereqd DATE, + custordernumber VARCHAR (20), + loaddate DATE +); + +INSERT INTO test2567_entity ( + partname, origdatereqd, custordernumber, loaddate +) VALUES ( + 'PART-30021', '2005-01-03', '12701', '2004-04-26' +); Index: cpactf/src/test/ddl/org/castor/cpa/test/test2567/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test2567/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test2567/hsql-drop.sql (revision 8436) @@ -0,0 +1 @@ +DROP TABLE test2567_entity; Index: cpactf/src/test/ddl/org/castor/cpa/test/test202/pointbase-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test202/pointbase-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test202/pointbase-create.sql (revision 8436) @@ -1,12 +1,12 @@ -create table test202_foreign_key_first_entity_1 ( +create table test202_fkf_entity_1 ( id int NOT NULL, - number int + numb int ); -create table test202_foreign_key_first_entity_n ( +create table test202_fkf_entity_n ( id int NOT NULL, entity int NOT NULL, - number int + numb int ); -insert into test202_foreign_key_first_entity_1 VALUES (1, 1); \ No newline at end of file +insert into test202_fkf_entity_1 VALUES (1, 1); \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test202/pointbase-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test202/pointbase-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test202/pointbase-drop.sql (revision 8436) @@ -1,2 +1,2 @@ -drop table test202_foreign_key_first_entity_1; -drop table test202_foreign_key_first_entity_n; \ No newline at end of file +drop table test202_fkf_entity_1; +drop table test202_fkf_entity_n; \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test202/sybase-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test202/sybase-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test202/sybase-create.sql (revision 8436) @@ -1,15 +1,15 @@ -create table test202_foreign_key_first_entity_1 ( +create table test202_fkf_entity_1 ( id int NOT NULL, number int ) go -create table test202_foreign_key_first_entity_n ( +create table test202_fkf_entity_n ( id int NOT NULL, entity int NOT NULL, number int ) go -insert into test202_foreign_key_first_entity_1 VALUES (1, 1) +insert into test202_fkf_entity_1 VALUES (1, 1) go \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test202/sybase-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test202/sybase-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test202/sybase-drop.sql (revision 8436) @@ -1,4 +1,4 @@ -drop table test202_foreign_key_first_entity_1 +drop table test202_fkf_entity_1 go -drop table test202_foreign_key_first_entity_n +drop table test202_fkf_entity_n go \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test202/sapdb-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test202/sapdb-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test202/sapdb-create.sql (revision 8436) @@ -1,15 +1,15 @@ -create table test202_foreign_key_first_entity_1 ( +create table test202_fkf_entity_1 ( id int NOT NULL, number int ) // -create table test202_foreign_key_first_entity_n ( +create table test202_fkf_entity_n ( id int NOT NULL, entity int NOT NULL, number int ) // -insert into test202_foreign_key_first_entity_1 VALUES (1, 1) +insert into test202_fkf_entity_1 VALUES (1, 1) // \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test202/sapdb-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test202/sapdb-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test202/sapdb-drop.sql (revision 8436) @@ -1,4 +1,4 @@ -drop table test202_foreign_key_first_entity_1 +drop table test202_fkf_entity_1 // -drop table test202_foreign_key_first_entity_n +drop table test202_fkf_entity_n // \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test202/sql-server-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test202/sql-server-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test202/sql-server-create.sql (revision 8436) @@ -1,15 +1,15 @@ -create table test202_foreign_key_first_entity_1 ( +create table test202_fkf_entity_1 ( id int NOT NULL, number int ) go -create table test202_foreign_key_first_entity_n ( +create table test202_fkf_entity_n ( id int NOT NULL, entity int NOT NULL, number int ) go -insert into test202_foreign_key_first_entity_1 VALUES (1, 1) +insert into test202_fkf_entity_1 VALUES (1, 1) go \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test202/progress-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test202/progress-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test202/progress-create.sql (revision 8436) @@ -1,12 +1,12 @@ -create table test202_foreign_key_first_entity_1 ( +create table test202_fkf_entity_1 ( id int NOT NULL, - number int + numb int ); -create table test202_foreign_key_first_entity_n ( +create table test202_fkf_entity_n ( id int NOT NULL, entity int NOT NULL, - number int + numb int ); -insert into test202_foreign_key_first_entity_1 VALUES (1, 1); \ No newline at end of file +insert into test202_fkf_entity_1 VALUES (1, 1); \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test202/sql-server-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test202/sql-server-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test202/sql-server-drop.sql (revision 8436) @@ -1,4 +1,4 @@ -drop table test202_foreign_key_first_entity_1 +drop table test202_fkf_entity_1 go -drop table test202_foreign_key_first_entity_n +drop table test202_fkf_entity_n go \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test202/progress-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test202/progress-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test202/progress-drop.sql (revision 8436) @@ -1,2 +1,2 @@ -drop table test202_foreign_key_first_entity_1; -drop table test202_foreign_key_first_entity_n; \ No newline at end of file +drop table test202_fkf_entity_1; +drop table test202_fkf_entity_n; \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test202/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test202/hsql-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test202/hsql-create.sql (revision 8436) @@ -1,12 +1,12 @@ -create table test202_foreign_key_first_entity_1 ( +create table test202_fkf_entity_1 ( id int NOT NULL, - number int + numb int ); -create table test202_foreign_key_first_entity_n ( +create table test202_fkf_entity_n ( id int NOT NULL, entity int NOT NULL, - number int + numb int ); -insert into test202_foreign_key_first_entity_1 VALUES (1, 1); \ No newline at end of file +insert into test202_fkf_entity_1 VALUES (1, 1); \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test202/db2-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test202/db2-create.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test202/db2-create.sql (revision 8436) @@ -1,12 +1,12 @@ -create table test202_foreign_key_first_entity_1 ( +create table test202_fkf_entity_1 ( id int NOT NULL, - number int + numb int ); -create table test202_foreign_key_first_entity_n ( +create table test202_fkf_entity_n ( id int NOT NULL, entity int NOT NULL, - number int + numb int ); -insert into test202_foreign_key_first_entity_1 VALUES (1, 1); \ No newline at end of file +insert into test202_fkf_entity_1 VALUES (1, 1); \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test202/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test202/hsql-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test202/hsql-drop.sql (revision 8436) @@ -1,2 +1,2 @@ -drop table test202_foreign_key_first_entity_1; -drop table test202_foreign_key_first_entity_n; \ No newline at end of file +drop table test202_fkf_entity_1; +drop table test202_fkf_entity_n; \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test202/db2-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test202/db2-drop.sql (revision 8435) +++ cpactf/src/test/ddl/org/castor/cpa/test/test202/db2-drop.sql (revision 8436) @@ -1,2 +1,2 @@ -drop table test202_foreign_key_first_entity_1; -drop table test202_foreign_key_first_entity_n; \ No newline at end of file +drop table test202_fkf_entity_1; +drop table test202_fkf_entity_n; \ No newline at end of file Index: cpactf/src/test/ddl/org/castor/cpa/test/test241/hsql-create.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test241/hsql-create.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test241/hsql-create.sql (revision 8436) @@ -0,0 +1,4 @@ +create table test241_prod ( + id int not null, + name varchar(200) not null +); Index: cpactf/src/test/ddl/org/castor/cpa/test/test241/hsql-drop.sql =================================================================== --- cpactf/src/test/ddl/org/castor/cpa/test/test241/hsql-drop.sql (revision 0) +++ cpactf/src/test/ddl/org/castor/cpa/test/test241/hsql-drop.sql (revision 8436) @@ -0,0 +1 @@ +drop table test241_prod; Index: cpactf/src/test/resources/CPACTF-Matrix.ods =================================================================== Cannot display: file marked as a binary type. svn:mime-type = application/octet-stream