I would like to know when to close pooled connection if my application is running all the time to update Oracle database?
I have a Java application that receives messages from the clients all the time. Each message is a thread and each thread will open a db connection and update the Oracle database. Since regular db connection is expensive. I use Datasouce and pooled connection. When each thread is completed, I close the connection. I leave the pooled connection open. This method causes the memory usage very high; worse than using regular connection (open/close connection). Any suggestions about when to close pooled connection are appreciate.