Best way of Connecting DataBase to Web Applicaion

[madhub2v]

Can any one tell me

I learnt about JDBC,Hibernate technologies.

I wonder about WEB Projects which uses JDBC technology exist today.?
If yes
How they are configuring JDBC Logic in web application in practical scenario.

thanks.

[masijade]

If you are working with relatively small amounts of records (in the low thousands in one hit) with a single transaction, use hibernate or some other object representation framework, if you are working in bulk (hundreds of thousands of records or more in one hit), use straight JDBC (or maybe something like ibatis). In either case use the containers connection pool.

[madhub2v]

thanks Masijade..for your reply.

in real time scenario do they use JDBC only for
example bank applications or shopping cart web projects.
which technology is used mostly..?

[masijade]

As already said, it depends on the scope of the individual transactions.