[OPENJPA-2658] TestQueryTimeout test is broken

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4.1
• Fix Version/s: 3.0.0
• Component/s: jdbc
• Assignee: Mark Struberg
• Reporter: Mark Struberg
• Created: 21/Aug/16 13:06
• Updated: 22/Aug/16 13:51
• Resolved: 22/Aug/16 13:51

Description

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)