Hi, I'm learning Java/Jsp. I just started a project to learn and have some Practical knowledge. But I'm stuck and confused Kindly suggest me so that I can proceed further.-
The Project is a Knowledge System. It stores Lots of Questions their answers which is listed by Categories. There's 2 type of user one who can have read only access on 'Question' and 'Topic' table and 2nd 'Admin' level . Its a web based application with multiuser access.
(I Know its a bit long )
1.Should I use Connection Pooling? I read that they returned back to pool after use but Result set associated with this will be lost/clear is n't it? then the sql query's result returned will be lost as well?[no idea on it]. So do I need to save record for each user some where[suggest where].
2. If a user have made query visited some link on it but again like to go on same query do I need to execute the query again or any way to hold the result for that user utill he logout. (consider the above question as Result set unused get cleared or closed )
3.Do I need to use MultiThread? What if don't and I put a query in a servlet which execute query then return it to show result in HTML.
each user call this page for all sort of their query will there be any problem occur. if yes which part should be used for Multithreading.
4 How should I divide it to get the MVC Model confirmed .
any thing else you would like to say ....