The moose likes EJB and other Java EE Technologies and the fly likes Convert a project into JSP-Servlet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Convert a project into JSP-Servlet" Watch "Convert a project into JSP-Servlet" New topic

Convert a project into JSP-Servlet

Ali Hadian

Joined: Jun 25, 2010
Posts: 2


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.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33102

Welcome to JavaRanch!

1) Yes. Search for JDBC (Java database connectivity)
2) Hibernate/JPA is a common option. It may be overkill if your project is very small or you already use stored procedures extensively.
3) You haven't shared enough about your requirements to say. I don't see anything that draws you to EJB though. It sounds like a simple app.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Convert a project into JSP-Servlet
It's not a secret anymore!