4 Replies Latest reply on Mar 23, 2007 9:29 AM by Sohil Shah

    portal cms and oracle db error

    Davide Parisi Newbie

      Hy,
      I have a problem with jboss portal cms working with oracle (9.2) database.

      when i try to upload a file larger than 70kb to cms the sistem crash with the following errors:

      09:13:45,902 WARN [JDBCExceptionReporter] SQL Error: 17002, SQLState: null
      09:13:45,902 ERROR [JDBCExceptionReporter] Eccezione IO: Read error
      09:13:45,902 WARN [JDBCExceptionReporter] SQL Error: 17002, SQLState: null
      09:13:45,902 ERROR [JDBCExceptionReporter] Eccezione IO: Read error
      09:13:45,902 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
      org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
      at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
      at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
      at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
      at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)

      I have tried with the last jdbc (10 r2) driver for Oracle.
      Can anyone help me?
      I can use HSQLD on production environment?
      Can i "workaround" using the cms on filesystem?

      thanks at all.
      Davide