executing .sql file from java program

[S Srikanth]

Hi,
I have a .sql file which consists of some DDL Commands.
I need code snippet to execute the .sql file from java?

Regds,
Srikanth

[Shailesh Chandra]

you can not execute a sql file straight to your database from jdbc.


"[email protected]"

Please look at JavaRanch Naming Policy and change you display name.As per policy a display name is first name and last name saperated by a space. you can do the same here


Shailesh

[S Srikanth]

Hi,
Is there any alternative to this?

Regds,
Srikanth

[Paul Sturrock]

You can:

Read the file in with java.io

Parse its contents - you'll probably need java.util.regex for that

Create a batch of Statements to execute via JDBC.

Sounds like a lot of work. Given this is DDL rather than DML, can't you just execute it via whatever DB client you would normally use. Far easier.

[David O'Meara]

"Srikanth",
thank you for changing your diaply name, but unfortunately we need: your first name, a space, then your last name.

Please edit your profile and correct your display name.

thanks,
Dave.