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

[dparisi]

I have "workarounded" using external blobs

according to JBoss Cms documentation i have changed the



to "true" in the "$JBOSS_HOME/server/default/deploy/jboss-portal.sar/portal-cms.sar/META-INF/jboss-service.xml" file.

look that the documentation is not clearly:
when portal cms switching to blob or complete filesystem storage, we need to delete all file in $JBOSS_HOME/server/default/data/portal/cms folder not just the workspace.xml file.

Now i go to test this solution on cluster configuration.
Bye..:)

[soshah]

Davide-

This issue has been resolved.

See this task for details:http://jira.jboss.com/jira/browse/JBPORTAL-983

What version of JBoss Portal are you running.

Its been fixed in 2.6Beta1 and 2.4.2 final.


Thanks

[dparisi]

Sohil,
thanks for your reply.

we use a jboss-4.0.5.GA installed from jems (portal configuration).

Can you explain me what i need to do to solve the problem?

I have not understood if i need to use jackrabbit 1.1 or not ???

Thanks again.
Davide

[soshah]

Davide-


If you want to give Portal 2.6 a shot:
I would recommend grabbing the 2.6 beta release from here: http://labs.jboss.com/portal/jbossportal/download/index.html

For Portal 2.4:
If you need this immediately,
You can grab the latest code from the 2.4 branch in our subversion repository from
here: svn co http://anonsvn.jboss.org/repos/portal/branches/JBoss_Portal_Branch_2_4

If you can wait a little, a new 2.4 release should be going out soon, which should incorporate this fix.


Thanks