I need some guidens for a project

[Trupti Mehta]

I am developing a project in JSP which is quiet big. Lots of DB operations, Credit Card transactions also. I am supposed to do this as a JSP project. I am confused and wondering that how do I do this all with just Servlets. My main issue points are :
Have to use MS Access as DB
How should I maintain persisteance and Multi threading
Can the work be done in JSP/SErvlets successfully or EJB or Java Beans should be used ???

I am extremely confused and don't understand from where and how to start as can't finalize the resources to be used for the project. I will be using NetBeans & Sun Application Server 9.1

I need your guidelines for the above concerns and some to start the initials. Please help me with your knowledge & experience and share to guide me to finalize what to use. Hoping to get help from you at the earliest.

Thanks

[ujjwal soni]

Hi Trupti,

Your project has to be very secured. Servlets cannot be used, you need to use some framework like struts or spring. Secondly, for persistance you can use ibatis or hibernate frameworks as they provide transaction facility. Is it necessary to use MS Access in your project ?
Persistance will be managed by ibatis or hibernate & multithreading by spring or struts framework.

You can use netbeans or myeclipse as development IDE.

Jboss can be used as a development container for deploying j2ee applications. If you are using struts, you may use tomcat or if spring then jboss would be good.

Also, the website needs to be ssl secured. So, you need to purchase / subscribe to an ssl certificate.


Many thanks,

Ujjwal B Soni

<baroda, india, gujarat>
[[phone]]

[Trupti Mehta]

ujjwal soni wrote:Hi Trupti,

Is it necessary to use MS Access in your project ?
Persistance will be managed by ibatis or hibernate & multithreading by spring or struts framework.

You can use netbeans or myeclipse as development IDE.

Jboss can be used as a development container for deploying j2ee applications. If you are using struts, you may use tomcat or if spring then jboss would be good.

Also, the website needs to be ssl secured. So, you need to purchase / subscribe to an ssl certificate.

Thanks Ujwal,

* The client has recommended to use MS Access. I will recommend for MS-SQL or My-SQL, I guess MS-SLQ will be better off. What do you say ?
* I am using NetBeans & have to use Sun Application Server
* I have never used spring, struts, hibernate ir ibatis. Can you recommend 1 among the two, which are better and easy to work too. I have worked on many new frameworks without knowing them, so I will grasp this also, but which one should go for?
* SSL certification will be managed by client, but I atleast have to make it working perfectly.

Please help me with the above.

[Bauke Scholtz]

Crossposted: http://forums.sun.com/thread.jspa?threadID=5373060
Please read this: http://faq.javaranch.com/java/BeForthrightWhenCrossPostingToOtherSites

[Trupti Mehta]

Sorry to mention, but the same post is posted at : http://forums.sun.com/thread.jspa?threadID=5373060

Though I find mosre answers from this site only and is my most preferred site. Please don't ignore this question, help me.

[Surya Kant]

I woulld suggest you to go for struts as its learning curve is not so big and you will get lots of support from so many peple around the world.
Secondly it supports SSL very nicely.you don have to struggle much.
What other ranchers say about this???

[Bear Bibeault]

Surya Kant wrote:What other ranchers say about this?

Since you asked, I think that Struts is a huge, monolithic, Rube Goldberg contraption that gets in the way more than it helps.

And SSL and Struts have nothing to do with each other.

[ujjwal soni]

Hi Trupti,

I would suggest you to go for struts, its quite easier to learn. You can read a book called jakarta struts (WILEY) by james goodwill.

For persistance, you can use ibatis, its much quicker & easier to learn & maintain a site rather than using hibernate.

MS Sql server would be better rather than access or mysql as you can manage the database using sql server management studio express.

But, be sure to get the developer edition rather than using a free express edition as the developer edition has many more features like mailing etc which are not in express edition & also the express edition has restricted size of database.

For security, you can use ACEGI security framework with struts framework.

[Vikas Kapoor]

For persistance, you can use ibatis, its much quicker & easier to learn & maintain a site rather than using hibernate.

MS Sql server would be better rather than access or mysql as you can manage the database using sql server management studio express.

Ok I don't have any expeirence with iBatis but hibernate is also easy to use.
MySQL is freeware while MSSQL is not freeware. MySQL does have decent UI tool.

For security, you can use ACEGI security framework with struts framework.

ACEGI is now known as Spring Security. http://en.wikipedia.org/wiki/Acegi_security_framework_(Java)

[Seetharaman Venkatasamy]

ujjwal soni wrote: Servlets cannot be used, you need to use some framework like struts or spring.

why servlet cant ? this project can be done using simple servlet/jsp , and MySQL is good for backend

[Trupti Mehta]

Thanks to all of you for helping me finalize what to use for this project. As I thought that the same could be done just using JSP/SErvlets but was very much confused with other all resources available for the same. I have worked on WEb using JSP/Servlets/EJB. But that all was too long ago. So I finalized that I will stick to JSP & Servlets & for Db, I have experience working with MS SQL. If the client is ready for MS SQL will go for that else MySQL.

To move ahead, I guess I can make required Java classes & for DB operations, to handle multithreading/Persistence I should make it Serializable & adapt Synchronization. If I am wrong please correct me. And provide guidens for the above. Like for eg, Login case, multiple users may log at same time. I have login.jsp, LoginServlet. Another class will handle all DB operations like checking valid Login & on validity make appropriate object for the logged in. User can log in as 3 types - each will have its own class.
So login.jsp, calls LoginServlet. Which calls DBOperations.ValidUser(id, pswd, type) & returns true/false. If true LoginsErvlet will create an object of appropriate type. here how should I handle multiple logins at same time.

This hasto be used for Intranet & Internet.
Your info can help me remember the how-to & what I had done earlier & have to do now. As I don't only work on Java, I work on Java, C/C++, .NET(VB, C#), J2ME, Other mobile devlopments, etc. Please give me this guidens so I can plan my other classes & operations accordingly. If you can provide eg code much better.