Login or Register to Ask a Question and Join Our Community


Programming

Table Locking in Insert Command.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Programming Table Locking in Insert Command.
# 1  
Old 05-13-2013
Table Locking in Insert Command.
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
Last edited by Scott; 05-13-2013 at 11:39 AM.. Reason: Crosspost. Closed
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Insert one table and update another with shellscript

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

2. Shell Programming and Scripting

Insert bulk values in DB table using isql

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

3. UNIX for Advanced & Expert Users

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... (9 Replies)
Discussion started by: senkerth
9 Replies

4. Shell Programming and Scripting

Insert script result into Oracle Table

Hi All, I want to insert STAT and ENDTIME values for each job in joblist into TBL_DAILY_STATUS table. Eg: insert into tbl_daily_status values(STAT,ENDTIME); Please help me on this. #!/bin/ksh joblist="com_abc_job com_abc_dot_job com_abc_seq com_abc_det" for i in $joblist do... (8 Replies)
Discussion started by: vichuelaa
8 Replies

5. UNIX for Dummies Questions & Answers

Bash script to insert data into an html table

hi, I need to create a bash shell script which picks up data from a text file and in the output file puts it into an html made table. I have to use sed and awk utilties to do this the input text file will contain data in the format: job name para1 para2 para3 para4 para4 1 ... (1 Reply)
Discussion started by: intern123
1 Replies

6. Web Development

INSERT data to a Database Table from a text file

If you have a text file and if you want to Insert data to your Database Table, You can do it with these queries LOAD DATA LOCAL INFILE '/path/yourTextFile.txt' INTO TABLE yourTableName FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' (0 Replies)
Discussion started by: sitex
0 Replies

7. Shell Programming and Scripting

Insert into Oracle table thru UNIX - linux 2.6.9-89

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

8. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

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

9. Shell Programming and Scripting

Insert value to ORACLE table from sqlldr log

This is the sample sqlldr log: ------------------------------------------------------------------------------------------------------------ SQL*Loader: Release 9.2.0.7.0 - Production on Sun Feb 8 23:37:02 2009 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Control... (13 Replies)
Discussion started by: aimy
13 Replies

10. Shell Programming and Scripting

need to insert two columns (or two feilds) at the begining of the table

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
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

snmp::info::layer3::cisco

Info::Layer3::Cisco(3pm)				User Contributed Perl Documentation				  Info::Layer3::Cisco(3pm)

NAME

       SNMP::Info::Layer3::Cisco - SNMP Interface to L3 and L2+L3 IOS Cisco Device that are not covered in other classes.

AUTHOR

       Max Baker

SYNOPSIS

	# Let SNMP::Info determine the correct subclass for you.
	my $cisco = new SNMP::Info(
			       AutoSpecify => 1,
			       Debug	   => 1,
			       # These arguments are passed directly to SNMP::Session
			       DestHost    => 'myswitch',
			       Community   => 'public',
			       Version	   => 2
			       )
	   or die "Can't connect to DestHost.
";

	my $class      = $cisco->class();
	print "SNMP::Info determined this device to fall under subclass : $class
";

DESCRIPTION

       Subclass for Generic Cisco Routers running IOS

   Inherited Classes
       SNMP::Info::CiscoVTP
       SNMP::Info::CDP
       SNMP::Info::CiscoStats
       SNMP::Info::CiscoImage
       SNMP::Info::CiscoRTT
       SNMP::Info::CiscoQOS
       SNMP::Info::CiscoConfig
       SNMP::Info::Power
       SNMP::Info::Layer3

   Required MIBs
       CISCO-EIGRP-MIB
       Inherited Classes' MIBs
	   See "Required MIBs" in SNMP::Info::CiscoVTP for its own MIB requirements.

	   See "Required MIBs" in SNMP::Info::CDP for its own MIB requirements.

	   See "Required MIBs" in SNMP::Info::CiscoStats for its own MIB requirements.

	   See "Required MIBs" in SNMP::Info::CiscoImage for its own MIB requirements.

	   See "Required MIBs" in SNMP::Info::CiscoRTT for its own MIB requirements.

	   See "Required MIBs" in SNMP::Info::CiscoQOS for its own MIB requirements.

	   See "Required MIBs" in SNMP::Info::CiscoConfig for its own MIB requirements.

	   See "Required MIBs" in SNMP::Info::CiscoPower for its own MIB requirements.

	   See "Required MIBs" in SNMP::Info::Layer3 for its own MIB requirements.

GLOBALS

       These are methods that return scalar value from SNMP

       $cisco->vendor()
	       Returns 'cisco'

       $cisco->eigrp_id()
	   ("cEigrpAsRouterId")

   Global Methods imported from SNMP::Info::CiscoVTP
       See documentation in "GLOBALS" in SNMP::Info::CiscoVTP for details.

   Globals imported from SNMP::Info::CDP
       See documentation in "GLOBALS" in SNMP::Info::CDP for details.

   Globals imported from SNMP::Info::CiscoStats
       See documentation in "GLOBALS" in SNMP::Info::CiscoStats for details.

   Globals imported from SNMP::Info::CiscoImage
       See documentation in "GLOBALS" in SNMP::Info::CiscoImage for details.

   Globals imported from SNMP::Info::CiscoRTT
       See documentation in "GLOBALS" in SNMP::Info::CiscoRTT for details.

   Globals imported from SNMP::Info::CiscoQOS
       See documentation in "GLOBALS" in SNMP::Info::CiscoQOS for details.

   Globals imported from SNMP::Info::CiscoConfig
       See documentation in "GLOBALS" in SNMP::Info::CiscoConfig for details.

   Globals imported from SNMP::Info::CiscoPower
       See documentation in "GLOBALS" in SNMP::Info::CiscoPower for details.

   Globals imported from SNMP::Info::Layer3
       See documentation in "GLOBALS" in SNMP::Info::Layer3 for details.

TABLE METHODS

       These are methods that return tables of information in the form of a reference to a hash.

       $cisco->eigrp_peers()
	   Returns EIGRP peer IP addresses

	   ("cEigrpPeerAddr")

       $cisco->i_vlan()
	   Returns a mapping between "ifIndex" and the PVID or default VLAN.

   Table Methods imported from SNMP::Info::CiscoVTP
       See documentation in "TABLE METHODS" in SNMP::Info::CiscoVTP for details.

   Table Methods imported from SNMP::Info::CDP
       See documentation in "TABLE METHODS" in SNMP::Info::CDP for details.

   Table Methods imported from SNMP::Info::CiscoStats
       See documentation in "TABLE METHODS" in SNMP::Info::CiscoStats for details.

   Table Methods imported from SNMP::Info::CiscoImage
       See documentation in "TABLE METHODS" in SNMP::Info::CiscoImage for details.

   Table Methods imported from SNMP::Info::CiscoRTT
       See documentation in "TABLE METHODS" in SNMP::Info::CiscoRTT for details.

   Table Methods imported from SNMP::Info::CiscoQOS
       See documentation in "TABLE METHODS" in SNMP::Info::CiscoQOS for details.

   Table Methods imported from SNMP::Info::CiscoConfig
       See documentation in "TABLE METHODS" in SNMP::Info::CiscoConfig for details.

   Table Methods imported from SNMP::Info::CiscoPower
       See documentation in "TABLE METHODS" in SNMP::Info::CiscoPower for details.

   Table Methods imported from SNMP::Info::Layer3
       See documentation in "TABLE METHODS" in SNMP::Info::Layer3 for details.

perl v5.12.4							    2011-09-28						  Info::Layer3::Cisco(3pm)