Sorry guys, Naive mistake... the problem is the hibernate.dialect configuration
<!--old--> <prop key="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</prop> <!--new--> <prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop> Thank u for replies, On Thu, Feb 24, 2011 at 11:35 PM, Scott Battaglia <[email protected] > wrote: > 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 > > -- 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
