How to Execute SQL Script File in Java?

by

There is great way of executing SQL scripts from Java without reading them yourself as long as you don’t mind having a dependency on Ant. In my opinion such a dependency is very well justified in your case. Here is sample code, where SQLExec class lives in ant.jar:

private void executeSql(String sqlFilePath) {
    final class SqlExecuter extends SQLExec {
        public SqlExecuter() {
            Project project = new Project();
            project.init();
            setProject(project);
            setTaskType("sql");
            setTaskName("sql");
        }
    }

    SqlExecuter executer = new SqlExecuter();
    executer.setSrc(new File(sqlFilePath));
    executer.setDriver(args.getDriver());
    executer.setPassword(args.getPwd());
    executer.setUserid(args.getUser());
    executer.setUrl(args.getUrl());
    executer.execute();
}

More Related Contents:

  1. How to return an array with one element larger? [duplicate]
  2. Firestore whereEqualTo, orderBy and limit(1) not working
  3. Why must local variables, including primitives, always be initialized in Java?
  4. Android load from URL to Bitmap
  5. Sizes of frame icons used in Swing
  6. how to add unicode in truetype0font on pdfbox 2.0.0?
  7. JUnit 4 Test Suites
  8. Why can’t a Generic Type Parameter have a lower bound in Java?
  9. The ResourceConfig instance does not contain any root resource classes
  10. Calling Win32 API method from Java
  11. Using superclass to initialise a subclass object java [duplicate]
  12. Eclipse autocomplete (content assist) with facelets (jsf) and xhtml
  13. How to modify a Collection while iterating using for-each loop without ConcurrentModificationException? [duplicate]
  14. File truncate operation in Java
  15. TaskSchedulerImpl: Initial job has not accepted any resources;
  16. JMenu ActionListener
  17. Is it possible to use VectorDrawable in Buttons and TextViews using android:DrawableRight?
  18. Convert a String of Hex into ASCII in Java
  19. Use of readConfiguration method in logging activities
  20. Behavior of static blocks with inheritance
  21. How to query a web service via POST request in Android?
  22. Problems with Firestore connections executing threads
  23. Java GC (Allocation Failure)
  24. What’s the difference between requires and requires static in module declaration
  25. When may we need to use runOnUiThread in android application?
  26. What are annotations and how do they actually work for frameworks like Spring?
  27. How to convert jar to OSGi bundle using eclipse and bndtools
  28. Command failed: gradlew.bat installDebug
  29. MouseListener Help Java
  30. I need to launch a JFrame from another JFrame and have that run like independent applications, help?

Leave a Comment