• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Java Database Connections and Relational Databases - Question

 
Raghavendra Desoju
Ranch Hand
Posts: 95
2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Marco,

Welcome to Code Ranch !!

We have a Java application in which multiple threads connect to database and insert/update same set of tables concurrently.

We observe database locks sometimes when there is high processing overhead.

I am hoping in your book we could find useful information on following some best practices to avoid such database locks. And, hoping it would give us some direction in debugging the existing code which could possibly create locks?

Thank you,
Raghu
 
Marco Behler
Author
Ranch Hand
Posts: 43
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Raghu,
it is hard to tell how complex your application is and what is going on exactly. What frameworks you are using etc. What is high processing overhead? I have been working on financial systems where you can literally have hundreds (thousands or hundred thousands in bigger systems) transactions every *second*.

What I found is that often the very basic knowledge is missing regarding deadlocks etc. Work through the deadlock chapters in the book and you should have a very good understanding of what can lock and how. And it will definitely help you understand your production deadlock problems. But there are no shortcuts.

Cheers
Marco
 
Raghavendra Desoju
Ranch Hand
Posts: 95
2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Marco !!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic