Oracle incompatibility introduced in xs2a-5.6

dominikseitz commented 4 years ago

Place where bug appeared

de.adorsys.psd2.consent.service.AisConsentServiceInternal.findAndTerminateOldConsentsByNewConsentId(AisConsentServiceInternal.java:220)

Current behavior

SQLException is thrown: SQL Error: 932, SQLState: 42000 ORA-00932: inconsistent datatypes: expected - got BLOB

Expected behavior

no exception should be thrown

Steps to reproduce

run xs2a with Oracle database
add a new AIS consent
add a new AIS consent for the same user and TPP

SCA approach

[ x] Redirect
[ ] Embedded
[ ] Decoupled

XS2A version(s):

5.6

Log files or other additional info

The SQL-query "select distinct c from ais_consent c.." does not work on Oracle because of the added BLOB-Type column "checksum" in liquibase change-set 0091.

See https://hibernate.atlassian.net/browse/HHH-10603 and also https://docs.oracle.com/en/database/oracle/oracle-database/18/adlob/SQL-semantics-and-LOBs.html#GUID-8287AF94-2E69-4BB7-B4EB-0584D10DD144

andriimurashkin commented 4 years ago

@dominikseitz, Thank you for the feedback. This bug will be fixed in upcoming version of XS2A.

andriimurashkin commented 4 years ago

Fixed in XS2A v. 5.7

adorsys / xs2a