At 22:45 -0800 12/17/02, Amit Lonkar wrote:
>I want to execute the Mysql command "source
>c:/Test.sql" through java.
That doesn't make sense. "source" is one of the internal
commands understood by the mysql client program. It's
not a SQL statement that you can execute though the JDBC
>Which method of the statement interface should I use.
>I tried all the three below but they generate an SQL
>Exception as :-
>"You have an error in your SQL syntax near 'source
>c:/netapsv1/tempfiles/Test.sql' at line 1" :-
>String sql = "source c:/netapsv1/tempfiles/Test.sql";