A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Refactoring for Software Design Smells: Managing Technical Debt
this week in the
OO, Patterns, UML and Refactoring
JDBC and Relational Databases
Rows getting locked
Joined: May 26, 2004
Jul 20, 2004 03:53:00
I needed some help from you regarding Oracle 9i
I have a select clause as
Select name, age from table1 where age < 18
Now does this statement lock the table or the row or anything because there is 1 more process waiting for database access?
P1 ---------- performs the above select statement
P2 ---------- displays the table content (select * from table1)
After P1 is successfully executed and all the respective table contents are displayed the flow most go to P2, but P2 is waiting infinitely
Does anybody know what the default behavior of select statement is??
author & internet detective
Joined: May 26, 2003
Jul 20, 2004 17:42:00
When you run the statement, what kind of result set are you using? Is it an updatable one? Also, what transaction settings are you using?
I'm going to move this to
as it sounds like it could apply to more databases than just Oracle.
OCA 8 book
How To Ask Questions The Smart Way
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
Have you checked out
subject: Rows getting locked
Help with HQL statement
Update with FROM table concept
Whizlabs Practice exam 1, question 10 (EJB QL)
Marcus Green - Exam 2 - Question 9
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015