Sender JDBC

[mf_haq]

Hello Friends,

I am getting below error while sending data from DB table (JDBC to PROXY). Please suggest me.

***Database-level error reported by JDBC driver while executing statement 'SELECT * FROM POP_MAT_REAPP_T;'. The JDBC driver returned the following error message: 'java.sql.SQLException: ORA-00911: invalid character '. For details, contact your database server vendor.***

Thaks in Advance,

MFH

[Former Member · Accepted solution]

Hi Haq,

It seems that in your jdbc sender communicaiton cahnel for Query sql statment you are uisng an invalid cahracter. I see a semicolon after teh select statemnet. Remove that and activate it once again and rerun.

Regadrs,

---Satish

[mf_haq · Accepted solution]

Hi SR,

Select query problem solved, thanks for that....

Getting problem in UPDATE query:

Database-level error reported by JDBC driver while executing statement 'UPDATE MSEG SET MATNR= ( SELECT * FROM POP_MAT_REAPP_T WHERE MATERIAL_CODE= MATNR )'. The JDBC driver returned the following error message: 'java.sql.SQLException: ORA-00942: table or view does not exist '. For details, contact your database server vendor.

With Regards,

MFH

[Former Member · Accepted solution]

Hi Haq,

Your update statement is wrong. Can you tell what you are trying to do so that somebody here will give you the update statement.

Regards,

---Satish

[Former Member · Accepted solution]

MSEG is an standard SAP table. It is updated when we do transaction postings via MIGO, MB51 etc.

Directly updating the table is firstly highly discouraged as you loose SAP customer support plus in this query you are trying to update a table KEY which is not technically possible in any case.

[mf_haq · Accepted solution]

Hi SR,

1. Fetching data from DB (ABCD) table using JDBC adapter

2. Needs to be send the data to SAP tables (MSEG and MKPF) using PROXY

Regards,

MFH

[Former Member · Accepted solution]

    UPDATE MSEG SET MATNR= ( SELECT * FROM POP_MAT_REAPP_T WHERE MATERIAL_CODE= MATNR )'. 

Change the sentence no use Select * from...becuase your are getting all field of your table POP_MAT_REAPP only choose one field.

[Former Member · Accepted solution]

Hi Haq,

1. Fetching data from DB (ABCD) table using JDBC adapter

You dont need an update statement here. For only fetching a select statment only is needed. If this is what you want then you dont need an update statement. In update statment pu <TEST> and it should work.

2. Needs to be send the data to SAP tables (MSEG and MKPF) using PROXY

Once you send data to proxy this logic needs to be written within the proxy.

Regards,

---Satish

[mf_haq · Accepted solution]

Hi Friends,

While Testing scenario in ID---->test configuration, I am getting below errors and remaing are fine. please suggest on this

1. Sender Agreement

FYI.......sender agreement and receiver determination deleted and created freshly even through no change in error.

With Regards,

MFH

Edited by: MF Haq on Mar 8, 2010 4:55 AM

Edited by: MF Haq on Mar 8, 2010 6:43 AM

[Former Member]

Hi

Remove ";" at the end of the sentence. I know Oracle works with this characters at the end in PLSql.