Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 13402 invoked from network); 14 May 2007 17:23:47 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 14 May 2007 17:23:47 -0000 Received: (qmail 43201 invoked by uid 500); 14 May 2007 17:23:44 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 43166 invoked by uid 500); 14 May 2007 17:23:43 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 43136 invoked by uid 99); 14 May 2007 17:23:43 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 May 2007 10:23:43 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 May 2007 10:23:36 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 90CBB71406A for ; Mon, 14 May 2007 10:23:16 -0700 (PDT) Message-ID: <11173259.1179163396589.JavaMail.jira@brutus> Date: Mon, 14 May 2007 10:23:16 -0700 (PDT) From: "Myrna van Lunteren (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Resolved: (DERBY-2545) testModifiesSql(org.apache.derbyTesting.functionTests.tests.lang.ProcedureInTriggerTest)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<3800[0]> but was:<3800[1]> In-Reply-To: <2768949.1176439455292.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-2545?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Myrna van Lunteren resolved DERBY-2545. --------------------------------------- Resolution: Fixed Fix Version/s: 10.3.0.0 > testModifiesSql(org.apache.derbyTesting.functionTests.tests.lang.ProcedureInTriggerTest)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<3800[0]> but was:<3800[1]> > ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-2545 > URL: https://issues.apache.org/jira/browse/DERBY-2545 > Project: Derby > Issue Type: Bug > Components: Regression Test Failure > Affects Versions: 10.3.0.0 > Reporter: Mike Matrigali > Assigned To: Myrna van Lunteren > Fix For: 10.3.0.0 > > > In the tinderbox run the following test seems to have been failing ever since this run: > http://dbtg.thresher.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/527746-org.apache.derbyTesting.functionTests.suites.All_diff.txt > Error from that file: > 3) testModifiesSql(org.apache.derbyTesting.functionTests.tests.lang.ProcedureInTriggerTest)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<3800[0]> but was:<3800[1]> > at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:523) > at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:585) > at org.apache.derbyTesting.functionTests.tests.lang.ProcedureInTriggerTest.testModifiesSql(ProcedureInTriggerTest.java:235) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88) > at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) > at junit.extensions.TestSetup$1.protect(TestSetup.java:21) > at junit.extensions.TestSetup.run(TestSetup.java:25) > Caused by: java.sql.SQLException: The external routine is not allowed to execute SQL statements. > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derbyTesting.functionTests.tests.lang.ProcedureInTriggerTest.testModifiesSql(ProcedureInTriggerTest.java:233) > ... 28 more > Caused by: java.sql.SQLException: The external routine is not allowed to execute SQL statements. > at org.apache.derby.iapi.error.StandardException.unexpectedUserException(Unknown Source) > at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown Source) > at org.apache.derby.impl.sql.execute.CallStatementResultSet.open(Unknown Source) > at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) > at org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(Unknown Source) > at org.apache.derby.impl.sql.execute.StatementTriggerExecutor.fireTrigger(Unknown Source) > at org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(Unknown Source) > at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source) > at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) > at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.