Search...
FAQs Subscribe
Pie
FAQs
Recent topics Flagged topics Hot topics Best topics
Search...
Search within JDBC and Relational Databases Search Coderanch
Advance search Google search
Register / Login
granny advertise on coderanch polymorphism book review grid thread boost
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
meaningless drivel thread boost book review grid advertise on coderanch building better world book
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

is there any condition that a connection stop until another connection commit?

 
raminaa niilian
Ranch Hand
Posts: 551
posted 16 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Hi
Thank you for reading my post
is there any scenario that a JDBC connection block (suspend) in its operation (for example a select) until another connection finishes its transaction?

Thanks.
 
Jan Cumps
Bartender
Posts: 2661
19
I like...
Netbeans IDE C++ Linux
posted 16 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Yes, you might encounter a database lock. This can block you.
Regards, Jan

OCUP UML fundamental and ITIL foundation

 
raminaa niilian
Ranch Hand
Posts: 551
posted 16 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
can you please explain when we may face a lock which can block a connection?

thanks
 
Jan Cumps
Bartender
Posts: 2661
19
I like...
Netbeans IDE C++ Linux
posted 16 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
One possible scenario is described here.
Regards, Jan

OCUP UML fundamental and ITIL foundation

 
Jan Cumps
Bartender
Posts: 2661
19
I like...
Netbeans IDE C++ Linux
posted 16 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Oracle has published a document comparing their Oracle 10g database with IBM's DB2 database. Locking and blocking is one of the main topics there.
See section Transaction Processing.

Regards, Jan

OCUP UML fundamental and ITIL foundation

 
Don't sweat petty things, or pet sweaty things. But cuddle this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
reply
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!
Similar Threads
More...