can i execute sql script directly by java?

[Sylven Yip]

hi everyone.
now I have a sql script file generate by MySQL.
is it necessary to read the sql script file(*.sql) by I/O and analyse by my program and then execute them?
thanks for help~

[Jeanne Boyarsky]

Sylven,
No. You can use Runtime.exec and have it run the sql script at a command line. This is the same as using your database's command line tool to run a script.

[Mladen Grabowsky]

You could use iBatis' ScriptRunner, it was made for that purpose: http://ibatis.apache.org/docs/java/user/com/ibatis/common/jdbc/ScriptRunner.html

[Sylven Yip]

thanks!

[Anil Bansal]

Hi All,
I also wanted to execute an sql script through java but had one more requirement. I wanted to ensure that the password that i am using to connect to the database as well as the arguments to the script are not visible through ps commands.
Can you suggest me a way in which i can redirect the password as well as the arguments through a file using java.
something like:
runtime.exec(sqlplus system@db @some.sql <tmp)
where tmp is the temporary file and has the password to connect to the db as well as the arguments required by the sql file.
This is not working in java through runtime command but the same kind of thing works in a shell script.

Is there any other better way of achieving the same.

Thanks,
Anil

[Jan Cumps]

Hi Anil,
can you start a new topic?
This one is 2 years old.

[Ulf Dittmer]

No need to start a new topic; it already exists: executing an sql through java