dcsimg
How to run .sql file using JDBC ?
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Arvind_Thube
Posted On:   Friday, November 23, 2001 12:19 AM

I have a set of sql statements (say 50 statements).

Instead of executing them in a loop I wrote them in a .sql file.

In sqlplus we can directly execute the .sql file using @sqlfilenam.sql.

Re: How to run .sql file using JDBC ?

Posted By:   Satyajit_Paul  
Posted On:   Friday, November 23, 2001 01:01 AM

So far as I know @somefile_name.sql is a SQL Plus environment command. Its not a pure SQL command. You can execute only pure SQL command through JDBC api. Here in your case I think u need to use loop , prepared statement kind of thing. If it is not correct pls let me know.
About | Sitemap | Contact