[ https://issues.apache.org/jira/browse/DERBY-3360?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12563531#action_12563531 ]
northshorefiend edited comment on DERBY-3360 at 1/29/08 6:40 AM: --------------------------------------------------------------------- More info, CAST(FN_MATCHES(..) AS INTEGER) avoids the bug. 10.3.1.4 (sane) shows this behaviour too was (Author: northshorefiend): More info, CAST(FN_MATCHES(..) AS INTEGER) avoids the bug. 10.3.2.1 and 10.3.1.4 do not show this behaviour > Invalid method java.lang.Integer >> void <init>(short) because > java.lang.NoSuchMethodException: java.lang.Integer.<init>(short) > ------------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-3360 > URL: https://issues.apache.org/jira/browse/DERBY-3360 > Project: Derby > Issue Type: Bug > Affects Versions: 10.3.2.2 > Environment: Derby 10.3 Branch [10.3.2.2 - (616244M)] > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) 64-Bit Server VM (build 1.6.0_03-b05, mixed mode) > Reporter: James Alan Shepherd > > Invalid method java.lang.Integer >> void <init>(short) because > java.lang.NoSuchMethodException: java.lang.Integer.<init>(short) > True, but I believe, not a helpful observation :-) > FN_MATCHES(A.f, C.d) returns short/SMALLINT > related to DERBY-3310 ? But this is on the 10.3 branch [10.3.2.2 - (616244M)] > DEBUG 68421 [Main] (Template.java:69) - SQL: SELECT A.a, D.b, B.c, C.d FROM C > JOIN A ON C.e = 'I' AND A.f IS NOT NULL AND A.g = C.g AND FN_MATCHES(A.f, > C.d) <> 1 JOIN B ON B.h = A.g JOIN D ON D.h = URID.h > java.lang.NoSuchMethodException: java.lang.Integer.<init>(short) > at java.lang.Class.getConstructor0(Class.java:2706) > at java.lang.Class.getConstructor(Class.java:1657) > at > org.apache.derby.impl.services.bytecode.d_BCValidate.checkMethod(d_BCValidate.java:115) > at > org.apache.derby.impl.services.bytecode.BCMethod.callMethod(BCMethod.java:745) > at > org.apache.derby.impl.services.bytecode.BCMethod.pushNewComplete(BCMethod.java:779) > at > org.apache.derby.impl.sql.compile.StaticMethodCallNode.generateExpression(StaticMethodCallNode.java:995) > at > org.apache.derby.impl.sql.compile.JavaToSQLValueNode.generateExpression(JavaToSQLValueNode.java:167) > at > org.apache.derby.impl.sql.compile.BinaryOperatorNode.generateExpression(BinaryOperatorNode.java:599) > at > org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.generateExpression(BinaryLogicalOperatorNode.java:157) > at > org.apache.derby.impl.sql.compile.ProjectRestrictNode.generateMinion(ProjectRestrictNode.java:1484) > at > org.apache.derby.impl.sql.compile.ProjectRestrictNode.generate(ProjectRestrictNode.java:1302) > at > org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1579) > at > org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555) > at > org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479) > at > org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577) > at > org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555) > at > org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479) > at > org.apache.derby.impl.sql.compile.ProjectRestrictNode.generateMinion(ProjectRestrictNode.java:1440) > at > org.apache.derby.impl.sql.compile.ProjectRestrictNode.generate(ProjectRestrictNode.java:1302) > at > org.apache.derby.impl.sql.compile.ScrollInsensitiveResultSetNode.generate(ScrollInsensitiveResultSetNode.java:109) > at > org.apache.derby.impl.sql.compile.CursorNode.generate(CursorNode.java:564) > at > org.apache.derby.impl.sql.compile.StatementNode.generate(StatementNode.java:347) > at > org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:447) > at > org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88) > at > org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:746) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:129) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(EmbedPreparedStatement40.java:40) > at > org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Driver40.java:105) > at > org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:923) > at > org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:751) > [..] > at > org.apache.derby.exe.ac12564092x0117xc525x43e4xffffbce342b018.g0(Unknown > Source) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.apache.derby.impl.services.reflect.ReflectMethod.invoke(ReflectMethod.java:46) > at > org.apache.derby.impl.sql.execute.CallStatementResultSet.open(CallStatementResultSet.java:74) > at > org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370) > at > org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(GenericTriggerExecutor.java:173) > at > org.apache.derby.impl.sql.execute.StatementTriggerExecutor.fireTrigger(StatementTriggerExecutor.java:80) > at > org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(TriggerEventActivator.java:278) > at > org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(InsertResultSet.java:1163) > at > org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java:497) > at > org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370) > at > org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(GenericTriggerExecutor.java:173) > at > org.apache.derby.impl.sql.execute.StatementTriggerExecutor.fireTrigger(StatementTriggerExecutor.java:80) > at > org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(TriggerEventActivator.java:278) > at > org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(InsertResultSet.java:1163) > at > org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java:497) > at > org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370) > at > org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1203) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1652) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:299) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) > at > org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:745) > at > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:538) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:739) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:797) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:801) > at > org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:218) > > Invalid method java.lang.Integer >> void <init>(short) because > java.lang.NoSuchMethodException: java.lang.Integer.<init>(short) > DEBUG 70472 [Main] (Template.java:120) - java.sql.SQLException: Java > exception: 'ASSERT FAILED Invalid method java.lang.Integer >> void > <init>(short) because java.lang.NoSuchMethodException: > java.lang.Integer.<init>(short): > org.apache.derby.shared.common.sanity.AssertFailure'. > ERROR 70500 [Main] (TransactionTemplate.java:163) - Application exception > overridden by rollback exception > org.springframework.jdbc.UncategorizedSQLException: > PreparedStatementCallback; uncategorized SQLException for SQL [ <Statement > that fires trigger removed> ]; SQL state [XJ001]; error code [0]; Java > exception: ': java.lang.NullPointerException'.; nested exception is > java.sql.SQLException: Java exception: ': java.lang.NullPointerException'. > Caused by: > java.sql.SQLException: Java exception: ': java.lang.NullPointerException'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:88) > at org.apache.derby.impl.jdbc.Util.javaException(Util.java:245) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:403) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346) > at > org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:1573) > at > org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81) > at > org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1294) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1652) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:299) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) > at > org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:745) > at > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:538) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:739) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:797) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:801) > at > org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:218) > Caused by: java.sql.SQLException: Java exception: ': > java.lang.NullPointerException'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45) > at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:135) > at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70) > ... 29 more > Caused by: java.lang.NullPointerException > at > org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(GenericTriggerExecutor.java:217) > at > org.apache.derby.impl.sql.execute.StatementTriggerExecutor.fireTrigger(StatementTriggerExecutor.java:80) > at > org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(TriggerEventActivator.java:278) > at > org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(InsertResultSet.java:1163) > at > org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java:497) > at > org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370) > at > org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(GenericTriggerExecutor.java:173) > at > org.apache.derby.impl.sql.execute.StatementTriggerExecutor.fireTrigger(StatementTriggerExecutor.java:80) > at > org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(TriggerEventActivator.java:278) > at > org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(InsertResultSet.java:1163) > at > org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java:497) > at > org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370) > at > org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1203) > ... 22 more > FATAL 70508 [Main] (Start.java:153) - Start FAILED > org.springframework.transaction.TransactionSystemException: Could not roll > back JDBC transaction; nested exception is > java.sql.SQLNonTransientConnectionException: No current connection. > Caused by: > java.sql.SQLNonTransientConnectionException: No current connection. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:76) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:88) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:104) > at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Util.java:208) > at > org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(EmbedConnection.java:1548) > at > org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(EmbedConnection.java:1759) > at > org.apache.derby.impl.jdbc.EmbedConnection.rollback(EmbedConnection.java:1142) > at > org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265) > at > org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288) > at > org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:259) > at > org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:742) > at > org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:719) > at > org.springframework.transaction.support.TransactionTemplate.rollbackOnException(TransactionTemplate.java:160) > at > org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:138) > Caused by: java.sql.SQLException: No current connection. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45) > at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:135) > at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70) > ... 21 more > derby.log > org.apache.derby.shared.common.sanity.AssertFailure: ASSERT FAILED Invalid > method java.lang.Integer >> void <init>(short) because > java.lang.NoSuchMethodException: java.lang.Integer.<init>(short) > at > org.apache.derby.shared.common.sanity.SanityManager.THROWASSERT(SanityManager.java:162) > at > org.apache.derby.shared.common.sanity.SanityManager.THROWASSERT(SanityManager.java:147) > at > org.apache.derby.impl.services.bytecode.d_BCValidate.checkMethod(d_BCValidate.java:190) > at > org.apache.derby.impl.services.bytecode.BCMethod.callMethod(BCMethod.java:745) > at > org.apache.derby.impl.services.bytecode.BCMethod.pushNewComplete(BCMethod.java:779) > at > org.apache.derby.impl.sql.compile.StaticMethodCallNode.generateExpression(StaticMethodCallNode.java:995) > at > org.apache.derby.impl.sql.compile.JavaToSQLValueNode.generateExpression(JavaToSQLValueNode.java:167) > at > org.apache.derby.impl.sql.compile.BinaryOperatorNode.generateExpression(BinaryOperatorNode.java:599) > at > org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.generateExpression(BinaryLogicalOperatorNode.java:157) > at > org.apache.derby.impl.sql.compile.ProjectRestrictNode.generateMinion(ProjectRestrictNode.java:1484) > at > org.apache.derby.impl.sql.compile.ProjectRestrictNode.generate(ProjectRestrictNode.java:1302) > at > org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1579) > at > org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555) > at > org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479) > at > org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577) > at > org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555) > at > org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479) > at > org.apache.derby.impl.sql.compile.ProjectRestrictNode.generateMinion(ProjectRestrictNode.java:1440) > at > org.apache.derby.impl.sql.compile.ProjectRestrictNode.generate(ProjectRestrictNode.java:1302) > at > org.apache.derby.impl.sql.compile.ScrollInsensitiveResultSetNode.generate(ScrollInsensitiveResultSetNode.java:109) > at > org.apache.derby.impl.sql.compile.CursorNode.generate(CursorNode.java:564) > at > org.apache.derby.impl.sql.compile.StatementNode.generate(StatementNode.java:347) > at > org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:447) > at > org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88) > at > org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:746) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:129) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(EmbedPreparedStatement40.java:40) > at > org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Driver40.java:105) > at > org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:923) > at > org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:751) > [our trigger stored proc java code] > at > org.apache.derby.exe.ac12564092x0117xc525x43e4xffffbce342b018.g0(Unknown > Source) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.apache.derby.impl.services.reflect.ReflectMethod.invoke(ReflectMethod.java:46) > at > org.apache.derby.impl.sql.execute.CallStatementResultSet.open(CallStatementResultSet.java:74) > at > org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370) > at > org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(GenericTriggerExecutor.java:173) > at > org.apache.derby.impl.sql.execute.StatementTriggerExecutor.fireTrigger(StatementTriggerExecutor.java:80) > at > org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(TriggerEventActivator.java:278) > at > org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(InsertResultSet.java:1163) > at > org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java:497) > at > org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370) > at > org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(GenericTriggerExecutor.java:173) > at > org.apache.derby.impl.sql.execute.StatementTriggerExecutor.fireTrigger(StatementTriggerExecutor.java:80) > at > org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(TriggerEventActivator.java:278) > at > org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(InsertResultSet.java:1163) > at > org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java:497) > at > org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370) > at > org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1203) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1652) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:299) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) > at > org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:745) > at > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:538) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:739) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:797) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:801) > at > org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:218) > > Cleanup action completed > 2008-01-29 10:44:58.980 GMT Thread[Main,5,main] Cleanup action starting > java.lang.NullPointerException > at > org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(GenericTriggerExecutor.java:217) > at > org.apache.derby.impl.sql.execute.StatementTriggerExecutor.fireTrigger(StatementTriggerExecutor.java:80) > at > org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(TriggerEventActivator.java:278) > at > org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(InsertResultSet.java:1163) > at > org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java:497) > at > org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370) > at > org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(GenericTriggerExecutor.java:173) > at > org.apache.derby.impl.sql.execute.StatementTriggerExecutor.fireTrigger(StatementTriggerExecutor.java:80) > at > org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(TriggerEventActivator.java:278) > at > org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(InsertResultSet.java:1163) > at > org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java:497) > at > org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370) > at > org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1203) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1652) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:299) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) > at > org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:745) > at > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:538) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:739) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:797) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:801) > at > org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:218) > 2008-01-29 10:44:58.987 GMT Thread[Main,5,main] Equally severe exception > raised during cleanup (ignored) null > java.lang.NullPointerException > at > org.apache.derby.impl.sql.compile.CompilerContextImpl.initRequiredPriv(CompilerContextImpl.java:698) > at > org.apache.derby.impl.sql.compile.CompilerContextImpl.resetContext(CompilerContextImpl.java:158) > at > org.apache.derby.impl.sql.compile.CompilerContextImpl.cleanupOnError(CompilerContextImpl.java:107) > at > org.apache.derby.iapi.services.context.ContextManager.cleanupOnError(ContextManager.java:327) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.cleanupOnError(TransactionResourceImpl.java:419) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:337) > at > org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:1573) > at > org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81) > at > org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1294) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1652) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:299) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) > at > org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:745) > at > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:538) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:739) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:797) > at > org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:801) > at > org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:218) > > Cleanup action completed -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.