openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Albert Lee (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OPENJPA-957) Support lock timeout hint on applicable methods
Date Wed, 11 Mar 2009 23:00:50 GMT

    [ 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.


Mime
View raw message