List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 18 2002 7:07am
Subject:Re: Executing the "source c:/Test.sql" command
View as plain text  
At 22:45 -0800 12/17/02, Amit Lonkar wrote:
>Hi All!
>
>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
interface.

>
>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";
>execute(String sql)
>executeQuery(String sql)
>executeUpdate(String sql)
>
>Thanks
>Amit Lonkar

Thread
Executing the "source c:/Test.sql" commandAmit Lonkar18 Dec
  • Re: Executing the "source c:/Test.sql" commandPaul DuBois18 Dec
    • Accessing last_insert_id problem.Jeff Snoxell18 Dec
      • re: Accessing last_insert_id problem.Victoria Reznichenko18 Dec
        • re: Accessing last_insert_id problem.Jeff Snoxell18 Dec
          • re: Accessing last_insert_id problem.Wico de Leeuw18 Dec
          • Re: Accessing last_insert_id problem.Michael T. Babcock18 Dec
          • re: Accessing last_insert_id problem.Paul DuBois18 Dec
            • re: Accessing last_insert_id problem.Jeff Snoxell19 Dec
              • re: Accessing last_insert_id problem.Wico de Leeuw19 Dec
            • thread_cache . what is it ? (no newbie question) .cristian ditoiu20 Dec
              • Re: thread_cache . what is it ? (no newbie question) .Benjamin Pflugmann20 Dec
      • Re: Accessing last_insert_id problem.Paul DuBois18 Dec
      • Re: Accessing last_insert_id problem.Matthew Smith2 Jan
        • Using Perl DBI quote() method with NULL values?Jeff Snoxell7 Jan
          • Re: Using Perl DBI quote() method with NULL values?Paul DuBois7 Jan
          • Re: Using Perl DBI quote() method with NULL values?Keith C. Ivey8 Jan
      • Re: Using Perl DBI quote() method with NULL values?walt7 Jan
      • Re: Using Perl DBI quote() method with NULL values?Rodney Broom8 Jan
      • Re: Using Perl DBI quote() method with NULL values?Salam Baker Shanawa8 Jan
  • Re: Accessing last_insert_id problem.Harald Fuchs18 Dec
Re: Accessing last_insert_id problem.Jeff Snoxell19 Dec
  • Re: Accessing last_insert_id problem.Paul DuBois19 Dec
  • RE: Accessing last_insert_id problem.Will Merrell20 Dec
    • Badly placed ()'s and also access deniedGary Hostetler20 Dec
      • RE: Badly placed ()'s and also access deniedJennifer Goodie20 Dec
        • Re: Badly placed ()'s and also access deniedGary Hostetler20 Dec