Brij,
Here are responses to your questions:
1. Where is question of writing JDBC code to handle transaction of you use EJB?
- Not sure what you mean? Do you mean hand-coding everything with JDBC yourself? This really isn't necessary any more with all the persistence tier choices. In fact, I'm not sure why you would ever want to do this really for a brand new application?
2. Why do you think that iterating result set is error prone?
- It could be error prone, but the point is that it is far more verbose than using an ORM solution.
3. Why do you think that if you handle transaction in store procedure you will have to write whole business logic in store procedure?
- That's not really what I said. It does not necessarily have to be, but it often is in practice and should really be avoided. The reason this often happens is the idea with some folks that stored procedures are suitable for business logic.
4. Why do you think that it is difficult to debug store procedure or enterprise java code?
- Not sure what you mean here either. Procedural code is simply a lot harder to maintain that anything in OO, not to mention development/testing/debugging tools like the ones available in Java IDEs are simply not available for anything on the DB end. The procedural paradigm also has not evolved much for a long time, while OO has evolved quite a bit around standards,
patterns, tools and best practices.
5. Any way if use JSF on application layer then you will have to use jsp for client side.
- This isn't really true. Have you looked into Facelets? It's actually much better suited to JSF and has been included in the JSF 2.0 standard.
6. Struts have plenty of in built custom tag to iterate object on jsp.
- You mean JSTL? But that's not a component model, though. If you haven't looked into JSF/Facelets, it's best to check it out on your own to see how it differs from JSTL or even JSP custom tags. Like ASP.NET, JSF is component based; while Struts is controller/action based. Here is a good write-up from the Struts folks themselves on the differences:
http://struts.apache.org/2.0.14/docs/what-are-the-fundamental-differences-between-struts-and-jsf.html.
7. There is no need to write form and action for every jsp if use struts.
- Yes, but that's most often the case. Again, it is best to take a look at JSF to see the difference or take a look at the article above and similar resources.
Hope it helps,
Reza
P.S.: It is OK to refer to me by my first name. Last names are so impersonal :-).