File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
Bookmark "run sql file using JDBC" Watch "run sql file using JDBC" New topic
Author

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
Sheriff

Joined: Oct 13, 2005
Posts: 36508
    
  16
Have you been through the Java™ Tutorials? That is a good section.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: run sql file using JDBC
 
Similar Threads
Convertion of xml file to sql file.
Invoking SQL Loader from Java
Terminated Insert.
please need help on sql
running sql script file from java