oracle或mysql或SQLSERVER或POSTGRESQL用DriverManager设置数据库连接超时

最新推荐文章于 2022-11-28 21:20:32 发布

置顶 itAcmen

最新推荐文章于 2022-11-28 21:20:32 发布

阅读量1.7k

点赞数

分类专栏： jdbc 数据库文章标签： jdbc 数据库 mysql sql postgresql

本文链接：https://blog.csdn.net/itacmen/article/details/109627855

版权

jdbc 同时被 2 个专栏收录

1 篇文章 0 订阅

订阅专栏

数据库

1 篇文章 0 订阅

订阅专栏

Oracle用Properties 方式：参数oracle.net.CONNECT_TIMEOUT,单位ms

 Properties props = new Properties();
 props.put("oracle.net.CONNECT_TIMEOUT","5000");
 Connection  connection = DriverManager.getConnection(url, props);

MYSQL用url方式:参数是connectTimeout,单位是ms

jdbc:mysql://" + serviceIp + ":" + serviceProt +
                            "/" + serviceName + "?serverTimezone=GMT%2B8&useUnicode="
                            		+ "true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull" +
                            "&connectTimeout=5000

Connection connection = DriverManager.getConnection(url, userName,PassWord);

SQLSERVER用url方式loginTimeout,单位是s

jdbc:sqlserver://" + serviceIp + ":" + serviceProt + ";DatabaseName=" + serviceName+
                    ";loginTimeout=5
                    
Connection connection = DriverManager.getConnection(url, userName, PassWord);

POSTGRESQL用url方式connectTimeout，单位是s

jdbc:postgresql://" + serviceIp + ":" + serviceProt + "/" + serviceName+"?connectTimeout=5
Connection connection = DriverManager.getConnection(url, userName, PassWord);