Hi, I'm afraid I'm going to ask a sensitive question now. Existingly, we have many Oracle Forms and Reports 6.0 running on Oracle 9i App Server. Its database are running Oracle 8i. We are currently evaluating new technology esp in the area of Java (EJB) to replace proprietory PL/SQL used in Oracle Form and Reports. I've got 2 EJB server in mind: Oracle 9i App Server or IBM WebSphere? Any recommendation and comments would be appreciated. ------------------ Thank you. - Simon See firstname.lastname@example.org -after office hours- necro-mani-cide
Traditionally, Oracle's J2EE tools were not very good. With 9i, however, my understanding is that Oracle ditched their old platform and licensed the Orion Application server (http://www.orionserver.com). So, essentially, Oracle 9i AS is Apache HTTP Server + Orion App Server + Oracle. My personal opinion of Orion is not very high. Earlier in the month I wasted a week trying to switch over to it from JBoss, only to give up due to frustration with simple, non-J2EE related bugs (such as its seeming inability to allow me to read properties files off the classpath). If you have a lot of Oracle stuff, though, I suppose 9i AS might be helpful... Buzz
Yes, I agree that Orion can be frustrating -- basically since you just have to hack it in order to understand what's going on. However, I do get the impression that Orion is a good performing app. server, but I don't really have any evidence to validate my feelings since we haven't yet done any serious testing with it.
In any case, I didn't have any trouble reading properties files in the class path. Also, Oracle distribute the Orion server as a single ZIP file -- oc4j.zip. Oracle calls it "Oracle Containers for J2EE", but it is really just the Orion server. Therefore you can install and run OC4J without 9iAS at all.
However, I don't think that using 9iAS will ease your migration from PL/SQL to EJB. I think you will have the same amount of work regardless of which app. server you choose.