Timeout problem with long running queries

[Blumreiter, Fa. Westernacher, IIPS, B]

Hi,

I have got a serious problem: when long-running queries are being executed I get 
strange error message from jonas:

XAResource ---> rollback: XA START without XA END
WARNING: Connection not closed by caller
Force a physical close to avoid reusing it in another transaction
Cannot resolve XAC => PoolItem
Cannot set transaction as rollback only

After that a SQLException is thrown:

java.sql.SQLException: Must be logged on to server

java.sql.SQLException: Must be logged on to server
        at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:456)
        at oracle.jdbc.ttc7.TTC7Protocol.closeQuery(TTC7Protocol.java:378)
        at oracle.jdbc.driver.OracleResultSet.internal_close(OracleResultSet.java:145)
        at oracle.jdbc.driver.OracleResultSet.next(OracleResultSet.java:81)
        at 
dpag.ass.application.dispatcher.DispatcherBean.dispatch(DispatcherBean.java:218)
        at 
dpag.ass.application.dispatcher.JOnASdispatcherRemote.dispatch(classes\dpag\ass\application\dispatcher\JOnASdispatcherRemote.java:55)
        at 
dpag.ass.application.dispatcher.JOnASdispatcherRemote_Skel.dispatch(classes\dpag\ass\application\dispatcher\JOnASdispatcherRemote_Skel.java:47)
        at sun.rmi.server.UnicastServerRef.oldDispatch(UnicastServerRef.java:319)
        at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:187)
        at sun.rmi.transport.Transport$1.run(Transport.java:142)
        at java.security.AccessController.doPrivileged(Native Method)
        at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
        at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
        at 
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
        at java.lang.Thread.run(Thread.java:484)
doPostInvoke: Rolling back transaction

Obviously, the query hasn't finished yet when the connection is destroyed...

Are there any timeout parameters to configure?
Or does it look like a bug?


Thanks a lot 

Torsten


----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".