Oliver, I created an sql script to install into oracle. This was before I realized that the database parameter was incorrect in CAS 4.2.x in cas.properties (https://github.com/apereo/cas/blob/4.2.x/cas-server-webapp/src/main/webapp/WEB-INF/cas.properties). I would suspect that it is the same in 5.x. The fields for dialect and batch size are incorrect. Presently they are:
svcreg.database.hibernate.dialect=org.hibernate.dialect.OracleDialect|MySQLInnoDBDialect|HSQLDialect svcreg.database.hibernate.batchSize=10 but they should be: svcreg.database.dialect=org.hibernate.dialect.OracleDialect|MySQLInnoDBDialect|HSQLDialect svcreg.database.batchSize=10 The result is to fall back to a default dialect (I think HSQL). I have been meaning to submit a ticket for this. Anyway here is the sql: create sequence hibernate_sequence start with 1 increment by 1; create table RegisteredServiceImplProperty ( id number(19, 0) not null, property_values blob, primary key (id) ); create table RegisteredServiceImpl ( id number(19, 0) NOT NULL ENABLE, access_strategy blob, attribute_release blob, bypassApprovalPrompt varchar(255), clientId varchar(255), clientSecret varchar(255), description varchar(255) not null, evaluation_order integer not null, expression_type VARCHAR(15) DEFAULT 'ant' not null, logo varchar(255), logout_type integer, logout_url varchar(255), name varchar(255) not null, proxy_policy blob, public_key blob, required_handlers blob, serviceId varchar(255) not null, theme varchar(255), username_attr blob, primary key (id) ); create table RegisteredServiceImpl_Props ( AbstractRegisteredService_id number(19, 0) not null, properties_id number(19, 0) not null, properties_KEY varchar(255) not null, primary key (AbstractRegisteredService_id, properties_KEY) ); alter table RegisteredServiceImpl_Props add constraint FK_Property foreign key (properties_id) references RegisteredServiceImplProperty; alter table RegisteredServiceImpl_Props add constraint FK_RegisteredServiceImpl foreign key (AbstractRegisteredService_id) references RegisteredServiceImpl; Ray On Mon, 2017-04-24 at 06:39 -0700, Olivier Lamarche wrote: The generated script contains data type that are not compatible with Oracle. Thus, I've got the following error : Failed to initialize pool: ORA-00942: Table ou vue inexistante Here is the generated script to create table : create table RegexRegisteredService (expression_type VARCHAR(15) DEFAULT 'ant' not null, id bigint not null, access_strategy blob(2147483647), attribute_release blob(2147483647), description varchar(255) not null, evaluation_order integer not null, logo varchar(255), logout_type integer, logout_url varchar(255), mfa_policy blob(2147483647), name varchar(255) not null, proxy_policy blob(2147483647), public_key blob(2147483647), required_handlers blob(2147483647), serviceId varchar(255) not null, theme varchar(255), username_attr blob(2147483647), bypassApprovalPrompt boolean, clientId varchar(255), clientSecret varchar(255), generateRefreshToken boolean, jsonFormat boolean, encryptAssertions boolean, metadataCriteriaDirection varchar(255), mcp varchar(255), mcreed boolean, mcrred boolean, metadataCriteriaRoles varchar(255), metadataLocation varchar(255), metadataMaxValidity bigint, msl varchar(255), racc varchar(255), requiredNameIdFormat varchar(255), signAssertions boolean, signResponses boolean, primary key (id)) According to this website : https://www.techonthenet.com/oracle/datatypes.php 1. bigint is not a valid data type 2. boolean is not a valid data type -- Ray Bon Programmer analyst Development Services, University Systems 2507128831 | CLE 023 | [email protected] -- - CAS gitter chatroom: https://gitter.im/apereo/cas - CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html - CAS documentation website: https://apereo.github.io/cas - CAS project website: https://github.com/apereo/cas --- You received this message because you are subscribed to the Google Groups "CAS Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/1493054587.25318.2.camel%40uvic.ca.
