A way to execute multiple queries from an SQL script file?

[_SAS]

Hello.
I've got a SQL file with multiple queries in it. Is there any way to execute them all? Maybe there is a library which can do that?

[doWhile]

Hello.
I've got a SQL file with multiple queries in it. Is there any way to execute them all? Maybe there is a library which can do that?

Read the file and pass them all through a Statement/PreparedStatement

[_SAS]

As far as I know, you cannot put multiple queries into one Statement. I could execute them one by one, but in order to do so I have to parse my SQL file. But it is too complex a task since my file contains creation of pl/sql functions. I simply don't know how to break it into individual queries without writing a complex SQL parser.

[Tolls]

Why not simply hand the sql file to the database directly?
Most DBs have a front end for doing bulk SQL.

[_SAS]

For some unknown reason I can't communicate with psql process. I start the process, and nothing happens. I can't read its output and I can't pass the data to it. So I thought that using some library would be the right way to do the thing.

[Tolls]

This sort of thing is almost invariably better done using whatever tools the DB provides you with.
Not knowing your database I can't say what tool, but if you need to call it via Java then you'll want to use Runtime.exec(), but beware of the pitfalls and ensure you read up on how it works.