Hi Bill,
Thanks very much for your reply.
In my original problem I had created a "procedure file" (a file with static methods I only needed to call, but didn't need to subclass) and made common methods like "AddUser()", "GetUserInfo()", etc.
These methods *all* had private (local) variables for the ResultSet return sets (I also tried to create ResultSets in JSPs but had similar problems), but I was still getting the
Tomcat errors that the "current operation is invalid after the ResultSet is closed".
I made the same methods, the ones with local variables, synchronized, and these errors went away.
Can you explain what might have been going on?
Thanks very much in advance.
-- Mike