Обсуждение: Loading an SQL command file via JDBC

I have a text file that contains a bunch of SQL commands.  I need to execute
all of those commands via JDBC.  Obviously, I could read the file in, parse
it, and execute each command one at a time.  But is there a simple JDBC or
SQL command that will simplify this and automatically load an entire list of
commands?

For instance, I think the MySQL database has something like a "source"
command that might do this.

Thanks,
Tauren

Postgres has a COPY command which does what you are trying to do. If you
manage to get it to work via JDBC I would be very interested

Dave

----- Original Message -----
From: "Tauren Mills" <tauren@servlets.net>
To: <pgsql-jdbc@postgresql.org>
Sent: Thursday, June 07, 2001 4:44 AM
Subject: [JDBC] Loading an SQL command file via JDBC


> I have a text file that contains a bunch of SQL commands.  I need to
execute
> all of those commands via JDBC.  Obviously, I could read the file in,
parse
> it, and execute each command one at a time.  But is there a simple JDBC or
> SQL command that will simplify this and automatically load an entire list
of
> commands?
>
> For instance, I think the MySQL database has something like a "source"
> command that might do this.
>
> Thanks,
> Tauren
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>
>