• 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 ???
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic