[
https://issues.apache.org/jira/browse/OPENJPA-964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12700295#action_12700295
]
Donald Woods commented on OPENJPA-964:
--------------------------------------
Example query timeout for Informix running the junit tests -
23784 TRACE [main] openjpa.jdbc.SQL - <t 3079897, conn 8779065> [7050 ms]
spent
34562 test TRACE [main] Tests - testQueryTimeout31c() - Caught expected
Exception =
<openjpa-2.0.0-SNAPSHOT-r422266:766044M nonfatal store error>
org.apache.openjpa.persistence.QueryTimeoutException: A query statement timeout
has occurred.
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4379)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4335)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
at
org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeUpdate(SQLStoreQuery.java:176)
> Finish updating sql-error-state- codes.xml for query timeout support on other
> DBs
> ---------------------------------------------------------------------------------
>
> Key: OPENJPA-964
> URL: https://issues.apache.org/jira/browse/OPENJPA-964
> Project: OpenJPA
> Issue Type: Sub-task
> Components: query
> Affects Versions: 2.0.0
> Reporter: Donald Woods
> Assignee: Donald Woods
> Fix For: 2.0.0
>
> Attachments: OPENJPA-964-common.patch, OPENJPA-964-db2.patch,
> OPENJPA-964-mssql.patch, OPENJPA-964-oracle.patch
>
>
> Need to add any SQLStatus codes for query timeouts to sql-error-state-
> codes.xml and handle setting isRecoverable/isFatal in each DBDictionary
> subclass for other supported DBs besides Derby and DB2.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
