I have already developed a LAN client-server chat application in java.My server establishes connection to a mysql database using jdbc where i save client information.Now i want to know should i use Connection pooling in server for establishing connection to mysql.Can anyone tell me if i am on the right track.I actually came across this concept on internet and i thought of implementing it in my project.Can anyone just tell me if it is necessary to use connection pooling and if it can be helpful for my chat application.
As @Peter said - it is a good practice to use a connection pool when your server connected to the db server. So the answer is - "Yes it is ok and it will work but you'd better use a connection pool there".