This content has been marked as final. Show 10 replies
Oracle comes with an embedded pl/sql gateway (DBMS_EPG) as an alternative to mod_plsql. Actually, the XE user interface runs on it.
You can easily use another application server together with XE, like JBoss, Tomcat, Bea, Oracle IAS, whatever.
Oracle XE doesn't come with one bundled and doesn't support J2EE capabilties out of the database. And there is no Java inside the database like in the other Oracle editions.
Can somebody tell me more about Internet Access to Oracle Streams AQ using Oracle DB Express Edition (XE). What other software do I need to install to run Oracle Streams AQ servlet and do HTTP POST requests ?
I need to avoid usage of Oracle Application Server. Is it possible to use OC4J Standalone Distribution for Servlet Deployment?
Thanx in advance
I need to avoid usage of Oracle Application Server.Interesting question. Why do you need to avoid using Oracle's application server?
Is it possible to use OC4J Standalone Distribution
for Servlet Deployment?
Why do you need to avoid using Oracle's application server?I got such requirement from my projects manager. I assume they want to reduce the costs of the software that we are developing. In that way our software customers won't have to buy Oracle's application server license.
Any help on my previous question is still needed.
To at least partly answer your question: I have used the OC4J and the Mapviewer and other servlets to access Oracle spatial/locator information in XE. No problem at all. Works well for any servlet I've tested, as long as the servlet dows not expect XA or RMI in the database.
The reason for my question -
Last time I checked closely, the standalone OC4J can only be used in a development environment. To put an OC4J into production, you need to purchase at least the J2EE version.
The OC4J Standalone distribution is for development purposes only, you will need to license the minimum packaging of Oracle AS to use it for production deployment and get support for it.
I was successful in creating JSP on XE without OC$J. I downloaded a 3-connection version of ServletExec from www.newatlanta.com and Apache 2.0.55, had it working in short order. I will provide detailed instruction how I did this if requested, write to me at hoozon1st@_y_a_h_o_o_dot_com. This would be a proof of concept only, you would have to examine your needs to be sure of its value for continued usage.
To answer the original question, yes we are shipping the AQ servlet with Express Edition. It is tested and supported.
that is a good news for me. Can you provide a "how to" guide about XE's AQ access via AQxmlServlet. I am interested in:
1. On which Application Server AQxmlServlet was tested?
2. Where can I get missing jars that are not shipped with Oracle XE? (ORACLE_HOME/JDBC/LIB/nls_charset12.jar, ORACLE_HOME/lib/http_client.jar, ORACLE_HOME/oc4j/j2ee/home/lib/javax-ssl-1_2.jar, ORACLE_HOME/lib/servlet.jar, ORACLE_HOME/lib/xmlparserv2.jar, ORACLE_HOME/lib/xsu12.jar, etc.)
3. Which JDK, JDeveloper versions where you using?
Can you visit my topic:
Oracle XE Advanced Queuing
and see if you could point me to an answer on my problem.
Thanks in advance
Message was edited by:
any response from Oracle Staff on XE's AQ access via AQ servlet is still needed. If it is tested, please answer. Thanx.