Just for the record and for the convenience of giving you ideas and giving the maintainers facts:
We are mostly good with an ORA 11, but using the Oracle 10g dialect (I don't know why 10g and if this matters for something). Our data types for registeredserviceimpl and abstractregisteredservice, directly from SQL Developer: ID NUMBER(19,0) ALLOWEDTOPROXY NUMBER(1,0) ANONYMOUSACCESS NUMBER(1,0) DESCRIPTION VARCHAR2(255 CHAR) ENABLED NUMBER(1,0) EVALUATION_ORDER NUMBER(10,0) IGNOREATTRIBUTES NUMBER(1,0) NAME VARCHAR2(255 CHAR) SERVICEID VARCHAR2(255 CHAR) SSOENABLED NUMBER(1,0) THEME VARCHAR2(255 CHAR) USERNAME_ATTR VARCHAR2(256 BYTE) EXPRESSION_TYPE VARCHAR2(15 BYTE) The difference in the schema width I guess it is because we are stick to 3 yet. I suspect the dialect is not being recognized and hibernate is falling back to some SQL default that is not a previous ORA version, because I don't think (but don't know for sure) ORA understands LONGVARBINARY. If you are bootstrapping a new install instead of upgrading a system, I'd try other previous Oracle dialects, if after a time no other pronouncement is made from the maintainers. Makes me scratch my head CAS 4 being asking for registeredserviceimpl. We were at 3.4.10 using registeredserviceimpl but had to create an abstractregisteredservice view for it in order to upgrade to 3.6.0. At that moment I thought abstractregisteredservice was actually supposed to be a renaming of registeredserviceimpl. Uxío Prego Madiva Soluciones Cl / Serrano Galvache 56 E Abedul 4 28033 Madrid 917 56 84 94 www.madiva.com The activity of email inboxes can be systematically tracked by colleagues, business partners and third parties. Turn off automatic loading of images to hamper it. 2016-12-13 2:43 GMT+01:00 Ray Bon <[email protected]>: > 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 > . > -- - 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/CANidDKYebGjjsJutpXOPyG1dRpktu_qBZYOZs6NwGMP%3DjuMCBg%40mail.gmail.com.
