what is the best approach to do JDBC implementation at persistent layer side in spring framework ;
for larger applications like 500 users hitting the application daily ,this kind of application should i use HibernateDAOsupport class in spring or spring's JDBC Template class;
I would not base the decision on the number of users but in the complexity of the query you want to execute. In my experience, the convenience that Hibernate provides is usually worth any overhead when it comes to simpler queries. Once you start having more complicated queries involving multiple joins and/or more than two tables, then overhead becomes more of an issue. If you program to DAO interfaces, it is easy enough to switch from a Hibernate implementation to a JDBC implementation.
