aspose file tools*
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 Spring in Action this week in the Spring 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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30762
    
156

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Convert a project into JSP-Servlet