• Post Reply Bookmark Topic Watch Topic
  • New Topic

Update the same table from different applications  RSS feed

 
Taleb Elm
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have two separate applications who will access the same table in a database and the two application will update the table.
How can I make sure the integrity of accessing this table? Is it in the code or in the database level?
 
Roger Sterling
Ranch Hand
Posts: 426
Eclipse IDE Fedora Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Database. http://en.wikipedia.org/wiki/Record_locking
 
Taleb Elm
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks for the fast comment. Does it mean I have to communicate with database admin and no need to change any code in the applications?
 
Roger Sterling
Ranch Hand
Posts: 426
Eclipse IDE Fedora Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Taleb Elm wrote:thanks for the fast comment. Does it mean I have to communicate with database admin and no need to change any code in the applications?


No, most databases have this feature built-in. Oracle, DB2, SQLServer, et al.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!