05-13-2013
Insert Command Creating Table Locking Problem
Hi,
i have a java based tool which does insert operation in a TABLE, and in parallel the same table is used by my C++ code which does select Query.
the Table will be always busy, but sometimes the table is getting locked when i try to make an insert, am bit confused whether the lock is because of SELECT query from my C++ code or by the INSERT QUERY from the java Tool.
Do i need to modify the Query if so how..? and from the google i learnt that select puts an internal LOCK.
currently am locking the table before insert below is my query
lock table table_name in exclusive mode nowait
and giving a commit after performing the DML operation so that lock will be removed automatically.
can anyone please solve my query.?
thanks,
senthil
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi...
after unlock my computer from lock,
all telnet windows which i opened previously are closing automaticaly...
i hope u understand....plz give solution... (1 Reply)
Discussion started by: venkatramana
1 Replies
2. Shell Programming and Scripting
Hey guys/gals,
So here is what i'm starting with...its a Solaris patch diag output.
bash-3.0# pca -l
Using /var/tmp/patchdiag.xref from Oct/20/08
Host: seiftsx4140 (SunOS 5.10/Generic_127128-11/i386/i86pc)
List: missing
Patch IR CR RSB Age Synopsis
------ -- - -- --- ---... (3 Replies)
Discussion started by: zeekblack
3 Replies
3. Shell Programming and Scripting
Hi
I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.)
I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies
4. Shell Programming and Scripting
Hi,
I am trying to insert a record into a table (say dips_tbl) which resides in Oracle DB through a ksh script. I want to insert records into few of the table columns-not all. I'll give an e.g. for the date column "CREATE_DATE".
For that I first execute
SQL1="SELECT SYSDATE FROM DUAL"
... (1 Reply)
Discussion started by: dips_ag
1 Replies
5. Shell Programming and Scripting
I have a file like below
Iter 1: Best Model = 10.0 12.0 13.0 17.0 23.3 78.7
Iter 2: Best Model = 10.0 20.0 30.0 40.0 50.0 60.0
Iter 3: Best Model = 27.3 46.3 84.5 23.0 34.5 35.4
etc
I want to use a scipts using csh or awk to select the iteration number and show the numbers in a table... (2 Replies)
Discussion started by: kristinu
2 Replies
6. Shell Programming and Scripting
Hi folks
I am trying to use a call to a python command within a shell script to help validate a date. If I hard code the date to be checked in the string it works. As follows
cmd_result=$(/usr/bin/python -c 'import time; print time.strftime("%d",time.strptime("31/02/2008", "%d/%m/%Y"))'... (2 Replies)
Discussion started by: PatMcDonagh
2 Replies
7. UNIX for Dummies Questions & Answers
Hello,
I'm working with putty on Windows 7 professional and I'd like to know if there's a way to gather specific lines from a pre-existing table and make a new table with that information.
More specifically, I'd like the program to look at a specific column, say column N, and see if any of the... (5 Replies)
Discussion started by: Deedee393
5 Replies
8. Programming
Hi,
i have a java based tool which does insert operation in a TABLE, and in parallel the same table is used by my C++ code which does select Query.
the Table will be always busy, but sometimes the table is getting locked when i try to make an insert, am bit confused whether the lock is... (0 Replies)
Discussion started by: senkerth
0 Replies
9. Shell Programming and Scripting
Hello,
Objective is to insert bulk values in DB table using isql.
Following code tried:
isql -SServer_name -Ddb_name -Uuser_name -Ppassword < file.txt
cat file.txt
for i in `cat data_value_file.txt`
do
insert into tempdb..temp_table11 values ('$i')
go
done
cat... (3 Replies)
Discussion started by: manishdivs
3 Replies
10. Shell Programming and Scripting
I have a problem with my shell script. I want to insert data from file to table1(empty) and then, compare table1 with table2 and update some fields.
The first part is correct, but the second part does not work. The only way it works is if after the first part I truncate table1 and run the script... (1 Reply)
Discussion started by: nika_mill
1 Replies
LEARN ABOUT DEBIAN
html::tableparser::table
HTML::TableParser::Table(3pm) User Contributed Perl Documentation HTML::TableParser::Table(3pm)
NAME
HTML::TableParser::Table - support class for HTML::TableParser
DESCRIPTION
This class is used to keep track of information related to a table and to create the information passed back to the user callbacks. It is
in charge of marshalling the massaged header and row data to the user callbacks.
An instance is created when the controlling TableParser class finds a "<table" tag. The object is given an id based upon which table it is
to work on. Its methods are invoked from the TableParser callbacks when they run across an appropriate tag ("tr", "th", "td"). The object
is destroyed when the matching "/table" tag is found.
Since tables may be nested, multiple HTML::TableParser::Table objects may exist simultaneously. HTML::TableParser uses two pieces of
information held by this class -- ids and process. The first is an array of table ids, one element per level of table nesting. The second
is a flag indicating whether this table is being processed (i.e. it matches a requested table) or being ignored. Since HTML::TableParser
uses the ids information from an existing table to initialize a new table, it first creates an empty sentinel (place holder) table (by
calling the HTML::TableParser::Table constructor with no arguments).
The class handles missing "/tr", "/td", and "/th" tags. As such (especially when handling multi-row headers) user callbacks may be
slightly delayed (and data cached). It also handles rows with overlapping columns
LICENSE
This software is released under the GNU General Public License. You may find a copy at
http://www.fsf.org/copyleft/gpl.html
AUTHOR
Diab Jerius (djerius@cpan.org)
SEE ALSO
HTML::Parser, HTML::TableExtract.
perl v5.10.0 2007-09-21 HTML::TableParser::Table(3pm)