• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Rows getting locked

 
Dinesh Sundrani
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Friends
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?

Scenario
P1 ---------- performs the above select statement
P2 ---------- displays the table content (select * from table1)

Error
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??
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35274
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dinesh,
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 JDBC as it sounds like it could apply to more databases than just Oracle.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic