Using EJBs with both servlets and Forms client - is it possible?

Hi,

this is a newbe question.

I am planning to develop application working in heterogenous environment:
* one part of the application working via Internet browser (front office)

• another part of the application working with GUI client (back office)

I want to use Oracle 9i Application Server, put the business logic to the PL/SQL / Java stored procedures. Then "wrap" the business logic with EJB objects. Then I will use servlets to connect to these EJB's, generate some XML that will be transformed with XSL into HTML (front office) From the other hand I want to have Forms client connecting to the DB (back office)

Questions:
1) Can I connect to the EJB from the Forms client? What protocol is used with such connection?
2) If not, what is the best way to keep one business logic in both environments? Are stored procedures the only way, or can I put it to EJBs and connect to EJBs from Forms.
3) I could put ALL business logic to SP's without using EJB. Is there any performance impact, when using LOTS of SP's? 4) What is your opinion on using Java SP's vs. PL/SQL SP's? 5) Theoretically I could quit using O9iAS and replace it with Apache web server / Tomcat servlet engine and connect from servlets to DB using JDBC. What will I miss if I'll do it?

Ah, one more question: do you recomend using Oracle iAS9i or should I consider earlier version of Oracle AS beacause, for example, there is a lot of bugs in iAS9i

best regards

Szymon Manduk

. Received on Wed Aug 08 2001 - 14:31:05 CEST