Even if you can't use the schema, how does your DDL and the Hibernate-generated DDL differ?
On Thu, Feb 24, 2011 at 4:40 PM, Yuri Negocio Negocio <[email protected]>wrote: > 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 > > -- 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
