If it is something that you do on a regular basis you may want to check if you can satisfy your requirements with some PL/SQL code on the DB server that you can then access via JDBC.
What does this have to do with web services?
Joined: May 01, 2007
>>What does this have to do with web services?
I am using JDBC to execute queries...but i need to run sqlplus command to run script if some condition is satisfied and same for sqllodder. This code is in the thread and is working fine for same machine. Need to execute it on another machine where oracle is installed.
Oracle client is necessary on the mchine from where we are executing this command on Oracle server? Is there any other way?
From command prompt i am able to run sqlplus on Oracle server. (Oracle client is installed on this machine) Same command I am not able to run from the code.
Can you give me code. which can show how to connect to that machine. (Rightnow I have given access of bin directory of oracle to client machine) is it fine?? I am not satisfied with this solution.. How to give permission to that particular tomcat user??
[ December 16, 2007: Message edited by: shah isha ] [ December 17, 2007: Message edited by: shah isha ]
Joined: Aug 19, 2005
If you don�t have Oracle client on the server that runs the Tomcat servlet container then you can try and do the same thing on the DB server with a PL/SQL / Java Stored Procedure combination (which could be invoked by JDBC as a stored procedure) provided the scripts reside on the DB server (if they don't you can use PL/SQL with the utl_file package to help create the scripts on the DB server).