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 Directly run SQL Script file using JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Directly run SQL Script file using JDBC" Watch "Directly run SQL Script file using JDBC" New topic
Author

Directly run SQL Script file using JDBC

L Goundalkar
Ranch Hand

Joined: Jul 05, 2001
Posts: 395
Hi,

Is there anyway I can run .sql script file ( which is present in my application directory ) directly using JDBC API on to Oracle Database without manually running the sql file in SQL * Plus tool.

Cheers.


<b>L G Goundalkar</b><br /> <a href="mailto:lggoundalkar@yahoo.com" rel="nofollow">lggoundalkar@yahoo.com</a> <br />Sun Certified Programmer for Java 2 Platform.<br />Sun Certified Web Component Developer for J2EE.
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1121

Hi LG,
Did you not search the other posts in this forum?
Did you not see this one:
http://www.coderanch.com/t/298527/JDBC/java/executing-PL-SQL-through-JDBC
Does it not help you?
Good Luck,
Avi.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Directly run SQL Script file using JDBC
 
Similar Threads
Is it possible to directly run SQL Script file using JDBC
Run .sql file using JDBC or any java API
Restore problem
SqlPlus question
Execute .sql file using java