[jira] [Commented] (DBCP-559) 数据库连接可以通过BasicDataSource类的close()方法进行关闭，但该类没有提供open()方法使得新建的数据库连接生效

["Mark Thomas (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DBCP-559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16993453#comment-16993453 ] 

Mark Thomas commented on DBCP-559:
----------------------------------

Google translate version of the description:

 The current open source software has the function: If the database connection is closed (that is, closed is set to true), the service must be restarted for the new database connection to take effect (closed set to false).

For disaster recovery scenarios, if the database connection string changes, in order for the new database connection to take effect dynamically (hot effect), you do not need to manually restart the service. It is recommended that the open source software BasicDataSource class provide an open () method for setting closed = false; For the established database connection to take effect.

See the attached code for the change.

Note: The attachment is optimized based on the version 2.7.0 code.

 

 

> 数据库连接可以通过BasicDataSource类的close()方法进行关闭，但该类没有提供open()方法使得新建的数据库连接生效
> -------------------------------------------------------------------
>
>                 Key: DBCP-559
>                 URL: https://issues.apache.org/jira/browse/DBCP-559
>             Project: Commons DBCP
>          Issue Type: Improvement
>    Affects Versions: 2.7.1
>            Reporter: Wenzhi Ji
>            Priority: Major
>              Labels: ready-to-commit
>             Fix For: 2.7.1
>
>         Attachments: BasicDataSource.java, BasicDataSourceMXBean.java
>
>   Original Estimate: 1h
>  Remaining Estimate: 1h
>
> 当前该开源软件具备的功能：若数据库连接被关闭（即closed置为true），则必须重启服务，才能使新的数据库连接生效（closed置为false）。
> 针对容灾场景，若数据库连接串发生变化，为了使新的数据库连接动态生效（热生效），不需要手工重启服务，建议该开源软件BasicDataSource类提供一个open()方法用于置closed = false；以使建立的数据库连接生效。
> 变更的代码见附件。
> 注：附件是基于2.7.0版本代码进行优化的。



--
This message was sent by Atlassian Jira
(v8.3.4#803005)