We have written a Desktop Application (Library Management System) with C#.Net.
Due to a customer request, we need to convert it to a Web application and we are forced to use the JSP-Servlet approach.

I have some questions:

1. Is it possible in JSP-Servlet to connect to MS SQL database and use all its features (ex. Stored Procedures)

2. What is the best solution to provide the "Object-Relational Mapping" (convert queries to Objects and vice versa).

3. Do you suggest using EJB? why?
3.1. if the answer is positive, is it better to use "Container Managed Persistence" OR "Bean Managed Persistence"?? and Why?

Thanks in advance.