Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Convert a project into JSP-Servlet

 
Ali Hadian
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Hi,

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
Marshal
Posts: 34084
337
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ali,
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic