how to implement sql server connection pooling in java jdbc?

Question

I tried to search for this but it seems the answer might now be true anymore. How can do connection pooling in java with sql server? I found the new jdbc driver of microsoft but there's no sample code to show to use it.

You should try [C3P0](http://www.mchange.com/projects/c3p0/) or [Apache DBCP](https://commons.apache.org/proper/commons-dbcp/). Both pages have examples of usage. — Eugene, Mar 09 '17 at 01:20

score 1 · Answer 1 · answered Mar 21 '17 at 21:03

1

Microsoft MSSQL-JDBC is now open sourced. You can see test cases used Hikari & Apache DBCP connection pool.

One can see PoolingTest.java and methods testApacheDBCP and testHikariCP.

For HikariCP and DBCP

answered Mar 21 '17 at 21:03

Nikhil

570
5
12

@My Intek: I think you might able to configure connection pool. – Nikhil Apr 05 '17 at 20:39

how to implement sql server connection pooling in java jdbc?

1 Answers1