Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Getting HTTP 500 Error When Trying To Authenticate Against LDAP Server (Active Directory)

2663421Mar 31 2015 — edited Apr 8 2015

Hello,

I am currently facing an issue when I try and use LDAP authentication in my Apex application as I am getting a HTTP 500 Internal Server Error message. For my authentication scheme I have used the pre-configured option of how to connect to an LDAP server and in my development environment this seems to be working fine but now I have deployed my application to our staging environment and I am getting the error. If I switch to the Application Express Authentication scheme then I don't get the error.

I've had a look at the log file on the server and I see I am getting this error:

[#|2015-03-31T16:19:11.254+0100|SEVERE|glassfish3.1.2|null|_ThreadID=21;_ThreadName=Thread-2;|JDBCException [kind=UNAVAILABLE]

    at oracle.dbtools.common.jdbc.JDBCException.wrap(JDBCException.java:99)

    at oracle.dbtools.common.config.db.DatabaseConfig.getConnection(DatabaseConfig.java:81)

    at oracle.dbtools.common.jdbc.ora.OraPrincipal.connection(OraPrincipal.java:69)

    at oracle.dbtools.apex.ModApexContext.getConnection(ModApexContext.java:372)

    at oracle.dbtools.apex.OWA.getStatement(OWA.java:536)

    at oracle.dbtools.apex.OWA.init(OWA.java:308)

    at oracle.dbtools.apex.ModApex.doPost(ModApex.java:138)

    at oracle.dbtools.apex.ModApex.service(ModApex.java:303)

    at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:347)

    at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:130)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:770)

    at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1550)

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:281)

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)

    at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)

    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161)

    at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:331)

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:231)

    at com.sun.enterprise.v3.services.impl.ContainerMapper$AdapterCallable.call(ContainerMapper.java:317)

    at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195)

    at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860)

    at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757)

    at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056)

    at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229)

    at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)

    at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)

    at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)

    at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)

    at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)

    at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)

    at com.sun.grizzly.ContextTask.run(ContextTask.java:71)

    at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)

    at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)

    at java.lang.Thread.run(Thread.java:662)

Caused by: java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use

    at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:488)

    at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:163)

    at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:928)

    at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:863)

    at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:855)

    at oracle.dbtools.common.config.db.DatabaseConfig.getConnection(DatabaseConfig.java:71)

    ... 33 more

Caused by: oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use

    at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:368)

    at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:49)

    at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:80)

    at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:131)

    at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithoutCountingRequests(UniversalConnectionPoolImpl.java:279)

    at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnection(UniversalConnectionPoolImpl.java:142)

    at oracle.ucp.jdbc.JDBCConnectionPool.borrowConnection(JDBCConnectionPool.java:157)

    at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:916)

    ... 36 more

So it seems that every time I try and use LDAP I hit this error. Also after awhile I have to re-start the Apex Listener for that domain. I have came across this thread: LDAP Authentication Question but I am not sure if the user got the problem solved or not.

Our infrastructure is as follows:

Database: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit

Apex Listener: 2.0.3.221.10.13

GlassFish Server Open Source Edition 3.1.2.2 (build 5)

If anybody has any idea what is causing this that would be great.

Cheers,

Paul.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 6 2015
Added on Mar 31 2015
3 comments
1,648 views