Community
Participate
Working Groups
JDBCBatchUpdatesTestModel failed to setup on PostgreSQL v8.2.5 Stack Trace: ============ Internal Exception: java.sql.BatchUpdateException: Batch entry 12 INSERT INTO EMPLOYEE (EMP_ID, F_NAME, L_NAME, GENDER, START_TIME, END_TIME, END_DATE, START_DATE, ADDR_ID, MANAGER_ID, VERSION) VALUES (91011, 'Fred', 'Jones', 'M', {t '09:00:00'}, {t '17:00:00'}, {d '1895-01-01'}, {d '1901-12-31'}, 21563, NULL, 1) was aborted. Call getNextException to see the cause. Error Code: 0 Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.1.v20090430-r4097): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.BatchUpdateException: Batch entry 12 INSERT INTO EMPLOYEE (EMP_ID, F_NAME, L_NAME, GENDER, START_TIME, END_TIME, END_DATE, START_DATE, ADDR_ID, MANAGER_ID, VERSION) VALUES (91011, 'Fred', 'Jones', 'M', {t '09:00:00'}, {t '17:00:00'}, {d '1895-01-01'}, {d '1901-12-31'}, 21563, NULL, 1) was aborted. Call getNextException to see the cause. Error Code: 0 at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:332) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1372) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeJDK12BatchStatement(DatabaseAccessor.java:793) at org.eclipse.persistence.internal.databaseaccess.DynamicSQLBatchWritingMechanism.executeBatchedStatements(DynamicSQLBatchWritingMechanism.java:124) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.writesCompleted(DatabaseAccessor.java:1594) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.commitTransaction(DatabaseAccessor.java:374) at org.eclipse.persistence.internal.sessions.AbstractSession.basicCommitTransaction(AbstractSession.java:477) at org.eclipse.persistence.internal.sessions.AbstractSession.commitTransaction(AbstractSession.java:645) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitTransaction(UnitOfWorkImpl.java:1453) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1321) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1398) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitRootUnitOfWork(UnitOfWorkImpl.java:1229) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commit(UnitOfWorkImpl.java:1007) at org.eclipse.persistence.testing.models.employee.relational.EmployeeSystem.populate(EmployeeSystem.java:161) at org.eclipse.persistence.testing.framework.TestSystem.run(TestSystem.java:170) at org.eclipse.persistence.testing.framework.TestExecutor.forceConfigureSystem(TestExecutor.java:275) at org.eclipse.persistence.testing.framework.TestModel.configure(TestModel.java:188) at org.eclipse.persistence.testing.framework.TestModel.setupEntity(TestModel.java:413) at org.eclipse.persistence.testing.framework.TestModel.execute(TestModel.java:200) at org.eclipse.persistence.testing.framework.TestCollection.run(TestCollection.java:313) at org.eclipse.persistence.testing.framework.TestExecutor.execute(TestExecutor.java:247) at org.eclipse.persistence.testing.framework.TestModel.execute(TestModel.java:208) at org.eclipse.persistence.testing.framework.TestCollection.run(TestCollection.java:313) Caused by: java.sql.BatchUpdateException: Batch entry 12 INSERT INTO EMPLOYEE (EMP_ID, F_NAME, L_NAME, GENDER, START_TIME, END_TIME, END_DATE, START_DATE, ADDR_ID, MANAGER_ID, VERSION) VALUES (91011, 'Fred', 'Jones', 'M', {t '09:00:00'}, {t '17:00:00'}, {d '1895-01-01'}, {d '1901-12-31'}, 21563, NULL, 1) was aborted. Call getNextException to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530) at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:402) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2592) at org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.executeBatch(DatabasePlatform.java:1767) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeJDK12BatchStatement(DatabaseAccessor.java:787)
This bug fix did not make the cut off for 2.1. We are deferring the bugs to Future where we can properly sort them all together and severity. And then assign them accordingly to future patch sets and releases.
Test model PASSED on [EL Info]: EclipseLink, version: Eclipse Persistence Services - 2.2.0.qualifier [EL Config]: connecting(DatabaseLogin( platform=>PostgreSQLPlatform user name=> "qaname" datasource URL=> "jdbc:postgresql://myhost/toplink" )) [EL Config]: Connected: jdbc:postgresql://myhost/toplink User: qaname Database: PostgreSQL Version: 8.2.5 Driver: PostgreSQL Native Driver Version: PostgreSQL 8.4 JDBC4 (build 701) [EL Info]: login successful VERSION: Eclipse Persistence Services - 2.2.0.qualifier TEST MODEL NAME: JDBCBatchUpdatesTestModel MODEL DESCRIPTION: RESULTS OF TEST MODEL: JDBCBatchUpdatesTestModel Warnings: 0 Problems: 0 Errors: 0 Fatal Errors: 0 Passed: 107 Setup Warnings: 0 Setup Failures: 0 Total Time: 39805 Total Tests: 107
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink
