Implementing Queue for data to be inserted in the database

Question

We are developing a vehicle tracking system in which several GPS devices keep sending their GPS locations to the server using TCP connection. The TCP communicator decodes the GPS location and inserts that data into the database. Right now, one thread of TCP communicator serves one device request. After decoding the GPS data, it creates a connection to the database and inserts the data and releases the connection. As number of devices are increasing, the number of concurrent connections to the database (which is MySQL) are also increasing. Hence, I want to implement a queue where each thread of TCP communicator will push the data to one end and one job will take data from other end and keep it inserting into the database.

Can anybody suggest me the best solution to handle all this? Our application is based on Java and database is MySQL.

Thanks, Saurabh

Answer 1

You can use a thread-safe queue implementation like ConcurrentLinkedQueue to queue the data