java程序执行命令行，解锁数据库表

有些表锁的时间长或其他原因，在plsql中不能解锁，只能用命令行解锁。

有些功能跨平台系统的交互偶尔会锁表，就需要自动解锁。

下面是解锁的代码：

package com.lg.BreakOracleUtils;

import com.lg.DB.DBProjp;
import com.lg.database.DbManager;
import com.lg.database.DbsConnection;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

public class BreakOracleLock
{
  private static final Log logger = LogFactory.getLog(BreakOracleLock.class);

  public static void breakOracleLock() { logger.info("解锁xx表定时程序已经启动了！");

    DbsConnection connect = null;
    try
    {
      DBProjp db = new DBProjp();

      DbManager dbm = new DbManager();
      connect = dbm.getConnection(db.url, db.userName, db.passWord);

      String sql = "select b.username, b.sid, b.serial#, logon_time, spid, c.object_name\n  from v$locked_object a, v$session b, v$process p, all_objects c\n "+
　　　　　　　　" where a.session_id = b.sid\n   and b.paddr = p.addr\n   and a.object_id = c.object_id\n   and (c.object_name like '表名%' or c.object_name like '表名%' )\n  "
　　　　　　　　+" and b.username in ('数据库名' , '数据库名') \n  and logon_time<=(sysdate-30/24/60)\n order by b.logon_time";
///设置锁表时间30分钟，即表的锁定时间小于当前时间30外，具体表的具体业务分析锁表的时间，自己设定
/
      List list = connect.select(sql);
      if ((list != null) && (list.size() > 0)) {
        Map m = (Map)list.get(0);
        String spid = (String)m.get("spid");
        String cmdStr = "orakill orcl " + spid;
        logger.info("解锁xx表执行命令：" + cmdStr + ",表名：" + m.get("object_name"));
        Process localProcess = Runtime.getRuntime().exec(cmdStr);
      }
      connect.release();
    } catch (Exception e) {
      logger.info("解锁xx表定时程序失败！" + e.getMessage());
      try {
        if (connect != null)
          connect.release();
      }
      catch (SQLException e1) {
        e1.printStackTrace();
      }
      e.printStackTrace();
    }

    logger.info("解锁xx表定时程序结束！");
  }
}

　　

转载于:https://www.cnblogs.com/tianye-7/p/8084830.html