java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Invalid connection validation SQL statement

Oracle Community | Srivatsa.kashyap | 4 years ago
  1. 0

    OIA 11G-OIM11gR2 integration

    Oracle Community | 4 years ago | Srivatsa.kashyap
    java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Invalid connection validation SQL statement
  2. 0

    "A valid Repository does not exist at the specified connection"

    Oracle Community | 4 years ago | 969237
    java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Invalid connection validation SQL statement
  3. 0

    unable to install odi on windows 7 64 bit

    Oracle Community | 4 years ago | Vik Kumar-Oracle
    java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Invalid connection validation SQL statement
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Camel - Users - Problem with exception handler (onException) on Camel 2.12.X routes.

    nabble.com | 5 months ago
    org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Invalid life cycle state. Check the status of the Universal Connection Pool
  6. 0

    All connections in the universal connection pool are in use

    Oracle Community | 5 years ago | DJ
    java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use

    4 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.ucp.UniversalConnectionPoolException

      Invalid connection validation SQL statement

      at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException()
    2. oracle.ucp.util
      UCPErrorHandler.newUniversalConnectionPoolException
      1. oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:368)
      2. oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:336)
      3. oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:350)
      3 frames
    3. oracle.ucp.jdbc
      PoolDataSourceImpl.startPool
      1. oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:196)
      2. oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:648)
      2 frames
    4. oracle.ucp.util
      UCPErrorHandler.throwSQLException
      1. oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:488)
      2. oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:163)
      2 frames
    5. oracle.ucp.jdbc
      PoolDataSourceImpl.getConnection
      1. oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:654)
      2. oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:922)
      3. oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:873)
      4. oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:863)
      4 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    7. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      3 frames
    8. com.vaau.commons
      DataSourceInterceptor.invoke
      1. com.vaau.commons.springframework.aop.interceptor.DataSourceInterceptor.invoke(DataSourceInterceptor.java:65)
      1 frame
    9. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    10. Unknown
      $Proxy117.getConnection
      1. $Proxy117.getConnection(Unknown Source)
      1 frame
    11. Spring Framework
      TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke
      1. org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
      2. org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210)
      2 frames
    12. Unknown
      $Proxy104.prepareStatement
      1. $Proxy104.prepareStatement(Unknown Source)
      1 frame
    13. com.ibatis.sqlmap
      SqlMapSessionImpl.queryForList
      1. com.ibatis.sqlmap.engine.execution.DefaultSqlExecutor.prepareStatement(DefaultSqlExecutor.java:519)
      2. com.ibatis.sqlmap.engine.execution.DefaultSqlExecutor.executeQuery(DefaultSqlExecutor.java:173)
      3. com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
      4. com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
      5. com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
      6. com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
      7. com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:578)
      8. com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:552)
      9. com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
      9 frames
    14. Spring ORM
      SqlMapClientTemplate.execute
      1. org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:298)
      2. org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
      2 frames