[
https://issues.apache.org/jira/browse/OPENJPA-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15429716#comment-15429716
]
Mark Struberg commented on OPENJPA-2658:
----------------------------------------
I now simply also drop the trigger T1 before we drop the DELAY function.
Wonder how this used to work (jenkins for 2.3.x executes the test just fine).
Maybe the tests which create T1 are executed last in older junit versions.
Maybe it also has to do with the undefined method order since java7?
> TestQueryTimeout test is broken
> -------------------------------
>
> Key: OPENJPA-2658
> URL: https://issues.apache.org/jira/browse/OPENJPA-2658
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.4.1
> Reporter: Mark Struberg
> Assignee: Mark Struberg
> Fix For: 3.0.0
>
>
> TestQueryTimeout fails because it cannot create the stored procedure.
> 747 test INFO [main] openjpa.jdbc.JDBC - Connected to Apache Derby
> version 10.10 using JDBC driver Apache Derby Embedded JDBC Driver version
> 10.12.1.1 - (1704137).
> org.apache.openjpa.lib.jdbc.ReportingSQLException: Operation 'DROP ROUTINE'
> cannot be performed on object 'DELAY' because TRIGGER 'T1' is dependent on
> that object. {stmnt 1978732023 DROP FUNCTION DELAY} [code=30000, state=X0Y25]
> ...
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelStatement.execute(JDBCStoreManager.java:1711)
> at
> org.apache.openjpa.lib.jdbc.DelegatingStatement.execute(DelegatingStatement.java:122)
> at
> org.apache.openjpa.persistence.query.TestQueryTimeout.exec(TestQueryTimeout.java:1025)
> at
> org.apache.openjpa.persistence.query.TestQueryTimeout.setupCreateDBFunction(TestQueryTimeout.java:908)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
