04-27-2009
Running Oracle SqlPlus with Java in Kshells
Hello,
This may not be the right place to ask for help for this problem but i might be because i'm using Java & SqlPlus in alot of Kshell scripts.
Just to give a high level picture, i'm basically using Java to control each SqlPlus execute command, by reading a flat file that contains the run values from previous steps and then in lets say the current step, check the values from previous steps to see for example if step3 = step1 + step2 ect.
The Java program will compare the previous step rules and then execute the SqlPlus, query to output from the SqlPlus and make a new Java entry.
But what is happening is in the Oracle Session Log it is creating and not deleting 10s upon 10s of seession entries and when i look at some of them they say they are Java executables.
So do you think this is a Java problem and if so is there a way to somehow delete the session immediately after the step runs so that the session thread disappears?
Thanks for any insights and even quesses at this point!
Fyi it's really only a problem now that system has been moved to a very heavily used instance and now everyone is seeing alot more sessions being created other than their own and not sure why the system is grinding to a halt.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi guys,
I am facing issues while triggering sqlplus with "/" option
I can connect to database with USER ID and password. but, if i just specify "/" option since it is "externally identiifed user" it doesn't work
Any suggestions?
mail me @ Removed.
Regards, Giri (2 Replies)
Discussion started by: chittari
2 Replies
2. UNIX for Advanced & Expert Users
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... (0 Replies)
Discussion started by: anooptech
0 Replies
3. UNIX and Linux Applications
Hi,
I want to use sqlplus from server1
sqlplus usr1/pass1@dns1
and I want to connect to an Oracle database from a server2.
Unfortunately the database was created on the server1 and on server2.
So when I use the command just like that...it connects to the database from the server2. ... (2 Replies)
Discussion started by: AngelMady
2 Replies
4. Shell Programming and Scripting
a job extracts orcle data into unix as flat file.
a single record breaks into two record in unix flat file. This is the case only for 6 records out of 60 lack records.
(its not single record in two line. but its single record into record. ie., \n come into picture)
can you tell me what... (6 Replies)
Discussion started by: Gopal_Engg
6 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following:
1. Connect to oracle database hosted on a different server
2. fire a query on the oracle db
3. store the output in a variable
4. use this variable for further logic... (1 Reply)
Discussion started by: shrutihardas
1 Replies
6. Shell Programming and Scripting
Hi,
I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following:
1. Connect to oracle database hosted on a different server
2. fire a query on the oracle db
3. store the output in a variable
4. use this variable for further logic... (26 Replies)
Discussion started by: shrutihardas
26 Replies
7. Shell Programming and Scripting
I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'.
What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies
8. Shell Programming and Scripting
Hi all,
on AIX 6.1 I want to run the following but for 5 DB. How should I do that ? Using FOR, WHILE ???? How ?
export ORACLE_SID=DB1
sqlplus / as sysdba << EOF
whenever sqlerror exit sql.sqlcode;
whenever oserror exit FAILURE
set define off
set head off
set feedback off
set echo off... (1 Reply)
Discussion started by: big123456
1 Replies
9. Fedora
Hi All,
I have just downloaded fedora 27 iso and set it up in virtual box.
I want to learn Hadoop so trying to install Apache hadoop. Before all those I have to install Oracle Java 1.7.15 (as mentioned in the Apache hadoop page).
Can you please help me how to Uninstall currently installed... (6 Replies)
Discussion started by: TechGyaann
6 Replies
LEARN ABOUT DEBIAN
jython.conf
JYTHON.CONF(5) File Formats Manual JYTHON.CONF(5)
NAME
jython.conf - Jython registry for system-wide options
DESCRIPTION
When running jython(1) or jythonc(1), a number of properties may be set to customise Jython's behaviour. Properties can be assigned values
in any of the following four ways. This list is arranged from lowest to highest priority; thus for instance a property set in a user's
personal registry will override the same property set in the system-wide registry.
Java system properties
Jython options may be set in the standard Java system properties. However, since the jython and jythonc startup scripts take
responsibility for starting the Java interpreter, it is unlikely that you will use this method of Jython configuration.
Jython system-wide registry
The system-wide registry is the file /etc/jython/jython.conf. It contains a number of lines of the form property=value. Lines that
are empty or that begin with a hash (#) are ignored.
User's personal registry
The user's personal registry is the file ~/.jython. Its format is the same as for the system-wide registry.
Command-line options
Properties may be specified when running jython or jythonc at the command-line. They are set using command-line options of the form
-Dproperty=value.
PROPERTIES
The following properties may be set in the Jython registry. Other less used properties are also available; see the comments in the default
system-wide registry for further details.
If a property is marked (auto), the jython and jythonc startup scripts will attempt to set this property automatically, although it can
still be overridden in the system or user registry or on the command-line.
python.cachedir (auto)
The directory to use for caches (currently just package information). This directory must be writable by the user. If the direc-
tory is an absolute path then it is used as given; otherwise it is interpreted as relative to the root Jython directory
(/usr/share/jython/).
python.console
The name of the console class to use when running Jython from the command prompt. An alternative console class that emulates GNU
readline can be specified using this property.
python.jythonc.classpath (auto)
Extensions to the Java property java.class.path for use with jythonc. This is used to put extra classes on your Java compiler's
classpath (and the core Java classes as well if your Java compiler requires them).
python.jythonc.compiler (auto)
The Java compiler to use with jythonc when turning generated Java code into Java class files. This should be the absolute path to a
Java compiler, or the name of a compiler on your standard PATH.
python.jythonc.compileropts
Options to pass to the Java compiler when using jythonc.
python.path (auto)
The path on which Jython will look for additional python modules when importing. This variable has a similar function to CPython's
PYTHONPATH environment variable.
python.security.respectJavaAccessibility
Normally, Jython can only provide access to public members of classes. However if this property is set to false and you are using
Java 1.2 then Jython can access non-public fields, methods and constructors.
python.verbose
Sets the verbosity level for informative messages. All messages with at least the specified severity will be displayed. Valid val-
ues in order of increasing verbosity are error, warning, message, comment and debug.
SEE ALSO
jython(1), jythonc(1).
If the Debian package jython-doc is installed, full documentation from the Jython authors will be available in /usr/share/doc/jython-
doc/html/.
AUTHOR
This manual page was prepared by Ben Burton <bab@debian.org> for the Debian GNU/Linux system (but may be used by others). It is based upon
the official Jython documentation.
September 2, 2001 JYTHON.CONF(5)