how to handle SQL exceptions to call script having args via java ? Post: 302357026

Sponsored Content

Top Forums Programming how to handle SQL exceptions to call script having args via java ? Post 302357026 by crackthehit007 on Monday 28th of September 2009 12:38:28 PM

09-28-2009

Registered User

how to handle SQL exceptions to call script having args via java ?

Hi,

i want to call shell script via java + in that shell script i m doing some sql operation by connecting to sqlplus .

i want to return 0 if successful exeution of SQL operations else 1 ;

is it possible ?

Code:

#!/bin/sh
Name=$1;
export ORACLE_HOME

$ORACLE_HOME/bin/sqlplus scott@ORA/tiger <<EOF
spool /root/spool1.txt;
select * from tab where tname like '$Name%';
spool off;
EOF

echo "got query data"

exit;

java code

Code:

import java.util.*;
import java.io.*;

public class Script {
	public static void main ( String[] s)
	{
		Runtime r= Runtime.getRuntime();//reference to runtime java environment
		Process P=null;
		String cmd2 = "/root/script.sh school";
		
		try {
			P=r.exec(cmd2);
	
			System.out.println(	P.waitFor());
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (InterruptedException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

is it possible to get info whether SQL query executed properly or not ?

crackthehit007

View Public Profile for crackthehit007

Find all posts by crackthehit007

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to call pl/sql in unix script

sample code as following: test_sql(){ #test#echo test_sql str=`$ORACLE_BIN/sqlplus -s $user/$passwd <<EOM set verify off set heading off set feedback off #--------start pl/sql { DECLARE CURSOR pah_cs IS select id from table where letter = 'abcd';...

2. UNIX for Dummies Questions & Answers

how can a call shell script from pl/sql

I like to call a shell script from pl/sql proceduere and i have to use the shell script return value in that procedure. i am using oracle 9i and cygwin. can any one suggest me how can i do this

3. Shell Programming and Scripting

how can i call a shell script from pl/sql

I would like to call the shell script from pl/sql and i need to uses the value returned by the shell script in pl/sql procedure. can any one suggest me how can i do that?

4. Solaris

Java Exceptions while installing Oracle

Hello. I was trying to installe oracle 10g on solaris t0 x86 and got few exception? Could you please suggest, what might be going wrong? $ ls -l total 32 drwxr-xr-x 9 oracle dba 512 Nov 21 03:50 doc drwxr-xr-x 5 oracle dba 512 Nov 21 03:50 install drwxr-xr-x 2...

5. Solaris

How to catch and handle Makefile exceptions

I have a simple makefile which I use to sync libraries files from /source/sybase directory on the source machine where the Makefile resides to /destination/folder on the various destination machines like machine1, machine2, machine3 using solaris utility 'rsync'. So when I run "make -f makefilename...

6. Shell Programming and Scripting

How to call Java by using shell script

Hi All, I am new to shell script, just wanted you guy to help. How do i call a java program by using shell script, pls give some samle code for it, thank you ver much.

7. UNIX for Advanced & Expert Users

java Exceptions color

Hi, I call a java program from a cron job and i need to display the exceptions or Errors thrown by java(basically stacktrace) in the unix/linux console in the red color.Is it possible to do that? If so, pls. give me some pointers how to do that. eg: Exception in thread "main"...

8. UNIX for Advanced & Expert Users

call sql through shell script

Hi i am not able to connect sqlplus my script is as follows $ORACLE_HOME/bin/sqlplus << ! > /tmp/extract/DM.txt and output is SQL*Plus: Release 11.1.0.7.0 - Production on Wed Jan 18 02:53:54 2012 Copyright (c) 1982, 2008, Oracle. All rights reserved. Enter user-name: t175481...

9. UNIX for Dummies Questions & Answers

Call sql script

I want to call the sql query from UNIX..but how to set page size and other necessary parameters i don't know plz guide me how to do this

10. Shell Programming and Scripting

Getopts how to handle missing '-' in command line args.

I'm using getopts to process command line args in a Bash script. The code looks like this: while getopts ":cfmvhs:t:" option; do case $option in c) operationMode="CHECK" ;; f) operationMode="FAST" ;; m) ...

LEARN ABOUT DEBIAN

airport2-config

AIRPORT2-CONFIG(1)					      General Commands Manual						AIRPORT2-CONFIG(1)

NAME

       airport2-config - Configurator for the Apple AirPort Extreme Base Station ("Snow")

SYNOPSIS

       airport2-config

DESCRIPTION

       airport2-config allows you to manage your AirPort base station, just like the AirPort software on Mac OS X.

OPTIONS

       airport2-config	accepts  no  command-line  options. airport2-config is a wrapper script around the Airport2BaseStationConfigurator.jar jar
       file located in /usr/share/java/airport-utils.

       You can set the JAVACMD environment variable to use a specific JVM instead of the one chosen by the wrapper script. Set the DEBUG  environ-
       ment variable to 1 to get the debug output from the wrapper script.

ENVIRONMENT VARIABLES

       DEBUG  Set this variable to 1 to get the debug output from the wrapper script.

       JAVACMD
	      The  full  path  to  the	Java  Virtual  Machine	to  use.  By  default,	the  wrapper  uses JAVACMD; if it is not set, it looks for
	      JAVA_BINDIR/java, then for JAVA_HOME/bin/java before looking for a java executable in the PATH. In the latter case, the JVM used can
	      be configured using the Debian alternatives system (see update-alternatives(8)).

       JAVA_HOME
	      The full path where your JDK/JRE is installed.

       JAVA_BINDIR
	      The full path to the directory where the java executable is located.

       JAVA_ARGS
	      Extra command-line arguments to be passed to the Java Virtual Machine.

AUTHOR

       airport2-config was written by Jon Sevy <jsevy@cs.drexel.edu>.

       This manual page was written by Julien BLACHE <jblache@debian.org>, for the Debian project (but may be used by others).

								   May 20, 2006 						AIRPORT2-CONFIG(1)