on 06-17-2012 2:56 PM
Hi Guys,
In a JDBC to IDoc XI Interface, the JDBC sender adapter fetches data from an Oracle database successfully, however, it returns the following error when trying to update the data in the database: "java.sql.SQLException:ORA-08177: can't serialize access for this transaction. For details, contact your database server vendor."
The trasaction isolation level in the Advanced tab of the sender JDBC aapter is set to "serializable" and the update SQL statement is a bit complex:
UPDATE dbtable set f1 = 2 where f1 = 0 and (f2, f3 ) in (SELECT * FROM (SELECT DISTINCT f2, f3 FROM dbtable WHERE f1 = 0) WHERE ROWNUM <= 50)
Could you please advise? Thanks.
Set the isolation level to "Read Committed". This is the default for Oracle, and in your case, there is no disadvantage to use that (lower) isolation level. Always use the lowest possible level to avoid unnecessary DB resource usage.
CSY
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Change Trasaction isolation level to Read_commited and try.
But i dont think you need Trsaction isolation level configuration,this configuration required only when you are running parllel trasaction which are dependent.
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.