Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

SQL Exception blocks everyone .... why

 
Philip Pross
Ranch Hand
Posts: 76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello to all,
I have an some question towards SQL exception in JDBC, when there is an error trying to recieve infomation from a database it stops all access for everyone log on at the same time.
For example, if I try to insert a string in a field that doesn't exist or insert a string where an I should use an int, an sql excption will be throw, and it blocks there (for everyone). I'm using a connection pool for the connection to my database in each one of my servlets that also
"implements SingleThreadModel" .
Could it be because of the SingleThreadModel, or has it to do with the connection pool ???
All help is welcomed
Thanks ..... Phil
 
Bosun Bello
Ranch Hand
Posts: 1511
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
By implementing SingleThreadModel interafce you are making sure there will not be simultaneous access to teh DB. I will assume that is one of your problems right there.
 
Philip Pross
Ranch Hand
Posts: 76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the reply Bosun, so from what you are saying is if there is one exeption in one servlet the others should work ..... but I just came to search for something and there was a general error on the servlet side, and for continuing with another servlet it blocked ???
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!