Skip to content

FAQ

Jump to bottom
wenshao edited this page Nov 12, 2012 · 26 revisions

Welcome everyone to use Druid, FAQ answers here, we want to help.

1. What is Druid?

Druid is the best in the java language database connection pool. Druid to provide a powerful monitoring and extended functionality.

2. Where to download?

3. how to get the source code

Driud is an open source project, hosting on github, source code repository: https://github.com/AlibabaTech/druid

4. maven config

since 0.1.18, druid deploy to maven central repository, so you only need to add the dependency to the pom.xml, such as:

	<dependency>
		<groupId>com.alibaba</groupId>
		<artifactId>druid</artifactId>
		<version>${druid-version}</version>
	</dependency>

5. how to use Druid's monitoring feature?

Druid monitoring feature is implementation by filter-chain, if you want turn on, config StatFilter, look here : https://github.com/AlibabaTech/druid/wiki/%E9%85%8D%E7%BD%AE_StatFilter

6. how to use Druid buit-in monitoring page

built-in monitoring page is a Servlet, configuration see here : https://github.com/AlibabaTech/druid/wiki/%E9%85%8D%E7%BD%AE_StatViewServlet%E9%85%8D%E7%BD%AE

7. how to configure Web and Spring related monitoring？

8. how to configure the defense against SQL injection attacks

Druid provides WallFilter, it is based on the SQL semantic analysis to defense SQL injection attacks, see here : http://code.alibabatech.com/wiki/display/Druid/WallFilterConfig

9. DruidDataSource reference configuration

different needs of different business scenarios, you can use our reference configuration, but it recommended that you carefully read the documentation to understand clearly do custom configuration.

https://github.com/AlibabaTech/druid/wiki/%E9%85%8D%E7%BD%AE_DruidDataSource%E5%8F%82%E8%80%83%E9%85%8D%E7%BD%AE

10. I would like to logging SQL execution, how to config?

Druid provides Log4jFilter/CommonsLogFilter/Slf4jFilter, see here : https://github.com/AlibabaTech/druid/wiki/%E9%85%8D%E7%BD%AE_LogFilter

11. my program may be have connection leaks, how to do?

Druid offers a variety of means to monitoring connection leaks, see here : https://github.com/AlibabaTech/druid/wiki/%E8%BF%9E%E6%8E%A5%E6%B3%84%E6%BC%8F%E7%9B%91%E6%B5%8B

12. Solve the problem of excessive memory footprint Oracle PSCache

Connect to an Oracle database, other connection pool will exist the problem of excessive memory usage, Druid is the only connection pool to solve this problem. see here : http://code.alibabatech.com/wiki/pages/viewpage.action?pageId=6951277

13. Druid and other connection pool comparison?

14. what to pay attention to migration from other connection pool?

15. Similar Jboss DataSource ExceptionSorter in Druid

ExceptionSorter is one of the outstanding features of JBoss DataSource, Druid has the same funtion of ExceptionSorter, but do not have to manually configure it take effect automatically. see here : http://code.alibabatech.com/wiki/display/Druid/ExceptionSorter

16. why maxIdle properties is useless?

the maxIdle property for Druid compatible with DBCP, maxIdle is a confusing concept. the connection pool should only maxPoolSize and minPoolSize，druid retain only maxActive and minIdle, respectively the equivalent maxPoolSize and minPoolSize.

17. To use DruidDataSource in JNDI?

DruidDataSource support JNDI, see here : http://code.alibabatech.com/wiki/pages/viewpage.action?pageId=2916633
具体实现的类是这个：com.alibaba.druid.pool.DruidDataSourceFactory，你可以阅读代码加深理解。

18. 我的应用已使用DBCP，是代码中写死的，怎样更换为Druid？

可以的，Druid提供了一个中完全平滑迁移DBCP的办法。

这种用法，使得可以在一些非自己开发的应用中使用Druid，例如在sonar中部署druid，sonar是一个使用jruby开发的web应用，写死了DBCP，只能够通过这种方法来更换。

19. 我想试用快照版本，怎么获取？

直接获取快照版本的地址是：http://code.alibabatech.com/mvn/snapshots/com/alibaba/druid/ ，使用快照版本建议加入我们QQ群 92748305，遇到问题直接反馈给我们。

20. 有一些SQL执行很慢，我希望日志记录下来，怎么设置？

在StatFilter配置中有慢SQL执行日志记录，看这里 https://github.com/AlibabaTech/druid/wiki/%E9%85%8D%E7%BD%AE_StatFilter

21. 我希望加密我的数据库密码怎么吧

运维和DBA都不希望把密码明文直接写在配置文件中，Druid提供了数据库秘密加密的功能。具体看这里：https://github.com/AlibabaTech/druid/wiki/%E4%BD%BF%E7%94%A8ConfigFilter

22. 如何参与Druid的开发

Druid是一个通过github开源的项目，github的特性，使得你很容易参与其中。这里有详细说明 https://github.com/AlibabaTech/druid/wiki/%E5%A6%82%E4%BD%95%E5%8F%82%E4%B8%8E

Clone this wiki locally