-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/74958/
-----------------------------------------------------------
Review request for ranger, bhavik patel, Dineshkumar Yadav, Jayendra Parab,
Kishor Gollapalliwar, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Pradeep
Agrawal, Ramesh Mani, Sailaja Polavarapu, Vikas Kumar, and Velmurugan Periasamy.
Bugs: RANGER-4775
https://issues.apache.org/jira/browse/RANGER-4775
Repository: ranger
Description
-------
Ranger KMS is failing with Oracle 23 database with below error.
```
2024-04-01 07:25:27,032 INFO org.apache.hadoop.crypto.key.RangerMasterKey:
Master Key doesn't exist in DB, Generating the Master Key
2024-04-01 07:25:27,169 ERROR org.apache.hadoop.crypto.key.RangerMasterKey:
[ccycloud-1.hchavanor231.root.comops.site-startStop-1]: Error while saving
master key in Database!!!
java.lang.ClassCastException: java.lang.String cannot be cast to java.sql.Clob
at
org.eclipse.persistence.platform.database.oracle.Oracle8Platform.writeLOB(Oracle8Platform.java:194)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at
org.eclipse.persistence.internal.helper.LOBValueWriter.fetchLocatorAndWriteValue(LOBValueWriter.java:94)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processResultSet(DatabaseAccessor.java:758)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:673)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at
org.eclipse.persistence.internal.helper.LOBValueWriter.buildAndExecuteCall(LOBValueWriter.java:79)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at
org.eclipse.persistence.internal.helper.LOBValueWriter.buildAndExecuteSelectCalls(LOBValueWriter.java:190)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.flushSelectCalls(DatabaseAccessor.java:175)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:457)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at
org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:182)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at
org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:197)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at
```
Diffs
-----
kms/src/main/java/org/apache/ranger/entity/XXRangerKeyStore.java 6b541eca5
kms/src/main/java/org/apache/ranger/entity/XXRangerMasterKey.java 64fdd56e4
Diff: https://reviews.apache.org/r/74958/diff/1/
Testing
-------
Successful build with test cases.
Successfully validated with all the supported DB Flavor
Thanks,
Dhaval Shah
