posted 20 years ago
Hi,
I have one more question.. I am Using the Oracle 9i thin driver and developing JSP pages using Oracle HTTP server.
In every JSP page, I am including another jsp page (DBConn.jsp) which registers the oracle driver and opens the Connection.
After processing the oracle queries, I am closing all resultsets, statements and finally the connection object.
So, in every page - registering the driver, opening the connection, query processing, closing all objects - is taking place.
The maximum no. of users to the application at any time is not greater than 50. So far the same mechanism is used while 15 users are accessing the system. Will there be any problem, if I continue using this approach if the users are increased in the future? or I have to use some kind of connection pooling mechanism ?
Which is the better approach ?