数据库的Timeout 其实有很多种情况。
一个是执行的超时时间 executionTimeOut，一个是连接的超时时间connectionTimeOut，
还有呢？ 等待的超时时间 ReadTimeout。不过很多数据库情况下connectionTimeOut 就是ReadTimeout
props.put("user", userName);
props.put("password", passSecret);
if ("oracle".equals(dbType)) {
//props.put("connectionProperties", "oracle.net.CONNECT_TIMEOUT=10000;oracle.jdbc.ReadTimeout=10000");
props.put("oracle.net.CONNECT_TIMEOUT", "10000");
props.put("oracle.jdbc.ReadTimeout", "10000");
}
String sleepsql = "declare "+
"begin "+
"sys.dbms_lock.sleep(20); "+
"dbms_output.put_line('asfasf');"+
"end;";
String sqlStr =
"select distinct tablespace_name from sys.dba_tables where owner = '"
+ dbInfo.getName().toUpperCase()
+ "' and trim(tablespace_name) is not null";
List<String> dbList = new ArrayList<String>();
PreparedStatement statement = null;
ResultSet rs = null;
try {
CallableStatement callableStatement = conn.prepareCall(sleepsql);
callableStatement.execute();
//conn.setNetworkTimeout(Executors.newCachedThreadPool(), 30000);
} catch (SQLException e) {
e.printStackTrace();
} finally {
}
开始是通过下面的，不过一直就是报错，行不通， 貌似驱动版本不够新。
conn.setNetworkTimeout(Executors.newCachedThreadPool(), 30000);
有关数据库的锁:
http://www.cnblogs.com/cqubityj/archive/2012/06/16/2551947.html
http://www.cnblogs.com/leemoby/p/3583428.html
LOCK TABLE iempeam.t_aa IN EXCLUSIVE MODE
SELECT * FROM iempeam.t_aa TABLOCKX