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

