I have a couple of sql-scripts, such as creating new users, creating tables, etc., which I want to load automatically by the use of a Maven plugin. Therefore, I'm searching for a manner to pass an sql script file as a stream to the Oracle JDBC-driver. Unfortunately, I cannot find such a method in the documentation.

Is there someone who knows if there is a method to load sql scripts and execute it with the Oracle JDBC driver?

Regards,

Jeroen

Here is something that might be of interest to you:

http://forum.java.sun.com/thread.jspa?threadID=636980

Other options include:

1) Maven SQL Plugin http://mojo.codehaus.org/sql-maven-plugin/

2) Writing your scripts wrapped in begin...end statements and then using Java IO to open the file and send in the string (similar to the post above)

Does any of that help?