running sql script file from java

[Sanjeev Kaushik]

Hi Guys,
Can a sql script file be run from the java application?
Please share.
Regards,

[Jeanne Boyarsky]

Not in JDBC. If your database happens to be running on the same machine as the Java application, you can run the script using Runtime.exec().

[Sanjeev Kaushik]

No sql script does not run on command prompt. We can run this in sql editor or some sql tool like Toad.
syntax is like this
@myscript
Where myscript.sql is a file which contains some sqls.
Like we can execute sql queries and stored procedures from Java, can we run these scripts file also.
I think my question would be more clear now.

[Jeanne Boyarsky]

What database are you using? Many database provide a way to run scripts (list of SQL commands) from the command line. I know it is possible in Oracle, db2 and mySql.
I stand by what I said before: you cannot run the script through JDBC.

[SJ Adnams]

well you can send anonymous pl/sql in jdbc. have you tried opening the file and sending the contents as a callablestatement?