0 Replies Latest reply on Jun 17, 2020 4:32 PM by user12002718

    java.sql.SQLException: OAUTH marshaling failure

    user12002718

      Hi,

       

      We are using Oracle 11g 11.2.0.1.0 and when we are connecting to our Web application using spring hibernate we are getting this error.

       

      Below is our connection string we are using

      oracle.jdbc.driverClassName=oracle.jdbc.driver.OracleDriver

      oracle.jdbc.url=jdbc:oracle:thin:@10.4.10.87:1521/orcl

      oracle.jdbc.username=cvdms

      oracle.jdbc.password=*******

       

      <props>

      <prop key="hibernate.show_sql">true</prop>

      <prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>

      <prop key="hibernate.id.new_generator_mappings">true</prop>

      <prop key="hibernate.multiTenancy">DATABASE</prop>

      <prop key="hibernate.tenant_identifier_resolver">com.computhink.service.CurrentTenantIdentifierResolverImpl</prop>

      <prop key="hibernate.multi_tenant_connection_provider">com.computhink.service.MultiTenantConnectionProviderImpl</prop>

      </props>

       

      ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

       

      2020-06-12 16:41:32 INFO  - valuesDbDetails [dbEngine=Oracle, dbName=CVDB, dbHost=xxx.xx.xx.xx, dbPort=1521, dbUser=CVDMS, dbPassword=******, roomStatus=true]

      2020-06-12 16:41:32 INFO  - Result in RoomAndLoginDetailsServiceImpl.getDbDetails:::: DbDetails [dbEngine=Oracle, dbName=CVDB, dbHost=xxx.xx.xx.xx, dbPort=1521, dbUser=CVDMS, dbPassword=******, roomStatus=true]

      2020-06-12 16:41:32 INFO  - ==================================END RoomAndLoginDetailsServiceImpl.getDbDetails====================================================

      documentCheckOutDto value to MultiTenantConnectionProviderImpl.selectDataSource() :::: com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> Alliance, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge4waaa1aou7eg1xexr3g|ff317a, idleConnectionTestPeriod -> 0, initialPoolSize -> 16, jdbcUrl -> jdbc:oracle:thin:@xxx.xx.xx.xx:1521:CVDB, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 27000, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]

      ==================================END MultiTenantConnectionProviderImpl.selectDataSource====================================================

      2020-06-12 16:42:01 WARN  - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@10aacac -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:

      java.sql.SQLException: OAUTH marshaling failure

      at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:663)

      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:366)

      at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)

      at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)

      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

      at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)

      at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)

      at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)

      at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)

      at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

      at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

      at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

      at com.mchange.v2.async.ThreadPerTaskAsynchronousRunner$TaskThread.run(ThreadPerTaskAsynchronousRunner.java:255)

      2020-06-12 16:42:01 WARN  - SQL Error: 0, SQLState: null

      2020-06-12 16:42:01 ERROR - Connections could not be acquired from the underlying database!

      2020-06-12 16:42:01 WARN  - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1e2b0ff -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:

      java.sql.SQLException: OAUTH marshaling failure

      at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:663)

      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:366)

      at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)

      at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)

      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

      at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)

      at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)

      at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)

      at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)

      at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

      at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

      at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

      at com.mchange.v2.async.ThreadPerTaskAsynchronousRunner$TaskThread.run(ThreadPerTaskAsynchronousRunner.java:255)

      2020-06-12 16:42:01 WARN  - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@dd9cb2 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:

      java.sql.SQLException: OAUTH marshaling failure

      at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:663)

      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:366)

      at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)

      at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)

      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

      at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)

      at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)

      at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)

      at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)

      at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

      at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

      at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

      at com.mchange.v2.async.ThreadPerTaskAsynchronousRunner$TaskThread.run(ThreadPerTaskAsynchronousRunner.java:255)