wood burning stoves 2.0*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
Author

Convert a project into JSP-Servlet

Ali Hadian
Greenhorn

Joined: Jun 25, 2010
Posts: 2

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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30057
    
149

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
Consider Paul's rocket mass heater.
 
subject: Convert a project into JSP-Servlet
 
Similar Threads
Interview questions on servlets
mixed persistence
EL & Servlet & JSP
why don't we use main() in Servlet,Jsp?
Problems with TOMCAT 4