| Author |
Is it possible to directly run SQL Script file using JDBC
|
suresh charan
Greenhorn
Joined: Jun 15, 2006
Posts: 8
|
|
Hi,
Is there anyway I can run .sql script file(which is present in my
application) directly using JDBC API on to Oracle Database
without manually running the sql file in SQL * Plus tool.Is there any method available in JDBC so that I just give my .sql file as input and it takes care of executing it provided I give information of the database where it should run.
|
 |
Srikanth Basa
Ranch Hand
Joined: Jun 06, 2005
Posts: 241
|
|
Check this thread
[ February 06, 2007: Message edited by: Srikanth Basavaraju ]
|
|
Srikanth Basa
Ranch Hand
Joined: Jun 06, 2005
Posts: 241
|
|
I doubt if you are able to access the link.
Here is the solution
Runtime.getRuntime().exec( "sqlplus <<username>>/<<password>>@db @<<sql file name>>" );
|
|
 |
|
|
subject: Is it possible to directly run SQL Script file using JDBC
|
|
|
0
