Win a copy of JDBC Workbook this week in the JDBC and Relational Databases forum
or A Day in Code in the A Day in Code forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

Insert into database with Java

 
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As part of eliminating the need to run the sql scripts manually in order to update existing database, im going to develop a system 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!
 
author
Posts: 4173
29
jQuery Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why not write something in JDBC that solves the problem? Writing a program that auto-loads scripts doesn't really eliminate the need for them. You can just have a cron job doing that. To answer your question though, MySQL has some special formats it accepts for bulk loading a file. Please go into more detail about what you are concerned about.
 
Your buns are mine! But you can have this tiny ad:
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic