SQL Exception blocks everyone .... why

[Philip Pross]

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]

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]

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 ???