Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Dirty read problem?  RSS feed

 
Shashidhar Yarabati
Ranch Hand
Posts: 175
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi guy's

I got one interesting problem like this.
1. Logged in as User1
2. Logged in as User2 same time in different machine
3. inserted one record from User1
4. User2 is not able to see the inserted record with out logging out.

But I have to make the inserted record can able to see anybody without forcing them to logging out. Is this durty read problem???

Please give solution if any body of you faced this or know how to resolve this.




(Iam really sorry guy's for positing query multiple locations. It is bit of confussion to post in exact forum. Here is the fresh query again)
 
Joe Ess
Bartender
Posts: 9406
12
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As Nicholas pointed out in your previous thread, you need to Tell the Details.
You obviously need some mechanism to propagate data changes between users. Not knowing what kind of application we are dealing with severely hinders our ability to give you suggestions.
 
Shashidhar Yarabati
Ranch Hand
Posts: 175
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Joe!

Well Iam running application on Windows systems. And iam using oracle10g.
Is my problem realated with Database?
Iam having package like this: com.shashi.mypack
please help me to sove this problem


Thanks for your prompt reply Joe,

And Thanks in advance...
 
Joe Ess
Bartender
Posts: 9406
12
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, that's some information. But it does not shed any light on your problem.
What is your application? Swing? JSP/Servlets? Console?
How are you getting data to your app? JDBC? Hibernate? EJB's?
What is the architecture of your app? Client-server? Thick client? Web service?
What would we need to know to sit down and help you code?
 
Stan James
(instanceof Sidekick)
Ranch Hand
Posts: 8791
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I can't guess what logging out does to reset a users ability to see something. The database won't force that for sure. Can you just get user 2 to repeat his query and see the new record?
 
Shashidhar Yarabati
Ranch Hand
Posts: 175
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Here is some more information.
My application is on Swings.
And Iam getting data trough DAO's and JDBC
then coming to architecture it is Webservice.

If any thing more need please let give message. I will give but help me to solve this issue.
 
Joe Ess
Bartender
Posts: 9406
12
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
So you have a swing front end, web service middle and a JDBC back end.
Now you state that User1 adds a record. User2 does not see that record.
What mechanism do you have to refresh User2's view of the database? Do you do a fresh query of the database?
If you do a fresh query of the database from User2 and the record is not returned, go to your SQLPlus window and query the table. Is the record there?
Do you have any caching going on in your web service or JDBC code?
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!