分布式环境下的串行化控制

项目背景：
分布式应用服务器，单点数据库

思路：
在数据库上做控制，保证事务串行化控制
给请求的资源分配一个唯一的锁，竞争到锁的线程开始执行业务
通过把请求锁的SQL写成SP，在代码执行的开始处调用

SP：
create or replace
PACKAGE BODY UTIL_LOCK IS

PROCEDURE request_lock(v_lockname in VARCHAR2, p_retval OUT INTEGER, p_lockhandle OUT VARCHAR2) IS
v_lockhandle LONG;
BEGIN
DBMS_LOCK.allocate_unique(v_lockname, v_lockhandle);
p_retval := dbms_lock.request(v_lockhandle,dbms_lock.x_mode,30000);
p_lockhandle :=v_lockhandle;
END request_lock;
------------------------------------------------------------
PROCEDURE release_lock(p_lockhandle IN VARCHAR2) IS
p_out NUMBER;
BEGIN
p_out := dbms_lock.release(p_lockhandle);
END release_lock;
------------------------------------------------------------
END UTIL_LOCK;

JAVA代码：
private boolean lock(Connection conn, String resource)
{
CallableStatement cs;
try
{
String lStrSP = "{call UTIL_LOCK.request_lock(?,?,?)}";
cs = conn.prepareCall(lStrSP);
cs.setString(1, resource);
cs.registerOutParameter(2, OracleTypes.NUMBER);
cs.registerOutParameter(3, OracleTypes.VARCHAR);
cs.execute();
int ret = cs.getInt(2);
this.handle = cs.getString(3);
cs.close();
return ret == 0;
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
}
调用：
if(lockutil.lock(conn,"resource")){
//place your code here
...
lockutil.release();
}