Home » Other » General » ORA-08177 error message(since upgrade to Oracle 9i database).
ORA-08177 error message(since upgrade to Oracle 9i database). [message #103823] Mon, 29 March 2004 09:24 Go to next message
MK
Messages: 31
Registered: June 2001
Member
Hi,

When two simultaneous transactions tries to insert rows and update the respective rows, error message "ORA-08177: can't serialize access for this transaction" is thrown (Application is writen in simple java code which uses the websphere datasource connection to connect to the Oracle DB ) .

We have been experiencing this problem since upgrade of Database to Oracle 9i ( from Oracle 8i version). We use 8i thin client to talk to Oracle 9i Database.

Can any one help on this ?

Thanks

MK. 

 

Report message to a moderator

Re: ORA-08177 error message(since upgrade to Oracle 9i database). [message #103824 is a reply to message #103823] Mon, 29 March 2004 20:07 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

What is your INIT.ORA parameter value for "serializable"? Oracle should only serialize transactions when serializable is set to TRUE.

BTW: If you must use serializable transactions, the application needs to be coded to handle the ORA-8177 errors.

Best regards.

Frank

Report message to a moderator

Previous Topic: help for ORA-07445
Next Topic: can we customize the calender in Oracle?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 23:59:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.