Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
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: 46412
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!