CAS 5.2.x does not support Oracle DB for service registry, specially in case of SAML?

[nilesh choudhary]

We are trying to setup CAS 5.2.x using oracle DB as service registry storage. 

We are not using SAML as of now for CAS Server so it seems to be working fine. 

But cas-management server on start up tries to load some properties from RegexRegisteredService which are way long more that permitted 30 char limit. 

I am afraid this issue might be hit in CAS server as well when we try to use it for SAML. 

Does this mean CAS won't support SAML and cas-management-webapp even without saml is service registry storage is Oracle DB? Any plan to take care of this in coming releases? are there are no work-around present?

Many thanks in advance in case of any replies.

Hibernate sql which is failing when starting cas-management-webapp

select

        abstractre0_.id as id2_0_,

        abstractre0_.access_strategy as access_strategy3_0_,

        abstractre0_.attribute_release as attribute_release4_0_,

        abstractre0_.description as description5_0_,

        abstractre0_.evaluation_order as evaluation_order6_0_,

        abstractre0_.expiration_policy as expiration_policy7_0_,

        abstractre0_.informationUrl as informationUrl8_0_,

        abstractre0_.logo as logo9_0_,

        abstractre0_.logout_type as logout_type10_0_,

        abstractre0_.logout_url as logout_url11_0_,

        abstractre0_.mfa_policy as mfa_policy12_0_,

        abstractre0_.name as name13_0_,

        abstractre0_.privacyUrl as privacyUrl14_0_,

        abstractre0_.proxy_policy as proxy_policy15_0_,

        abstractre0_.public_key as public_key16_0_,

        abstractre0_.required_handlers as required_handlers17_0_,

        abstractre0_.serviceId as serviceId18_0_,

        abstractre0_.theme as theme19_0_,

        abstractre0_.username_attr as username_attr20_0_,

        abstractre0_.bypassApprovalPrompt as bypassApprovalPro21_0_,

        abstractre0_.clientId as clientId22_0_,

        abstractre0_.clientSecret as clientSecret23_0_,

        abstractre0_.generateRefreshToken as generateRefreshTo24_0_,

        abstractre0_.jsonFormat as jsonFormat25_0_,

        abstractre0_.supported_grants as supported_grants26_0_,

        abstractre0_.supported_responses as supported_respons27_0_,

        abstractre0_.DYNAMIC_REG_TIME as DYNAMIC_REG_TIME28_0_,

        abstractre0_.dynamicallyRegistered as dynamicallyRegist29_0_,

        abstractre0_.encryptIdToken as encryptIdToken30_0_,

        abstractre0_.idTokenEncryptionAlg as idTokenEncryption31_0_,

        abstractre0_.idTokenEncryptionEncoding as idTokenEncryption32_0_,

        abstractre0_.implicit as implicit33_0_,

        abstractre0_.jwks as jwks34_0_,

        abstractre0_.scopes as scopes35_0_,

        abstractre0_.sectorIdentifierUri as sectorIdentifierU36_0_,

        abstractre0_.signIdToken as signIdToken37_0_,

        abstractre0_.subjectType as subjectType38_0_,

        abstractre0_.addressingNamespace as addressingNamespa39_0_,

        abstractre0_.appliesTo as appliesTo40_0_,

        abstractre0_.namespace as namespace41_0_,

        abstractre0_.policyNamespace as policyNamespace42_0_,

        abstractre0_.protocol as protocol43_0_,

        abstractre0_.realm as realm44_0_,

        abstractre0_.tokenType as tokenType45_0_,

        abstractre0_.wsdlEndpoint as wsdlEndpoint46_0_,

        abstractre0_.wsdlLocation as wsdlLocation47_0_,

        abstractre0_.wsdlService as wsdlService48_0_,

        abstractre0_.encryptAssertions as encryptAssertions49_0_,

        abstractre0_.metadataCriteriaDirection as metadataCriteriaD50_0_,

        abstractre0_.metadataCriteriaPattern as metadataCriteriaP51_0_,

        abstractre0_.metadataCriteriaRemoveEmptyEntitiesDescriptors as metadataCriteriaR52_0_,

        abstractre0_.metadataCriteriaRemoveRolelessEntityDescriptors as metadataCriteriaR53_0_,

        abstractre0_.metadataCriteriaRoles as metadataCriteriaR54_0_,

        abstractre0_.metadataExpirationDuration as metadataExpiratio55_0_,

        abstractre0_.metadataLocation as metadataLocation56_0_,

        abstractre0_.metadataMaxValidity as metadataMaxValidi57_0_,

        abstractre0_.metadataSignatureLocation as metadataSignature58_0_,

        abstractre0_.nameIdQualifier as nameIdQualifier59_0_,

        abstractre0_.requiredAuthenticationContextClass as requiredAuthentic60_0_,

        abstractre0_.requiredNameIdFormat as requiredNameIdFor61_0_,

        abstractre0_.serviceProviderNameIdQualifier as serviceProviderNa62_0_,

        abstractre0_.signAssertions as signAssertions63_0_,

        abstractre0_.signResponses as signResponses64_0_,

        abstractre0_.signingCredentialType as signingCredential65_0_,

        abstractre0_.skipGeneratingAssertionNameId as skipGeneratingAss66_0_,

        abstractre0_.skipGeneratingSubjectConfirmationInResponseTo as skipGeneratingSub67_0_,

        abstractre0_.skipGeneratingSubjectConfirmationNotBefore as skipGeneratingSub68_0_,

        abstractre0_.skipGeneratingSubjectConfirmationNotOnOrAfter as skipGeneratingSub69_0_,

        abstractre0_.skipGeneratingSubjectConfirmationRecipient as skipGeneratingSub70_0_,

        abstractre0_.expression_type as expression_type1_0_

    from

        RegexRegisteredService abstractre0_