What is the best way to connect a daba base from a desktop swing aplication
I have a java deskopt application which has to connect to a oracle(10g) data base for make some transacctions such as find, insert,delete, update and others batch processes. What i want is to minimize the time that this aplication has to connect to the data base. The number of users is about 50. Some of the users are going to connect to this application via VPN(Virtual Private Network), others with LAN.
Do i have to use a singleton class conection with JDBC as usually? ,or a connection pool manager?