on 09-10-2007 4:22 PM
Hi.
I have a problem to update a row that I obtain from sender JDBC (using SELECT or calling to a FUNCTION).
As the consultation is so complex and the table has fed up transactions, often it takes the registry A and updates register B.
Try to use the level of transaction Serializable (/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter) but it throws the following error to me:
"The JDBC driver returned the following error message: 'java.sql.SQLException: ORA-08177: can't serialize access for this transaction '. For details, contact your database server vendor."
Try to invoke to a function (/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter) but when placing a sentence of UPDATE within the function throws an error, I reviewed to me and calling to a function from a SELECT, Oracle it does not allow to modify registries of the database.
Some other suggestion?
Hi,
See this link,
Here is an example of mapping for synch JDBC.
/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response
/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures
Also go thru these links:
http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes
http://help.sap.com/saphelp_nw2004s/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/frameset.htm
Regards,
Akshay Jamgaonkar.
Reward points if find useful.
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 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.