Java Database Connectivity (JDBC)

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!

java.sql.SQLException: OAUTH marshaling failure

user12002718Jun 15 2020 — edited Jun 24 2020

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.dialect">org.hibernate.dialect.Oracle10gDialect</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: