[
https://issues.apache.org/jira/browse/OPENJPA-957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12681077#action_12681077
]
Albert Lee commented on OPENJPA-957:
------------------------------------
FYI... I find the following in the Derby reference.
http://db.apache.org/derby/docs/10.1/ref/refderby.pdf
SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY
Use the SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY system procedure to set or
delete the value of a property of the database on the current connection. If
"VALUE" is not null, then the property with key value "KEY" is set to "VALUE".
If "VALUE" is null, then the property with key value "KEY" is deleted from the
database property set.
Syntax
SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY(IN KEY VARCHAR(128),IN VALUE
VARCHAR(32672))
This procedure does not return any results.
JDBC example
Set the derby.locks.deadlockTimeout property to a value of 10:
CallableStatement cs = conn.prepareCall
("CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?, ?)");
cs.setString(1, "derby.locks.deadlockTimeout");
cs.setString(2, "10");
cs.execute();
cs.close();
SQL example
Set the derby.locks.deadlockTimeout property to a value of 10:
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY
('derby.locks.deadlockTimeout', '10');
java.sql.Statement
Derby does not implement the following JDBC 1.2 methods of java.sql.Statement:
• cancel
• setEscapeProcessing
• setQueryTimeout
> Support lock timeout hint on applicable methods
> -----------------------------------------------
>
> Key: OPENJPA-957
> URL: https://issues.apache.org/jira/browse/OPENJPA-957
> Project: OpenJPA
> Issue Type: Sub-task
> Components: jpa
> Affects Versions: 2.0.0
> Reporter: Jeremy Bauer
>
> This task is to provide support for the lock timeout hint on applicable
> interface methods. OpenJPA currently supports the openjpa.LockTimeout
> property. This support will be extended to allow more granular configuration
> at the method level, where applicable. The pattern used for specifying lock
> modes at a method level should be considered for extension or as a guide.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
