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