I just dropped the tables, started again CAS so that hibernate could regenerate the tables and now everything is fine.
Thanks. Marat Radchenko wrote: > Such error usually happens when hibernate tries to save null property > into required field. Somehow hibernate thinks that it should convert > null to BINARY. > > 2008/10/24 Jordi Fernandez <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> > > 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] <mailto:[EMAIL PROTECTED]> > > _______________________________________________ > Yale CAS mailing list > [email protected] <mailto:[email protected]> > http://tp.its.yale.edu/mailman/listinfo/cas > > _______________________________________________ Yale CAS mailing list [email protected] http://tp.its.yale.edu/mailman/listinfo/cas
