I am writing
java code that accesses (selects and inserts ) data into different tables.
For each table should I open a different connection?
All the transactions are either simple selects (with joins) or inserts, where data from different table are picked up and then inserted.
I think new connections are not required, but currently in the code I have, which was already written by someone else, it is done that way.
For different sets of tables, different connections are open. I dont understand the logic behind that, can someone tell me what is the correct way to work with
jdbc connections?
Thank you!