如何为Monetdb使用连接池？ [英] How to use connection pooling for Monetdb?

问题描述

有人可以告诉我如何在MonetDb中使用连接池吗？我是否只是将这些参数附加到URL poolminimum = 1; poolmaximum = 5;？

Can some tell me how to use connection pooling with MonetDb? Do I just append these args to the URL "poolminimum=1;poolmaximum=5;"?

推荐答案

驱动程序不建立连接池。您可以使用c3p0（ http://www.mchange.com/projects/c3p0/ ）为MonetDB JDBC连接创建连接池。但是，请注意，MonetDB使用开放式并发控制和表级锁定，因此从多个连接触发单个表上的更新会增加事务中止的风险。为了阅读，应该没问题。

No, by itself, the driver does not pool connections. You could use c3p0 (http://www.mchange.com/projects/c3p0/) to create a connection pool for MonetDB JDBC connections. However, please be aware that MonetDB uses optimistic concurrency control and table-level locking, so firing updates at a single table from multiple connections will have an increasing risk of transaction aborts. For reading however, this should be fine.

这篇关于如何为Monetdb使用连接池？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！