[ 
https://issues.apache.org/jira/browse/OPENJPA-878?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Donald Woods updated OPENJPA-878:
---------------------------------

    Attachment: OpenJPA-878-db2.zip

Code to setup DB2 for setQueryTimeout testing with TestQueryTimeout.java junit 
code.
First, create a DB called OPENJPA and make sure you have uid=db2admin setup.
Then, run DelaySetup.bat (which uses uid=db2admin) to create the jar with the 
delay() function, register the jar in DB2 and create a Delay function on the 
OPENJPA db.
I've been testing this with DB2 v9.5 on Windows, but it should work for 9.1 and 
v8.

> Support default query hint for query timeout
> --------------------------------------------
>
>                 Key: OPENJPA-878
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-878
>             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-878-20090305-draft.patch, 
> OPENJPA-878-20090306.patch, OPENJPA-878-20090310-eclipse.patch, 
> OPENJPA-878-20090310.patch, OPENJPA-878-20090311-eclipse.patch, 
> OPENJPA-878-20090311.patch, OPENJPA-878-20090311.patch, 
> OPENJPA-878-20090312-minimal.patch, OPENJPA-878-20090313.patch, 
> OpenJPA-878-db2.zip, OPENJPA-878-DBDictionary.patch, 
> OPENJPA-878-docs-20090311.patch, OPENJPA-878-serialVersionUID.patch, 
> OPENJPA-878-TestQueryTimeout.patch
>
>
> Support default query hint for query timeout as defined in section 3.6.4 of 
> the spec.
> A new hint can be supplied for Java SE and Java EE environments -
>     javax.persistence.query.timeout // query timeout in seconds
> Can be used in the following:
>     Methods - Query.setHint()
>     Annotations (via QueryHint) - NamedQuery, NativeNamedQuery 
>     Properties - Persistence.createEntityManagerFactory, persistence.xml
> The following methods can return a javax.persistence.QueryTimeoutException: 
> getResultList(), getSingleResult(), executeUpdate().
> If a QTE is thrown, the current transaction (if active) should not be marked 
> for rollback.
> If the DB query timeout causes a rollback, then a PersistenceException should 
> be thrown instead (see 3.6.1).

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to