Database interaction

[abhijava]

Hi Friends!

I am connecting to database through javabeans, but there is one confusion....i.e...how i should connect to the database , as it is an webapplication and many users can interact with database simultaneously. If I synchronize the methods to maintain consistency then the application becomes slow.
Can u guide me in this regard.

[hanofee]

Me again
IMHO, synchronization and consistency should be handled by database not the application, they're built much better for that purpose (but use proper database for real, not HSQL like).
Also, try to see O/R mapping stuff like Hibernate. Any people said Hibernate is slow will be either very expert or very beginner. Yes, direct JDBC, if you know how to optimize (which most people don't, like me) is faster but O/R mapping simplify a lot of things (with reasonable performance, most of the times even better if you don't know how to optimize your query). One thing Hibernate will help you is to manage a pool of connections.

[abhijava]

Thanks Hanofee!!

Right now i have no idea about hibernate and O/R mapping......!!
So, I will be back aftr learning this stuff....but...are u sure this is the right solution, plz. confirm. So that i start learning it fast.
And can u plz. refer me any reference/book for learning hybernate.

[hanofee]

If you're accessing database quite a lot and it's a long term project, then yes, it's worth the time to learn (and I believe the concept will still last long, viewing that JBoss implementation of EJB3 which is very close to it - cause they're lead by the same person - so if you know EJB, it can be an alternative )

I rarely read computer books since the days google is there, so to start with:
http://www.hibernate.org/152.html
You'll probably waste 1 week just to get into it, so, it will bring a lot of advantages, only if you have time and resource...

[abhijava]

Thanks friend!!...