Hi,
I have a
java program in that am connecting oracle database and inserting more records then reading some files again updating the database. Since keep on interacting with DB.
Connection seems very expensive time.
Am planning to reuse the same connection. Opening a connection and keep on inserting records then committing the connection object then reading some file again inserting in DB and committing. While terminating the program am closing the connection (In Between am simply committing without closing the connection).
The program will run more than 15 hrs a day.
This is a good design any suggestions please