Hi all,
I am working with
JSP on JavaWebServer /Unix / Oracle9i background.
I have to analyse the performance of the website that uses JSPs and Bean.
The present structure is as follows.
->The Bean is having Connection pool to manage 100 connections.
->It also has a method to take a 'procedure name' as input and return the RESULTSET (object).
->All JSPs
-get connection from pool
-cal gc.
-call the above method, casts the RESULTSEt and using the resultset to display the data.
-return connection to pool
-call gc.
Now wht the problem is when 10s of our branches are updating the data on our website,
atleast once in a day JavaWebServer goes down!!!
We checked for the memory leakage but i think there is no problem with it as in the beggining of the JSP and at the end of JSP
Java's free memory is the same ...
So wht i can think is the other way of using Bean and JSP that is,
Instead of getting RESULTSET Object from bean we can have M*N matrix of
String type which we can directly use in JSPs...
(Return the data only not the resultset object, getting my point no?)
**** Will this idea make the performance better or this is the problem of JavaWebServer...
PLEASE correct me if i m wrong somewhere!
And let me know yr views too... this will help me to start the journey again... i m new in the organization...
Thanks to all,
Sejal