JDBC - Single connection vs Multiple connections
843859Jun 9 2006 — edited Jun 9 2006I am currently designing an application that consists of displaying the contents of a mysql table, modifying that data via the screen, and modifying the data via other threads running in the background. Is using one JDBC Connection object feasible? Is the Connection Object thread safe? It seems that some sort of queing would have to be enforced. But i wonder if using a pool of multiple connections is bad design for a local application. Any thoughts would be most appreciated.