Running .sql File in java

Hi all
I have to run a a ".sql" file through java. Can anyone tell how it can be done.
Regards
Amit Lonkar

Hi,
i guess ".sql" file you are talking contains set of sql statements. Hence you can write the stored procedure in the back end and execute the same using java.
-arun

Hi
I am using Mysql. So stored procedures might not be possible.
One way i found out is, I need the command
mysql --execute="c:/test.sql" to be execute. I put this in a batch file, and ran the batch file using Runtime class.
Reagrds
Amit Lonkar