• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
reply
    Bookmark Topic Watch Topic
  • New Topic