testExternalValues failed with ORA-01438 Oracle exception --------------------------------------------------------- Key: OPENJPA-1849 URL: https://issues.apache.org/jira/browse/OPENJPA-1849 Project: OpenJPA Issue Type: Test Components: jpa Affects Versions: 2.0.1, 2.0.0 Reporter: Albert Lee Assignee: Albert Lee Priority: Minor Fix For: 2.0.2, 2.1.0 TestExternalValues.testExternalValues failed to run for Oracle with the following exception: org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred. FailedObject: org.apache.openjpa.persistence.external.EntityA@1ee21ee2 at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:584) at org.apache.openjpa.persistence.external.TestExternalValues.testExternalValues(TestExternalValues.java:48) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:600) at junit.framework.TestCase.runTest(TestCase.java:154) at org.apache.openjpa.persistence.test.AbstractPersistenceTestCase.runTest(AbstractPersistenceTestCase.java:575) at junit.framework.TestCase.runBare(TestCase.java:127) at org.apache.openjpa.persistence.test.AbstractPersistenceTestCase.runBare(AbstractPersistenceTestCase.java:562) at org.apache.openjpa.persistence.test.AbstractPersistenceTestCase.runBare(AbstractPersistenceTestCase.java:538) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at org.apache.openjpa.persistence.test.AbstractPersistenceTestCase.run(AbstractPersistenceTestCase.java:206) at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196) Caused by: org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred. FailedObject: org.apache.openjpa.persistence.external.EntityA@1ee21ee2 at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2311) at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2149) at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2046) at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1964) at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81) at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1488) at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:925) at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:560) ... 21 more Caused by: org.apache.openjpa.persistence.PersistenceException: ORA-01438: value larger than specified precision allowed for this column {prepstmnt 1067532193 INSERT INTO ExternalizationEntityA (id, USE_STREAMING, s1, s2) VALUES (?, ?, ?, ?) [params=(int) 401, (int) 84, (String) SML, (int) 8]} [code=1438, state=22003] FailedObject: org.apache.openjpa.persistence.external.EntityA@1ee21ee2 at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4869) at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4829) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:137) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78) at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushBatch(BatchingPreparedStatementManagerImpl.java:217) at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:63) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:103) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:76) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:738) at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131) ... 28 more Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-01438: value larger than specified precision allowed for this column {prepstmnt 1067532193 INSERT INTO ExternalizationEntityA (id, USE_STREAMING, s1, s2) VALUES (?, ?, ?, ?) [params=(int) 401, (int) 84, (String) SML, (int) 8]} [code=1438, state=22003] at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:274) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:250) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$4(LoggingConnectionDecorator.java:249) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1192) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:288) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1772) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:267) at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushSingleRow(BatchingPreparedStatementManagerImpl.java:246) at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushBatch(BatchingPreparedStatementManagerImpl.java:155) ... 33 more -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.