CAS 4.2.6 oracle invalid data type

[Ray Bon]

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 | rb...@uvic.ca

[Uxío Prego]

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.

--
- 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 cas-user+unsubscribe@apereo.org.
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.