Would anyone happen to know if there's a java API for executing entire ".sql" files (containing several different SQL commands), on a remote database server ?
It's enough if the API works with MySQL and/or Oracle.
Just to demonstrate what i'm looking for: Suppose you've created sql file "c:/test.sql" with several script lines: -- test.sql: insert into TABLE1 values(3,3); insert into TABLE1 values(5,5); create table TABLE2 (name VARCHER) ENGINE innoDB; -- MYSQL specific
Then the java API should look something like: // Dummy java code: String driver="com.mysql.jdbc.Driver"; String url= "jdbc:mysql://localhost:3306/myDb"; SomeAPI.executeScriptFile( "c:/test.sql", driver, url);
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Java API for executing sql scripts (mysql / oracle) ?