cancel
Showing results for 
Search instead for 
Did you mean: 

Sender JDBC with Stored Procedure or Function

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Thank's Akshay

But my problem it's with JDBC sender. I configure scenary JDBC receiver with SQL and Stored Procedures.

Regards.