JBOSS Errors

[padmal]

Hi all,
My system run on jboss-3.0.6. O/S is solaris and database is oracle 9i2.
To get reports we are using crystal clear report genarator and i-net report engine

We are get following erros

2003-08-11 09:44:16,104 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackException, causedBy:
java.lang.RuntimeException: Transaction marked for rollback, possibly a timeout


2003-08-11 10:15:35,677 ERROR [STDERR] java.sql.SQLException: Protocol violation

2003-08-11 10:15:35,716 ERROR [STDERR] Report Error: [0] getPageData failed Transaction marked for rollback, possibly a timeout; nested exception is:
java.lang.RuntimeException: Transaction marked for rollback, possibly a timeout

2003-08-11 10:24:32,888 ERROR [org.jboss.security.auth.spi.DatabaseServerLoginModule] Query failed
java.sql.SQLException: Bigger type length than Maximum

2003-08-11 10:40:56,722 ERROR [org.jboss.security.auth.spi.DatabaseServerLoginModule] Query failed
java.sql.SQLException: Refcursor value is invalid


What is the problem in my jboss application server configuration? Anybody can help me

[juhalindfors]

How long does it take to generate the report? The default tx timeout is set to 300 seconds. If you're doing your reporting in a tx and its not done in 5 minutes it will timeout and roll back.

-- Juha