Error while usinjg the JDBC to ABAP Proxy Scenario

[Former Member]

Hello Rocks,

This is my scenario like JDBC --- Pi --- ABAP Proxy

while i am given a sender side jdbc XSD structure is like this

VWENTITYAGGREMENT

Row 1-unbound occurence

POOL_ID 0-1 occurence

CUST_ID

AGREEMENT

PRODUCT_ID

CONTRACT_TYPE

CONTRACT_TYPE_DESCR

AGRMNT_STATUS

STATUS_DESCR

EFFDT

TERMINATION_DT

ADD_DT

ADD_TM

while i am writing a select query in Sender JDBC CC is like this

SELECT POOL_ID,CUST_ID,AGREEMENT,PRODUCT_ID,CONTRACT_TYPE,CONTRACT_TYPE_DESCR,AGRMNT_STATUS,STATUS_DESCR,EFFDT,TERMINATION_DT,ADD_DT,ADD_TM FROM vwEntityAgreement.

Here i am getting this Error message like this :

Error Description: Database-level error reported by JDBC driver while executing statement 'SELECT POOL_ID,CUST_ID,AGREEMENT,PRODUCT_ID,CONTRACT_TYPE,CONTRACT_TYPE_DESCR,AGRMNT_STATUS,STATUS_DESCR,EFFDT,TERMINATION_DT,ADD_DT,ADD_TM FROM vwEntityAgreement'. The JDBC driver returned the following error message: 'com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'POOL_ID'.'. For details, contact your database server vendor.

So please give me your valuable inputs !

Regards,

Ravi.

[former_member200962 · Accepted solution]

Invalid column name 'POOL_ID'.'. For details, contact your database server vendor.

Did you confirmed the name POOL_ID as suggested?

Why is the tablename different (check the case) in the query that you make and in the XSD structure that you mentioned......check if this is causing the problem.

Regards,

Abhishek.

Edited by: abhishek salvi on Jun 4, 2010 10:24 AM

[Former Member · Accepted solution]

Hello Abhi,

Thanks for your help now my problem is solved . I am given a wrong database structure in ESR , now is solved.

Thanks a lot !

Regards,

Ravi.