Hi guys, I'm trying to migrate my old PostgreSQL database to a new Oracle database, but have found some difficulties below... Has anyone had any similar problem?
(Restriction: Can not generate the schema by hibernate) ---ORACLE SQL DDL ---: CREATE TABLE TICKETGRANTINGTICKET (SERVICES_GRANTED_ACCESS_TO BLOB NOT NULL ,EXPIRED NUMBER(1) NOT NULL ,AUTHENTICATION BLOB NOT NULL ,LAST_TIME_USED TIMESTAMP ,EXPIRATION_POLICY BLOB NOT NULL ,ID VARCHAR2(255) NOT NULL ,TICKETGRANTINGTICKET_ID VARCHAR2(255) NOT NULL ,CREATION_TIME TIMESTAMP ,PREVIOUS_LAST_TIME_USED TIMESTAMP ,NUMBER_OF_TIMES_USED TIMESTAMP ) / After login error: org.springframework.webflow.execution.ActionExecutionException: Exception thrown executing br.gov.dataprev.infra.security.cas.web.flow.X509CertificateCredentialsWithMessageNonInteractiveAction@1e2edadin state 'startAuthenticate' of flow 'login' -- action execution attributes were 'map[[empty]]' org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:60) org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:77) org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [insert into TICKETGRANTINGTICKET (EXPIRATION_POLICY, ticketGrantingTicket_ID, LAST_TIME_USED, PREVIOUS_LAST_TIME_USED, CREATION_TIME, NUMBER_OF_TIMES_USED, AUTHENTICATION, EXPIRED, SERVICES_GRANTED_ACCESS_TO, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [null]; error code [0]; could not insert: [org.jasig.cas.ticket.TicketGrantingTicketImpl]; nested exception is org.hibernate.exception.GenericJDBCException: could not insert: [org.jasig.cas.ticket.TicketGrantingTicketImpl] org.hibernate.exception.GenericJDBCException: could not insert: [org.jasig.cas.ticket.TicketGrantingTicketImpl] org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) org.jboss.util.NestedSQLException: Error; - nested throwable: (java.lang.ClassCastException: org.hibernate.lob.BlobImpl cannot be cast to oracle.sql.BLOB) org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:873) java.lang.ClassCastException: org.hibernate.lob.BlobImpl cannot be cast to oracle.sql.BLOB oracle.jdbc.driver.OraclePreparedStatement.setBlob(OraclePreparedStatement.java:6859) Cheers, Yuri Feitosa Negócio -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
