Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Thread Time Out (ORA-2049)

Re: Thread Time Out (ORA-2049)

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 6 Jan 2005 14:30:27 -0800
Message-ID: <1105050627.674848.244680@z14g2000cwz.googlegroups.com>


In Oracle a reader does not block another reader from accessing the same rows unless select for update is used. Is select for update in use? Or have you set Oracle to be serializable?

Most JAVA based environments include an auto-commit feature. Are you sure that the unit of work has been properly set up for this activity?

If home-grown connection pooling is in effect are you sure the rollback is being sent on the same connection as the transaction? HTH -- Mark D Powell -- Received on Thu Jan 06 2005 - 16:30:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US