Error ListenerConfigure - ORDS, SODA & JSON in the Database

I deployed apex listener on OC4J Container 10.1.3.4 successfully using installation documentation; when I try configuring connection to database, I have 500 errors;
application.log
------------------------------------------------------------------------------------------------------------------------------------
java.lang.NoSuchMethodError: java.lang.String.isEmpty()Z
     at oracle.dbtools.apex.admin.AdminManager.validConnection(AdminManager.java:337)
     at oracle.dbtools.apex.admin.AdminManager.validateInfo(AdminManager.java:168)
     at oracle.dbtools.apex.admin.AdminManager.processAdministration(AdminManager.java:81)
     at oracle.dbtools.apex.admin.Admin.doPost(Admin.java:89)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
     at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
     at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
     at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
     at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
     at java.lang.Thread.run(Thread.java:595)
---------------------------------------------------------------------------------------------------------------------------------------
What I'm doing wrong? I configured modplsql (connection to the same instance), no problem;
I'd like to start using apex listener
Please help 

You need to use jdk 1.6+
-kris 

What do you mean use Jdk 1.6?
Where? Can you give me more details please?
Thanks Mary 

Mary,
Go here: http://java.sun.com/javase/downloads/index.jsp
and download the latest JDK then start the webserver again. This should make it pick up the newly installed JDK 1.6.20
-kris

Related

invalid or unknown NLS parameter value specified

I'm using OC4J Standalone 10.1.2. I keep getting the error for some of my modules while the others work just fine. But the way I access the database or EB or the deployment descriptor, everything is similar. I'm running out of thoughts why this problem occurs in some of the modules only.
Below is error stack trace and I still can't figure what does it mean (even after searching online) let alone finding the solution.
Hope you all can help. Thanks in advance.
05/04/29 15:43:21 thread 7: Failed to add the resource due to error in the resource
MarshallingXAException : ORA-00604: error occurred at recursive SQL level 1
ORA-12705: invalid or unknown NLS parameter value specified
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.DriverManagerXAConnection.start(DriverManagerXAConnection.java:114)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.TransactionEnlistment.<init>(TransactionEnlistment.java:45)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.ApplicationServerTransaction.enlistResource(ApplicationServerTransaction.java:248)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.OrionCMTConnection.tryToDelistEnlist(OrionCMTConnection.java:312)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.OrionCMTConnection.intercept(OrionCMTConnection.java:129)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.FilterConnection.prepareStatement(FilterConnection.java:236)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.FilterConnection.getCustomStatement(FilterConnection.java:642)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.OracleConnectionBCELProxy.getCustomStatement(OracleConnectionBCELProxy.java:234)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.ejb.DataSourceConnection.getCustomStatement(DataSourceConnection.java:222)
     at EBSystemParameterLocalHome_EntityHomeWrapper227.getOnlyPKSet_1047(EBSystemParameterLocalHome_EntityHomeWrapper227.java:1252)
     at EBSystemParameterLocalHome_EntityHomeWrapper227.findByTypeAndCD(EBSystemParameterLocalHome_EntityHomeWrapper227.java:1112)
     at com.infopro.dt.app.systemparameter.ejb.SBSystemParameter.getSystemValue(SBSystemParameter.java:310)
     at SBSystemParameterRemote_StatelessSessionBeanWrapper163.getSystemValue(SBSystemParameterRemote_StatelessSessionBeanWrapper163.java:755)
     at com.infopro.dt.ui.bizdelegate.SystemParaDelegate.getSystemValue(SystemParaDelegate.java:178)
     at com.infopro.dt.ui.filter.SystemStatusFilter.checkSystemStatus(SystemStatusFilter.java:95)
     at com.infopro.dt.ui.filter.SystemStatusFilter.doFilter(SystemStatusFilter.java:71)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:645)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:322)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
     at java.lang.Thread.run(Thread.java:534)
Nested exception is:
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: invalid or unknown NLS parameter value specified
     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
     at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:647)
     at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
     at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
     at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:149)
     at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
     at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:551)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:160)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.DriverManagerConnectionPoolDataSource.getPooledConnection(DriverManagerConnectionPoolDataSource.java:36)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.OrionPooledDataSource.getPooledConnection(OrionPooledDataSource.java:582)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.PooledConnectionUsage.getPooledConnection(PooledConnectionUsage.java:22)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.OrionPooledDataSource.getConnection(OrionPooledDataSource.java:346)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.DriverManagerXADataSource.getNonAutoCommitConnection(DriverManagerXADataSource.java:330)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.DriverManagerXAConnection.start(DriverManagerXAConnection.java:97)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.TransactionEnlistment.<init>(TransactionEnlistment.java:45)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.ApplicationServerTransaction.enlistResource(ApplicationServerTransaction.java:248)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.OrionCMTConnection.tryToDelistEnlist(OrionCMTConnection.java:312)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.OrionCMTConnection.intercept(OrionCMTConnection.java:129)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.FilterConnection.prepareStatement(FilterConnection.java:236)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.FilterConnection.getCustomStatement(FilterConnection.java:642)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.OracleConnectionBCELProxy.getCustomStatement(OracleConnectionBCELProxy.java:234)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.ejb.DataSourceConnection.getCustomStatement(DataSourceConnection.java:222)
     at EBSystemParameterLocalHome_EntityHomeWrapper227.getOnlyPKSet_1047(EBSystemParameterLocalHome_EntityHomeWrapper227.java:1252)
     at EBSystemParameterLocalHome_EntityHomeWrapper227.findByTypeAndCD(EBSystemParameterLocalHome_EntityHomeWrapper227.java:1112)
     at com.infopro.dt.app.systemparameter.ejb.SBSystemParameter.getSystemValue(SBSystemParameter.java:310)
     at SBSystemParameterRemote_StatelessSessionBeanWrapper163.getSystemValue(SBSystemParameterRemote_StatelessSessionBeanWrapper163.java:755)
     at com.infopro.dt.ui.bizdelegate.SystemParaDelegate.getSystemValue(SystemParaDelegate.java:178)
     at com.infopro.dt.ui.filter.SystemStatusFilter.checkSystemStatus(SystemStatusFilter.java:95)
     at com.infopro.dt.ui.filter.SystemStatusFilter.doFilter(SystemStatusFilter.java:71)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:645)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:322)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
     at java.lang.Thread.run(Thread.java:534)
05/04/29 15:43:21 Error in bean EBSystemParameter: Database Error
java.sql.SQLException: SystemException: Failed to add the resource due to error in the resource
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.OrionCMTConnection.tryToDelistEnlist(OrionCMTConnection.java:316)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.OrionCMTConnection.intercept(OrionCMTConnection.java:129)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.FilterConnection.prepareStatement(FilterConnection.java:236)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.FilterConnection.getCustomStatement(FilterConnection.java:642)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].sql.OracleConnectionBCELProxy.getCustomStatement(OracleConnectionBCELProxy.java:234)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.ejb.DataSourceConnection.getCustomStatement(DataSourceConnection.java:222)
     at EBSystemParameterLocalHome_EntityHomeWrapper227.getOnlyPKSet_1047(EBSystemParameterLocalHome_EntityHomeWrapper227.java:1252)
     at EBSystemParameterLocalHome_EntityHomeWrapper227.findByTypeAndCD(EBSystemParameterLocalHome_EntityHomeWrapper227.java:1112)
     at com.infopro.dt.app.systemparameter.ejb.SBSystemParameter.getSystemValue(SBSystemParameter.java:310)
     at SBSystemParameterRemote_StatelessSessionBeanWrapper163.getSystemValue(SBSystemParameterRemote_StatelessSessionBeanWrapper163.java:755)
     at com.infopro.dt.ui.bizdelegate.SystemParaDelegate.getSystemValue(SystemParaDelegate.java:178)
     at com.infopro.dt.ui.filter.SystemStatusFilter.checkSystemStatus(SystemStatusFilter.java:95)
     at com.infopro.dt.ui.filter.SystemStatusFilter.doFilter(SystemStatusFilter.java:71)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:645)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:322)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
     at java.lang.Thread.run(Thread.java:534) 
This is most likely caused by a misconfiguration of NLS parameters. The message "Failed to add the resource due to error in the resource" simply means that the TM receives an exception from resource.start() while attempting to enlist the resource. I am not sure why you would receive this exception for some modules and not others from the information that you have provided.
There is a good explanation of this issue at : http://www.experts-exchange.com/Databases/Oracle/Product_Info/Q_21065862.html
John 
I've tried changing my NLS_LANG already, but still it doesn't solve the problem. 
Have exact the same problem:
My Test app works (Servlet->StatelessBean->JNDI->Connection Oracle 8i), my real world app crashs.
Curiosly after the TestApp runs correctly, the real world app also works!
NLS_LANG doesn't change anything 
http://www.sql.ru/forum/actualthread.aspx?tid=184458#1605499 (russian)
... driver execute ALTER SESSION for change NLS settings (use Locale.getDefault() ).
For RU uses RUSSIA (in 8x version CIS).
Workarround:
oracle.i18n.text.OraMapTable.getInstance(1).getHashMapAttribute("ISO_A2_TERR_2_ORACLE_TERR").put("RU", "CIS");
before connecting. Check your NLS.

Apex Listener - OC4J

Hi,
I am trying to configure apex listener on OC4J with XE as the database. When I try to apply I get a:
500 Internal Server Error.
The Application.log shows the following:
0/07/27 07:29:05.328 apex: Servlet error
java.lang.NoSuchMethodError: java.lang.String.isEmpty()Z
     at oracle.dbtools.apex.admin.AdminManager.validConnection(AdminManager.java:337)
     at oracle.dbtools.apex.admin.AdminManager.validateInfo(AdminManager.java:168)
     at oracle.dbtools.apex.admin.AdminManager.processAdministration(AdminManager.java:81)
     at oracle.dbtools.apex.admin.Admin.doPost(Admin.java:89)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:226)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:127)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:116)
     at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
     at java.lang.Thread.run(Thread.java:595)
I already have jdk1.6.0_21 installed. Please advise as to how this can be fixed.
Thanks,
Rajeev 
This Works now. 
1) The current listener will not work with XE. A fix is coming.
2) An old java is being referenced. Check your path to make sure 1.6 is being picked up.
Run: java -version to check
-kris 
Thanks Kris. I had to shutdown and restart OC4J ( I did this earlier too but closed the cmd completely this time) and it seems to work.

classpath problem during deployment in oracle 10g application server

java.lang.NoClassDefFoundError: oracle/toplink/sessions/UnitOfWork
     at java.lang.Class.forName0(Native Method)
     at java.lang.Class.forName(Class.java:219)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpApplication.loadServlet(HttpApplication.java:2028)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpApplication.findServlet(HttpApplication.java:4523)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:2561)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:640)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:208)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:125)
     at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
     at java.lang.Thread.run(Thread.java:534)
required urgent help.

javax.jms.JMSException: Not supported in XA-backed sessionoutside global tx

I am trying to setup OracleOJMS provider and tries to access queue and post to queue from a normal jsp for testing.
I am getting the following
javax.jms.JMSException: Not supported in XA-backed session outside global transaction
     at oracle.j2ee.ra.jms.generic.RAUtils.make(RAUtils.java:525)
     at oracle.j2ee.ra.jms.generic.RAUtils.toJMSException(RAUtils.java:199)
     at oracle.j2ee.ra.jms.generic.RAUtils.toJMSException(RAUtils.java:210)
     at oracle.j2ee.ra.jms.generic.CommonProducerWrapper.prepareForSend(CommonProducerWrapper.java:350)
     at oracle.j2ee.ra.jms.generic.CommonProducerWrapper.send(CommonProducerWrapper.java:159)
     at _ResourceProvider._jspService(_ResourceProvider.java:112)
     at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.1.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
     at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:453)
     at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:591)
     at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:515)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:711)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
     at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
     at java.lang.Thread.run(Thread.java:595)I have posted query in this link.
http://saloon.javaranch.com/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=14&t=001837
Can you please help me out?

Error 500 with generic Apache

Hi,
I am trying to user Apex Listener 1.0.2 on OC4J fronted with generic Apache 2.0. I configured mod_oc4j and the combination seems to work.
When i ran apex/listenerConfigure the configuration page shows up. But when I try to Apply changes I constantly get
500 Internal Server Error
Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.
Any idea what would be the cause?
Janis 
Hi Janis,
there may be a few reasons, like the Apache does not have privileges to write on the tempdir of the OC4J. It could also be there is a JDBC connect failure, or something completely different.
What does the application log say?
-Udo 
Thank you for the answer. This is the log. I hope it helps
10/10/27 12:39:04.951 apex: 10.1.3.5.0 Started
10/10/27 12:56:51.975 apex: Servlet error
java.lang.NoSuchMethodError: java.lang.String.getBytes(Ljava/nio/charset/Charset;)[B
     at oracle.dbtools.apex.utilities.Text.getBytes(Text.java:31)
     at oracle.dbtools.apex.ModApex.notifyNotConfigured(ModApex.java:257)
     at oracle.dbtools.apex.ModApex.doConfig(ModApex.java:98)
     at oracle.dbtools.apex.ModApex.doGet(ModApex.java:92)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
     at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
     at java.lang.Thread.run(Thread.java:595)
10/10/27 12:59:11.662 apex: Servlet error
java.lang.NoSuchMethodError: java.lang.String.isEmpty()Z
     at oracle.dbtools.apex.admin.AdminManager.validConnection(AdminManager.java:337)
     at oracle.dbtools.apex.admin.AdminManager.validateInfo(AdminManager.java:168)
     at oracle.dbtools.apex.admin.AdminManager.processAdministration(AdminManager.java:81)
     at oracle.dbtools.apex.admin.Admin.doPost(Admin.java:87)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
     at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
     at java.lang.Thread.run(Thread.java:595) 
Hi ,
which Java Version do you have on the system that runs your mod_oc4j on Apache 2.0?
You definetly need Java 6 Update 20 JDK and an implementation of Java Servlet Specification 2.3 - which is part of the full OC4J but possibly not in your mod_oc4j-instance.
Is there any specific reason why you run on mod_oc4j rather than using OC4J-standalone or even the embedded GlassFish instead?
-Udo 
Udo,
thank you very much. That was the JDK version which caused all the trouble. I have the latest jdk installed on my server but i didn't realize that OC4J instance is using its own copy. After upgrading everything works great.
The main reason I'm using Apache and mod_oc4j is to make more user friendly URLs for my applications. Alse some applications are calling php scipts.
Janis

Categories

Resources