7 Ответы Последний ответ: 14.03.2019 14:46, автор: avarap1

    The connection pool named: |apex|| is not correctly configured, due to the following error(s): oracle.jdbc.pool.OracleDataSource.createConnectionBuilder()Loracle/jdbc/pool/OracleConnectionBuilderImpl;

    user8400641

      Hi,

       

      I tried to configure ORDS 18.4 in TOMCAT 8.5.32 under windows and I am getting the next error.

      503 Service Unavailable

      The connection pool named: |apex|| is not correctly configured, due to the following error(s): oracle.jdbc.pool.OracleDataSource.createConnectionBuilder()Loracle/jdbc/pool/OracleConnectionBuilderImpl;

       

      But if i am running the standalone it is working fine. do i need to configure something else?

       

       

        • 1. Re: The connection pool named: |apex|| is not correctly configured, due to the following error(s): oracle.jdbc.pool.OracleDataSource.createConnectionBuilder()Loracle/jdbc/pool/OracleConnectionBuilderImpl;
          thatJeffSmith-Oracle

          have you tried the validate function?

           

          1.3.4.3 Validating the Oracle REST Data Services Installation

           

          If you want to check that the Oracle REST Data Services installation is valid, go to the directory or folder containing the ords.war file and enter the validate command in the following format:

          java -jar ords.war validate [--database <dbname>] 

          Note:

          When you install Oracle REST Data Services, it attempts to find the Oracle Application Express (APEX) schema and creates a view. This view joins the relevant tables in the APEX schema to the tables in the Oracle REST Data Services schema. If you install Oracle REST Data Services before APEX, then Oracle REST Data Services cannot find the APEX schema and it creates a stub view in place of the missing APEX tables.

          Oracle highly recommends that you install Oracle REST Data Services after APEX to ensure that the APEX objects, which Oracle REST Data Services needs to query, are present. If you install Oracle REST Data Services before APEX, then use the validate command to force Oracle REST Data Services to reconstruct the queries against the APEX schema.

          If --database is specified, <dbname> is the pool name that is stored in the Oracle REST Data Services configuration files.

          You are prompted for any necessary information that cannot be obtained from the configuration of pool name, such as host, port, SID or service name, and the name and password of a user with SYSDBA privilege (such as SYS AS SYSDBA).

          • 2. Re: The connection pool named: |apex|| is not correctly configured, due to the following error(s): oracle.jdbc.pool.OracleDataSource.createConnectionBuilder()Loracle/jdbc/pool/OracleConnectionBuilderImpl;
            avarap1

            java -jar ords.war validate --database dev501 is executed but in tomcat is still complaining but standalone is still running smoothly, i will try with a older version of ORDS 18.3.

            • 3. Re: The connection pool named: |apex|| is not correctly configured, due to the following error(s): oracle.jdbc.pool.OracleDataSource.createConnectionBuilder()Loracle/jdbc/pool/OracleConnectionBuilderImpl;
              thatJeffSmith-Oracle

              Let's turn debug on

               

              <entry key="debug.debugger">true</entry>

              <entry key="debug.printDebugToScreen">true</entry>

               

              The developer thinks it might be that you have an older jdbc driver/jar in yoru tomcat environment - but with debugging set to true, hopefully we can get more info to confirm/deny

              • 4. Re: The connection pool named: |apex|| is not correctly configured, due to the following error(s): oracle.jdbc.pool.OracleDataSource.createConnectionBuilder()Loracle/jdbc/pool/OracleConnectionBuilderImpl;
                avarap1
                Here the output:

                ServiceUnavailableException [statusCode=503, reasons=[The connection pool named: |dev501|| is not correctly configured, due to the following error(s): oracle.jdbc.pool.OracleDataSource.createConnectionBuilder()Loracle/jdbc/pool/OracleConnectionBuilderImpl; ]] at oracle.dbtools.http.errors.ServletResponseExceptionMapper.mapError(ServletResponseExceptionMapper.java:79) at oracle.dbtools.http.errors.ErrorPageRenderer.<init>(ErrorPageRenderer.java:43) at oracle.dbtools.http.errors.ErrorPageRenderer.<init>(ErrorPageRenderer.java:34) at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:113) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.http.secure.ForceHttpsFilter.doFilter(ForceHttpsFilter.java:74) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.http.auth.ForceAuthFilter.doFilter(ForceAuthFilter.java:44) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.http.filters.Filters.filter(Filters.java:67) at oracle.dbtools.http.entrypoint.EntryPoint.service(EntryPoint.java:82) at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:102) at oracle.dbtools.entrypoint.WebApplicationRequestEntryPoint.service(WebApplicationRequestEntryPoint.java:50) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: oracle.dbtools.url.mapping.TargetNotAvailableException: The connection pool named: |dev501|| is not correctly configured, due to the following error(s): oracle.jdbc.pool.OracleDataSource.createConnectionBuilder()Loracle/jdbc/pool/OracleConnectionBuilderImpl; at oracle.dbtools.url.mapping.db.PoolInjector.inject(PoolInjector.java:60) at oracle.dbtools.url.mapping.db.PoolInjector.inject(PoolInjector.java:46) at oracle.dbtools.url.mapping.db.DatabaseURLMappingImpl.injectPLSQLGatewayConnection(DatabaseURLMappingImpl.java:804) at oracle.dbtools.url.mapping.db.DatabaseURLMappingImpl.addServices(DatabaseURLMappingImpl.java:352) at oracle.dbtools.url.mapping.URLMappingBase.doFilter(URLMappingBase.java:79) at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:130) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.http.auth.external.ExternalSessionFilter.doFilter(ExternalSessionFilter.java:59) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.rt.authentication.apex.ApexSessionQueryRewriteFilter.doFilter(ApexSessionQueryRewriteFilter.java:58) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.http.cors.CORSResponseFilter.doFilter(CORSResponseFilter.java:83) at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.http.filters.AbsoluteLocationFilter.doFilter(AbsoluteLocationFilter.java:65) at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:85) ... 35 more Caused by: oracle.dbtools.common.jdbc.ConnectionPoolConfigurationException: The connection pool named: |dev501|| is not correctly configured, due to the following error(s): oracle.jdbc.pool.OracleDataSource.createConnectionBuilder()Loracle/jdbc/pool/OracleConnectionBuilderImpl; at oracle.dbtools.common.jdbc.ConnectionPoolConfigurationException.duplicate(ConnectionPoolConfigurationException.java:50) at oracle.dbtools.common.config.db.DatabasePools.dataSource(DatabasePools.java:86) at oracle.dbtools.common.pools.DataSourceTargetImpl.pool(DataSourceTargetImpl.java:76) at oracle.dbtools.common.pools.DataSourceTargetImpl.dataSourceConnection(DataSourceTargetImpl.java:156) at oracle.dbtools.common.pools.DataSourceTargetImpl.getConnection(DataSourceTargetImpl.java:56) at oracle.dbtools.common.config.db.SchemaConnectionFactoryBase.inject(SchemaConnectionFactoryBase.java:54) at oracle.dbtools.url.mapping.db.PoolInjector.inject(PoolInjector.java:54) ... 55 more Caused by: java.lang.NoSuchMethodError: oracle.jdbc.pool.OracleDataSource.createConnectionBuilder()Loracle/jdbc/pool/OracleConnectionBuilderImpl; at oracle.ucp.jdbc.oracle.OracleDataSourceConnectionFactoryAdapter.createConnection(OracleDataSourceConnectionFactoryAdapter.java:94) at oracle.ucp.common.Database.createPooledConnection(Database.java:256) at oracle.ucp.common.Topology.start(Topology.java:242) at oracle.ucp.common.Core.start(Core.java:2272) at oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:669) at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:129) at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:940) at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1979) at oracle.ucp.jdbc.PoolDataSourceImpl.access$500(PoolDataSourceImpl.java:199) at oracle.ucp.jdbc.PoolDataSourceImpl$30.build(PoolDataSourceImpl.java:4438) at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1935) at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1898) at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1883) at oracle.dbtools.common.config.db.ConfiguredPoolDataSourceImplLoader.load(ConfiguredPoolDataSourceImplLoader.java:162) at oracle.dbtools.common.config.db.ConfiguredPoolDataSourceLoaderImpl.load(ConfiguredPoolDataSourceLoaderImpl.java:16) at oracle.dbtools.common.config.db.RefreshablePoolDataSourceFactory.load(RefreshablePoolDataSourceFactory.java:28) at oracle.dbtools.common.config.db.DatabasePoolLoader.load(DatabasePoolLoader.java:34) at oracle.dbtools.common.config.db.DatabasePoolLoader.load(DatabasePoolLoader.java:7) at oracle.dbtools.common.config.db.ConfiguredPoolDataSourceLoader.load(ConfiguredPoolDataSourceLoader.java:39) at oracle.dbtools.common.config.db.DatabasePoolLoader.load(DatabasePoolLoader.java:42) at oracle.dbtools.common.config.db.DatabasePoolLoader.load(DatabasePoolLoader.java:7) at oracle.dbtools.common.config.db.RefreshablePoolDataSources$PoolFromDataSourceIdentifierLoader.call(RefreshablePoolDataSources.java:144) at oracle.dbtools.common.config.db.RefreshablePoolDataSources$PoolFromDataSourceIdentifierLoader.call(RefreshablePoolDataSources.java:133) at oracle.dbtools.common.functions.Functions$3.get(Functions.java:41) at oracle.dbtools.common.functions.MaybeValidImpl.load(MaybeValidImpl.java:216) at oracle.dbtools.common.functions.MaybeValidImpl.<init>(MaybeValidImpl.java:21) at oracle.dbtools.common.functions.MaybeValidImpl.<init>(MaybeValidImpl.java:15) at oracle.dbtools.common.functions.MaybeValidImpl$LoaderImpl.load(MaybeValidImpl.java:281) at oracle.dbtools.common.functions.MaybeValidCache$MaybeValidCacheLoader.call(MaybeValidCache.java:324) at oracle.dbtools.common.functions.MaybeValidCache$MaybeValidCacheLoader.call(MaybeValidCache.java:313) at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4876) at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3528) at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2277) at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2154) at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2044) at com.google.common.cache.LocalCache.get(LocalCache.java:3952) at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4871) at oracle.dbtools.common.functions.MaybeValidCache.get(MaybeValidCache.java:85) at oracle.dbtools.common.config.db.RefreshablePoolDataSources.pool(RefreshablePoolDataSources.java:69) at oracle.dbtools.common.config.db.DatabasePools.pool(DatabasePools.java:242) at oracle.dbtools.common.config.db.DatabasePools.validity(DatabasePools.java:207) at oracle.dbtools.common.config.db.DataSourceIdentifiers.lambda$validity$0(DataSourceIdentifiers.java:36) at oracle.dbtools.common.functions.MaybeValidImpl.load(MaybeValidImpl.java:216) at oracle.dbtools.common.functions.MaybeValidImpl.<init>(MaybeValidImpl.java:21) at oracle.dbtools.common.functions.MaybeValidImpl.<init>(MaybeValidImpl.java:15) at oracle.dbtools.common.functions.MaybeValidImpl$LoaderImpl.load(MaybeValidImpl.java:281) at oracle.dbtools.common.functions.MaybeValidImpl$LoaderImpl.load(MaybeValidImpl.java:251) at oracle.dbtools.common.config.db.DataSourceIdentifiers.validity(DataSourceIdentifiers.java:53) at oracle.dbtools.common.config.db.DataSourceValidation.startup(DataSourceValidation.java:44) at oracle.dbtools.common.app.PluginLifeCycles.startup(PluginLifeCycles.java:39) at oracle.dbtools.common.app.ApplicationContext.<init>(ApplicationContext.java:83) at oracle.dbtools.common.app.ApplicationContext.<init>(ApplicationContext.java:51) at oracle.dbtools.entrypoint.WebApplicationEntryPoint.contextInitialized(WebApplicationEntryPoint.java:88) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985) at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ... 1 more
                • 5. Re: The connection pool named: |apex|| is not correctly configured, due to the following error(s): oracle.jdbc.pool.OracleDataSource.createConnectionBuilder()Loracle/jdbc/pool/OracleConnectionBuilderImpl;
                  thatJeffSmith-Oracle

                  We think something is 'messed up' in your tomcat deployment.

                   

                  If it's working in standalone, and not working in tomcat, then the issue is the tomcat setup.

                   

                  Did you do anything like open the war file and change out the jdbc driver? Or did you do anything, out of the ordinary when deploying ords to tomcat?

                  • 7. Re: The connection pool named: |apex|| is not correctly configured, due to the following error(s): oracle.jdbc.pool.OracleDataSource.createConnectionBuilder()Loracle/jdbc/pool/OracleConnectionBuilderImpl;
                    avarap1

                    I have tried a clean Tomcat install and it is working, now i need to check which config is impacting the ORDS install.