I'm using JpaTicketRegistry against an Oracle 10g database. Everything is
fine until cas tries to insert a TicketGrantingTicket:
**********************************************
[SSO] - [24-10-08 16:09:04] - 35710 DEBUG
org.jasig.cas.authentication.principal.UsernamePasswordCredentialsToPrincipalResolver
- Creating SimplePrincipal for [MJCA]
Hibernate: insert into TICKETGRANTINGTICKET (NUMBER_OF_TIMES_USED,
CREATION_TIME, EXPIRATION_POLICY, LAST_TIME_USED, PREVIOUS_LAST_TIME_USED,
ticketGrantingTicket_ID, AUTHENTICATIO
N, EXPIRED, SERVICES_GRANTED_ACCESS_TO, ID) values (?, ?, ?, ?, ?, ?, ?,
?, ?, ?)
[SSO] - [24-10-08 16:09:04] - 36038 WARN
org.hibernate.util.JDBCExceptionReporter - SQL Error: 932, SQLState:
42000
[SSO] - [24-10-08 16:09:04] - 36038 ERROR
org.hibernate.util.JDBCExceptionReporter - ORA-00932: tipos de dato
inconsistentes: se esperaba BINARY se ha obtenido NUMBER
[SSO] - [24-10-08 16:09:04] - 36053 WARN
org.hibernate.util.JDBCExceptionReporter - SQL Error: 932, SQLState:
42000
[SSO] - [24-10-08 16:09:04] - 36053 ERROR
org.hibernate.util.JDBCExceptionReporter - ORA-00932: tipos de dato
inconsistentes: se esperaba BINARY se ha obtenido NUMBER
[SSO] - [24-10-08 16:09:04] - 36053 ERROR
org.hibernate.event.def.AbstractFlushingEventListener - Could not
synchronize database state with session
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch
update
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
************************************
According to Oracle, Binary was expected but Number was obtained. The BLOB
columns that get created in the TICKETGRANTINGTICKET table where
EXPIRATION_POLICY, AUTHENTICATION and SERVICES_GRANTED_ACCESS_TO.
Any clues?
--
Jordi Fernandez
[EMAIL PROTECTED]
_______________________________________________
Yale CAS mailing list
[email protected]
http://tp.its.yale.edu/mailman/listinfo/cas
