Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Attach .sql file to jdbc connection? any APIs?

Attach .sql file to jdbc connection? any APIs?

From: May Nine <may94111_at_yahoo.com>
Date: 31 May 2003 15:21:25 -0700
Message-ID: <275a5824.0305311421.43c945de@posting.google.com>


Hi,

Suppose my java program establishes a jdbc connection to an Oracle 9.2 DB using the oracle jdbc driver.

What is the easiest way to pull a .sql file in from the file system and try to run the commands resident within it?

I'm sure I could brute-force my way through this problem but before I do that, I'd like to know if any APIs exist which do some dirty work for me.

-May Nine Received on Sat May 31 2003 - 17:21:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US