[jboss-user] [JBoss Portal] - portal cms and oracle db error

[dparisi]

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

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4030494#4030494

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4030494