Is there other ways to do insert/update/delete on a remote oracle database?

Posted by gunbuster363 on Programmers See other posts from Programmers or by gunbuster363
Published on 2011-02-08T04:30:53Z Indexed on 2011/02/08 7:32 UTC
Read the original article Hit count: 223

Filed under:
|
|
|

I asked a question recently concerning the speed of execution of insert/update/delete using JDBC driver in a remote machine, but the problem cannot be solved easily.

I would like to ask, is there any other way to execute the insert/update/delete to the oracle? The current situation is this: the DB is on a seperate machine than the java program used to update the DB. I looked up the internet and found people suggesting using pure sql or pl/sql to do the update, is that possible? And do we need to operate the sql or pl/sql in a local machine? Because I have no knowledge about pl/sql, so I am not sure if we can create some kind of script and call it on a remote machine.

Let say the situation is like this: the input data is on machine A, and the original java program are also on machine A, but the oracle is on machine B. is there any other approach other than JDBC?

© Programmers or respective owner

Related posts about java

Related posts about database