DataNucleus with HSQLDB embedded

Performance Result Summary

The final position of DataNucleus with HSQLDB embedded in the speed performance tests is 24 out of 32,

The following charts show DataNucleus with HSQLDB embedded relatively to other tested JPA/DBMS combinations.

Position #1 on the X-Axis (the fastest) is about 100 times faster than position #32 (the slowest).
In the chart below the Y-Axis represents result score (maximum 100) in logarithmic scale - higher is better:
JPA performance benchmark comparision Hibernate, EclipseLink, OpenJPA, DataNucleus, ObjectDB
In the chart below the Y-Axis represents result score (maximum 100) in linear scale - higher is better:
JPA performance benchmark comparision Hibernate, EclipseLink, OpenJPA, DataNucleus, ObjectDB

DataNucleus with HSQLDB embedded Problems (Exceptions)

DataNucleus with HSQLDB embedded has failed in the following tests (throwing the following stack traces):

  • Element Collection Test - Retrieval Operations - Few Entities (5/100)
    An exception was thrown while adding/validating class(es) : object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RetrieveAction.run0(Runner.java:541)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
    org.datanucleus.exceptions.NucleusDataStoreException: An exception was thrown while adding/validating class(es) : object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RetrieveAction.run0(Runner.java:541)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2569)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RetrieveAction.run0(Runner.java:541)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	... 17 more
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    Nested Throwables StackTrace:
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RetrieveAction.run0(Runner.java:541)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
  • Element Collection Test - Retrieval Operations - Many Entities (5000)
    An exception was thrown while adding/validating class(es) : object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RetrieveAction.run0(Runner.java:541)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
    org.datanucleus.exceptions.NucleusDataStoreException: An exception was thrown while adding/validating class(es) : object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RetrieveAction.run0(Runner.java:541)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2569)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RetrieveAction.run0(Runner.java:541)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	... 17 more
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    Nested Throwables StackTrace:
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RetrieveAction.run0(Runner.java:541)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
  • Element Collection Test - Query Operations - Few Entities (5/100)
    An exception was thrown while adding/validating class(es) : object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.query(Test.java:314)
    	at org.jpab.Runner$QueryAction.run0(Runner.java:553)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 25 more
    
    org.datanucleus.exceptions.NucleusDataStoreException: An exception was thrown while adding/validating class(es) : object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.query(Test.java:314)
    	at org.jpab.Runner$QueryAction.run0(Runner.java:553)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 25 more
    
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2569)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.query(Test.java:314)
    	at org.jpab.Runner$QueryAction.run0(Runner.java:553)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	... 16 more
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 25 more
    Nested Throwables StackTrace:
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.query(Test.java:314)
    	at org.jpab.Runner$QueryAction.run0(Runner.java:553)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 25 more
    
  • Element Collection Test - Query Operations - Many Entities (5000)
    An exception was thrown while adding/validating class(es) : object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.query(Test.java:314)
    	at org.jpab.Runner$QueryAction.run0(Runner.java:553)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 25 more
    
    org.datanucleus.exceptions.NucleusDataStoreException: An exception was thrown while adding/validating class(es) : object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.query(Test.java:314)
    	at org.jpab.Runner$QueryAction.run0(Runner.java:553)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 25 more
    
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2569)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.query(Test.java:314)
    	at org.jpab.Runner$QueryAction.run0(Runner.java:553)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	... 16 more
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 25 more
    Nested Throwables StackTrace:
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.query(Test.java:314)
    	at org.jpab.Runner$QueryAction.run0(Runner.java:553)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 25 more
    
  • Element Collection Test - Update Operations - Few Entities (5/100)
    An exception was thrown while adding/validating class(es) : object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$UpdateAction.run0(Runner.java:565)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
    org.datanucleus.exceptions.NucleusDataStoreException: An exception was thrown while adding/validating class(es) : object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$UpdateAction.run0(Runner.java:565)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2569)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$UpdateAction.run0(Runner.java:565)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	... 17 more
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    Nested Throwables StackTrace:
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$UpdateAction.run0(Runner.java:565)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
  • Element Collection Test - Update Operations - Many Entities (5000)
    An exception was thrown while adding/validating class(es) : object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$UpdateAction.run0(Runner.java:565)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
    org.datanucleus.exceptions.NucleusDataStoreException: An exception was thrown while adding/validating class(es) : object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$UpdateAction.run0(Runner.java:565)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2569)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$UpdateAction.run0(Runner.java:565)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	... 17 more
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    Nested Throwables StackTrace:
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$UpdateAction.run0(Runner.java:565)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
  • Element Collection Test - Removal Operations - Few Entities (5/100)
    An exception was thrown while adding/validating class(es) : object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RemoveAction.run0(Runner.java:578)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
    org.datanucleus.exceptions.NucleusDataStoreException: An exception was thrown while adding/validating class(es) : object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RemoveAction.run0(Runner.java:578)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2569)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RemoveAction.run0(Runner.java:578)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	... 17 more
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    Nested Throwables StackTrace:
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RemoveAction.run0(Runner.java:578)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
  • Element Collection Test - Removal Operations - Many Entities (5000)
    An exception was thrown while adding/validating class(es) : object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RemoveAction.run0(Runner.java:578)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
    org.datanucleus.exceptions.NucleusDataStoreException: An exception was thrown while adding/validating class(es) : object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RemoveAction.run0(Runner.java:578)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2569)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RemoveAction.run0(Runner.java:578)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	... 17 more
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    Nested Throwables StackTrace:
    java.sql.SQLException: object name already exists: COLLECTIONPERSON_STRING in statement [CREATE TABLE COLLECTIONPERSON_STRING
    (
        COLLECTIONPERSON_ID INTEGER NOT NULL,
        PHONES_ELEMENT VARCHAR(255) NULL
    )]
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
    	at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
    	at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)
    	at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2732)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2546)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2191)
    	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
    	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:966)
    	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
    	at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)
    	at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:298)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:745)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RemoveAction.run0(Runner.java:578)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hsqldb.HsqlException: object name already exists: COLLECTIONPERSON_STRING
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
    	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
    	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
    	at org.hsqldb.StatementSchema.getResult(Unknown Source)
    	at org.hsqldb.StatementSchema.execute(Unknown Source)
    	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 26 more
    
  • Multithreading Test - Query Operations - Few Entities (5/100)
    java.lang.IllegalStateException: Table object has not been been initialised : PERSON
    	at org.datanucleus.store.rdbms.table.AbstractTable.assertIsInitialized(AbstractTable.java:625)
    	at org.datanucleus.store.rdbms.table.ClassTable.getMemberMapping(ClassTable.java:2935)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.getSQLTableMappingForPrimaryExpression(QueryToSQLMapper.java:2050)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.processPrimaryExpression(QueryToSQLMapper.java:1921)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.processInvokeExpression(QueryToSQLMapper.java:2451)
    	at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compilePrimaryExpression(AbstractExpressionEvaluator.java:196)
    	at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compileUnaryExpression(AbstractExpressionEvaluator.java:165)
    	at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compileAdditiveMultiplicativeExpression(AbstractExpressionEvaluator.java:144)
    	at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compileRelationalExpression(AbstractExpressionEvaluator.java:119)
    	at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compileOrAndExpression(AbstractExpressionEvaluator.java:65)
    	at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.evaluate(AbstractExpressionEvaluator.java:46)
    	at org.datanucleus.query.expression.Expression.evaluate(Expression.java:334)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compileFilter(QueryToSQLMapper.java:423)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compile(QueryToSQLMapper.java:343)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:754)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.query(Test.java:314)
    	at org.jpab.Runner$QueryAction.run0(Runner.java:553)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    
  • Multithreading Test - Query Operations - Many Entities (5000)
    java.lang.IllegalStateException: Table object has not been been initialised : PERSON
    	at org.datanucleus.store.rdbms.table.AbstractTable.assertIsInitialized(AbstractTable.java:625)
    	at org.datanucleus.store.rdbms.table.ClassTable.getMemberMapping(ClassTable.java:2935)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.getSQLTableMappingForPrimaryExpression(QueryToSQLMapper.java:2050)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.processPrimaryExpression(QueryToSQLMapper.java:1921)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.processInvokeExpression(QueryToSQLMapper.java:2451)
    	at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compilePrimaryExpression(AbstractExpressionEvaluator.java:196)
    	at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compileUnaryExpression(AbstractExpressionEvaluator.java:165)
    	at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compileAdditiveMultiplicativeExpression(AbstractExpressionEvaluator.java:144)
    	at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compileRelationalExpression(AbstractExpressionEvaluator.java:119)
    	at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compileOrAndExpression(AbstractExpressionEvaluator.java:65)
    	at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.evaluate(AbstractExpressionEvaluator.java:46)
    	at org.datanucleus.query.expression.Expression.evaluate(Expression.java:334)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compileFilter(QueryToSQLMapper.java:423)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compile(QueryToSQLMapper.java:343)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:754)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.query(Test.java:314)
    	at org.jpab.Runner$QueryAction.run0(Runner.java:553)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    
  • Multithreading Test - Update Operations - Few Entities (5/100)
    java.lang.IllegalStateException: Table object has not been been initialised : PERSON
    	at org.datanucleus.store.rdbms.table.AbstractTable.assertIsInitialized(AbstractTable.java:625)
    	at org.datanucleus.store.rdbms.table.ClassTable.getMemberMapping(ClassTable.java:2935)
    	at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectMemberOfSourceInStatement(SQLStatementHelper.java:617)
    	at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(SQLStatementHelper.java:546)
    	at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfCandidateInStatement(SQLStatementHelper.java:504)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compileResult(QueryToSQLMapper.java:679)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compile(QueryToSQLMapper.java:362)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:754)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$UpdateAction.run0(Runner.java:565)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    
  • Multithreading Test - Update Operations - Many Entities (5000)
    java.lang.IllegalStateException: Table object has not been been initialised : PERSON
    	at org.datanucleus.store.rdbms.table.AbstractTable.assertIsInitialized(AbstractTable.java:625)
    	at org.datanucleus.store.rdbms.table.ClassTable.getMemberMapping(ClassTable.java:2935)
    	at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectMemberOfSourceInStatement(SQLStatementHelper.java:617)
    	at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(SQLStatementHelper.java:546)
    	at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfCandidateInStatement(SQLStatementHelper.java:504)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compileResult(QueryToSQLMapper.java:679)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compile(QueryToSQLMapper.java:362)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:754)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$UpdateAction.run0(Runner.java:565)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    
  • Multithreading Test - Removal Operations - Few Entities (5/100)
    java.lang.IllegalStateException: Table object has not been been initialised : PERSON
    	at org.datanucleus.store.rdbms.table.AbstractTable.assertIsInitialized(AbstractTable.java:625)
    	at org.datanucleus.store.rdbms.table.ClassTable.getMemberMapping(ClassTable.java:2935)
    	at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectMemberOfSourceInStatement(SQLStatementHelper.java:617)
    	at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(SQLStatementHelper.java:546)
    	at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfCandidateInStatement(SQLStatementHelper.java:504)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compileResult(QueryToSQLMapper.java:679)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compile(QueryToSQLMapper.java:362)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:754)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:380)
    	at org.jpab.Test.doAction(Test.java:251)
    	at org.jpab.Runner$RemoveAction.run0(Runner.java:578)
    	at org.jpab.Runner$TestAction.run(Runner.java:508)
    	at java.lang.Thread.run(Thread.java:619)
    

The following runs have been stopped due to being too slow

  • Graph (Binary Tree) Test - Retrieval Operations - Few Entities (5/100)
  • Graph (Binary Tree) Test - Retrieval Operations - Many Entities (5000)
  • Graph (Binary Tree) Test - Update Operations - Few Entities (5/100)
  • Graph (Binary Tree) Test - Update Operations - Many Entities (5000)
  • Graph (Binary Tree) Test - Removal Operations - Few Entities (5/100)
  • Graph (Binary Tree) Test - Removal Operations - Many Entities (5000)
  • Graph (Binary Tree) Test - Storage Efficiency - Few Entities (5/100)
  • Graph (Binary Tree) Test - Storage Efficiency - Many Entities (5000)

DataNucleus with HSQLDB embedded compared to the alternatives

See head to head comparisons of DataNucleus with HSQLDB embedded vs the following compatitors: