Database ResultSet being shared by different users

I developed a JSP based web app on Tomcat 4.1 that connects to a SQL Server 2000 database. When one user is using the system it works fine, but when a second user accesses the same data on a table.. it seems the second user takes the result set from the first user and displays both (while the first user is left with a blank screen).

I don't think I am using Connection Pooling.. is this a problem?

Could it be a programming issue?

Any help would be appreciated.

Thanks

[503 byte] By [holidaych1881a] at [2007-11-27 5:24:28]
# 1
Could be a programming issue. That sort of thing happens quite easily if you use instance variables (instead of local variables) in your servlets, for example.
DrClapa at 2007-7-12 11:50:39 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
Thanks for your help. Indeed, it was a programming issue. It wasn't that the second user was taking the ResultSet so much as it was the query was being doubled, therefore the result looked was doubled.
holidaych1881a at 2007-7-12 11:50:39 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...