Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Persistance using hibernate,JPA,JDO..etc - Need Suggestions.

 
abhishek paul
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have a requirement in my project where once the user logs in, the database is queried and some information related to the user is retrieved and stored in JVM.So the number of hits to the database is decreased.

The requirement in detail :

This is Simple Cart-Shopping application.
There is a UI which displays various products which one can view and purchase.

1)Once the user logs in he can view the various products.
2)There are restriction which decides which products that particular user can purchase,although a user can view all the products listed in the store.
3)Every time a user clicks on a product, database is queried to retrieve access info for the user on that product.
4)If a user has proper access only then he can purchase the product
.

Presently the database is queried in all the four steps explained above.

I intend to :

Hit database once user logs in and retrieve information regarding the access levels of the user for all products listed in the store.
Persist this info in JVM using either Hibernate,JPA or JDO api.
Now for any further access info, the persisted objects will provide the data.
This reduces the database hits.



Other details :

App Server : Jboss
Database : oracle
Expected Concurrent users : 2000 - 3000

Please note that the attempt is to utilize only the persistence feature of the above APIs although I accept the fact that the functionality described above might not call for such heavy persistence frameworks.Please provide your suggestions as to what should be the ideal approach.


Regards,
Abhishek.

[ November 05, 2008: Message edited by: abhishek paul ]
[ November 05, 2008: Message edited by: abhishek paul ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic