This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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
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: 43935
    
  33
Have you been through the Java™ Tutorials? That is a good section.
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: run sql file using JDBC
 
It's not a secret anymore!