Hi All:
I have a three tier application and the servlet acts as the middle
tier
between the user and the database. All of servlets extends database methods
from the class that provides database services (open, close...) The first
called servlet open the conecttion with the DB, and the classes called from
the first one, take profit of this, because is the same connection for all
that extends this class. With this configuration, if two user are at the same time using the program,
between the user and the database. All of servlets extends database methods
from the class that provides database services (open, close...) The first
called servlet open the conecttion with the DB, and the classes called from
the first one, take profit of this, because is the same connection for all
that extends this class. With this configuration, if two user are at the same time using the program,
the first user close when finish, the connection to the second
user.
I have solved the problem with two or more users, because now the connection
is not closed while there are almost one user using it. (user++ with
Open_DB, and user-- with Close_DB). But now the problem is that i have only
one connection, and I think that the system is going slowly that with one
connection for each user.
Any suggestion??
Di
I have solved the problem with two or more users, because now the connection
is not closed while there are almost one user using it. (user++ with
Open_DB, and user-- with Close_DB). But now the problem is that i have only
one connection, and I think that the system is going slowly that with one
connection for each user.
Any suggestion??
Di
