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

bzexe

BZEXE(1)						      General Commands Manual							  BZEXE(1)

NAME

       bzexe - compress executable files in place

SYNOPSIS

       bzexe [ name ...  ]

DESCRIPTION

       The  bzexe  utility  allows you to compress executables in place and have them automatically uncompress and execute when you run them (at a
       penalty in performance).  For example if you execute ``bzexe /bin/cat'' it will create the following two files:
	   -r-xr-xr-x  1 root  bin   9644 Feb 11 11:16 /bin/cat
	   -r-xr-xr-x  1 bin   bin  24576 Nov 23 13:21 /bin/cat~
       /bin/cat~ is the original file and /bin/cat is the self-uncompressing executable file.  You can remove /bin/cat~ once  you  are	sure  that
       /bin/cat works properly.

       This utility is most useful on systems with very small disks.

OPTIONS

       -d     Decompress the given executables instead of compressing them.

SEE ALSO

       bzip2(1), znew(1), zmore(1), zcmp(1), zforce(1)

CAVEATS

       The  compressed	executable  is a shell script. This may create some security holes. In particular, the compressed executable relies on the
       PATH environment variable to find gzip and some other utilities (tail, chmod, ln, sleep).

BUGS

       bzexe attempts to retain the original file attributes on the compressed executable, but you may have to fix them manually  in  some  cases,
       using chmod or chown.

																	  BZEXE(1)