Bookmark Topic Watch Topic
  • New Topic

Execute SQL Scripts with Java  RSS feed

 
Cloey Tan
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Report post to moderator
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!
 
Martijn Verburg
author
Bartender
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi Cloey,

We prefer to have OneThreadPerQuestion

Please continue in the JDBC forum (if you like you can reply to your post there and ask if it can be moved). Locking this thread.
 
Don't get me started about those stupid light bulbs.
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!