I have previously posted this topic in the JDBC section, but not sure whether it's appropriate, so think i might as well post it here, hopefuly can get more comments.
As part of eliminating the need to run the sql scripts manually in order to update existing database, im going to develop a functionality which can take the scripts from certain classes, and run the scripts from there, sometimes the amount of sql scripts may get huge, and im concerning the performace regarding this action. So i need some consultation, help, guidelines from javaranch forum here before i start off with this. What are some of the major things that need to be taken into consideration when it comes to this? And if halfway running the script certain issues occur, what measures have to take. Your help is very much appreciated!