Hi ALL,

I would like to execute one SQL query(ORACLE) in UNIX shell script. For this I used sqlplus in script and tested locally. It worked fine. But my requiremnt is to execute the script from Java. In this case the UNIX part is working but sqlplus is not returning anything
The JAVA code used is as follows:
String user="UNIX_username";
String host="138.108.222.30";
String cmd="ksh script_name.sh";
try
{
Session session=jsch.getSession(user,host,22);
session.setPassword("password");
UserInfo usrInfo=new MyUserInfo();
session.setUserInfo(usrInfo);
session.connect();
Channel channel=session.openChannel("exec");
((ChannelExec) channel).setCommand(cmd);
channel.setXForwarding(true);
channel.connect();


Could anyone of you give some ideas on the above ?

Thanks,
ANoo