2011/2012年Java JDBC连接池库的选择? [英] Java JDBC connection pool library choice in 2011/2012?

问题描述

我应该将哪个 JDBC 连接池库用于新的应用程序项目(而不是 Web 应用程序)?

Which JDBC connection pool library should I use for a new application project (not web application)?

• Apache DBCP 具有 足够多的未解决的问题，我认为这些问题被推到了 2.0.
• C3P0 开发似乎已停止.
• 而且它们都看起来相对较慢.
• Proxool 已死.
• DBPool 几乎没有社区(至少我没有找到公共社区 - 没有论坛，没有邮件列表...)
• Apache Tomcat Pool 在没有 Tomcat 的情况下似乎无法使用
• 我在 Oracle 网站上找到了 SQL 数据源 文章，但似乎，它只能应用于在 servlet 和 Web 服务等容器中运行的小应用程序.

• Apache DBCP has enough unresolved issues which are pushed until 2.0 I think.
• C3P0 development seems to be stopped.
• And both of them looks relatively slow.
• Proxool is dead.
• DBPool has almost no community (at least I've found no public one - no forums, no mailing lists...)
• Apache Tomcat Pool looks to be unusable without Tomcat
• I've found SQL Datasources article at Oracle website, but it seems, that it can be applied only to applets running in containers like servlets and web services.

我应该选择BoneCP吗?我没有什么太大的要求.我只需要一个良好且易于使用的数据库连接池，它正在积极开发中.库，其作者可以回复错误报告，回答一些特定问题等.

Should I choose BoneCP may be? I don't have any huge requirements. I just need a good and easy to use database connection pool, that is in active development. Library, whose author can respond to bug reports, answer some specific question etc.

顺便说一句，实际上，我只使用 MySQL.我发现，那个 MySQL 驱动程序 支持 DriverManager 接口，但我不确定它是否真的池连接.

BTW, actually, I'm using MySQL only. I've found, that MySQL driver supports DriverManager interface, but I'm unsure if it actually pools connections or not.

推荐答案

你已经做了很好的研究.我会说，继续使用 BoneCP.几年前我会建议 c3p0，但它目前一些未解决和未解决的问题 也是.太糟糕了，实际上.顺便说一下，BoneCP 作者也很活跃这里在 SO.

You've done good research. I'd say, go ahead with BoneCP. Some years ago I would have suggested c3p0, but it has currently some open and unresolved issues as well. Too bad, actually. The BoneCP author is by the way also active here at SO.

这篇关于2011/2012年Java JDBC连接池库的选择?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！