File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes run sql file using JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "run sql file using JDBC" Watch "run sql file using JDBC" New topic

run sql file using JDBC

Tusshar Fasate
Ranch Hand

Joined: May 21, 2008
Posts: 81
I have one sql file which contains number of sql commands like create table,inserting data into table ,select queries like.
i want to run this file on sql server and i should get output of this file also.
How can i do this?
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 45251
Have you been through the Java™ Tutorials? That is a good section.
I agree. Here's the link:
subject: run sql file using JDBC
It's not a secret anymore!