I found the issue : it's seem to be a bug in 10.1... oracle jdbc driver. Udate to 10.2.0... solved the problem.
Le lundi 14 novembre 2011 17:06:55, Laurent Cathala a écrit : > Hi, > I'm on an Nuxeo 5.3.1 with Oracle 10 database. When i create a new document > with large file, i got an Oracle error : > Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: > org.nuxeo.ecm.core.storage.StorageException. message: Could not update: > UPDATE "FULLTEXT" SET "BINARYTEXT" = ? WHERE "ID" = ? > at > org.nuxeo.ecm.core.storage.sql.Mapper.updateSingleRow(Mapper.java:1434) > at org.nuxeo.ecm.core.storage.sql.Context.save(Context.java:521) > at > org.nuxeo.ecm.core.storage.sql.PersistenceContext.save(PersistenceContext.java:322) > at > org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:223) > at > org.nuxeo.ecm.core.storage.sql.SessionImpl.save(SessionImpl.java:208) > at > org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.save(ConnectionImpl.java:158) > at > org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.save(SQLSession.java:135) > ... 43 more > Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: > java.sql.SQLException. message: setString can only process strings of less > than 32766 chararacters > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227) > at > oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:4746) > at > oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:4717) > at > org.nuxeo.ecm.core.storage.sql.db.dialect.DialectOracle.setToPreparedStatement(DialectOracle.java:195) > at > org.nuxeo.ecm.core.storage.sql.db.Column.setToPreparedStatement(Column.java:227) > at > org.nuxeo.ecm.core.storage.sql.Mapper.updateSingleRow(Mapper.java:1425) > > I think i've made a configuration error ? > Any idea ? > > Thanks, > > Laurent > --- > Mailing list: [email protected] > Forum: http://forum.nuxeo.org/f/1/ > > --- Mailing list: [email protected] Forum: http://forum.nuxeo.org/f/1/
