Any advice getting CAS to work with Oracle 12c would be appreciated. I am using the gradle overlay, tomcat 7 and java 7. While trying to let CAS create database tables, I receive: ORA-00902: invalid datatype
This error is the result of hibernate trying to use the types bigint and longvarbinary. create table RegisteredServiceImpl (expression_type VARCHAR(15) DEFAULT 'ant' not null, id bigint not null, access_strategy longvarbinary, attribute_release longvarbinary, description varchar(255) not null, evaluation_order integer not null, logo varchar(255), logout_type integer, logout_url va rchar(255), name varchar(255) not null, proxy_policy longvarbinary, public_key longvarbinary, required_handlers longvarbinary, serviceId varchar(255) not null, theme varchar(255), username_attr longvarbinary, primary key (id)) These are my cas.property settings: svcreg.database.ddl.auto=create svcreg.database.hibernate.dialect=org.hibernate.dialect.Oracle12cDialect # svcreg.database.hibernate.batchSize=10 svcreg.database.driverClass=oracle.jdbc.OracleDriver svcreg.database.url=jdbc:oracle:thin:@csogen1d.uvic.ca:1521:GEN1D svcreg.database.user=rbon svcreg.database.password=password svcreg.database.pool.minSize=5 svcreg.database.pool.maxSize=20 # svcreg.database.pool.maxWait=10000 # svcreg.database.pool.maxIdleTime=120 svcreg.database.pool.acquireIncrement=5 svcreg.database.pool.idleConnectionTestPeriod=0 # svcreg.database.pool.connectionHealthQuery=select 1 svcreg.database.pool.acquireRetryAttempts=30 svcreg.database.pool.acquireRetryDelay=1000 The appropriate oracle driver has been installed. -- Ray Bon Programmer Analyst Development Services, University Systems 2507218831 | CLE C023 | [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/e75f3a33-636d-b638-f213-5537c09756fd%40uvic.ca.
