What is a good JDBC Connection Pool Framework for insert into Mysql Database
I am writing a Java application, the high level overview of this
application is listening for restful events and when these events come in,
it will be inserted into the Mysql database.
I am using executor service to handle the event processing and perform
other logics, such as insert into db. For the insert into the db side, I
am using a dao pattern (with JDBI). These events can be coming in at
around 3000 per minute.
Currently I am not utilizing any JDBC Connection Pool control. I am simply
passing a data source in the dbi constructor to get a connection and once
an insert is performed, close the connection. This is working in my local
dev environment, but definitely won't handle the requirement needed when
it is deployed.
I do not know much about working with JDBC Connection pool and controls,
and am wondering can some please suggest some good JDBC Connection Control
framework, point me to some articles to read more about it, or any other
suggestion in handling this situation?
Thanks.
No comments:
Post a Comment