Hi,
I am creating an adapter service with select template, with using JOIN condition on two tables, but it is throwing error:
[SIZE=1]
Configuration location: C:/wMWorkspace/.metadata/.plugins/org.eclipse.debug.core/.launches/.launchCould not run ''com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service .AdapterServices:.[ADA.1.316] Cannot execute the SQL statement "SELECT FIELD_ID,FIELD_1_TOT_CNT,FIELD_2_TG_TOT_CNT,LAST_ACTY_DTM,FIELD_3_IND,FIELD_KILL_IND FROM SCHEMA1.TABLE1, SCHEMA2.TABLE2 WHERE (t1.FIELD_ID = t2.FIELD_ID) AND (FIELD_ID = ?) ". "(42703/-206) DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=T1.FIELD_ID, DRIVER=4.3.85(56098/-727) DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-206;42703;T1.UNIVL_PLAN_ID, DRIVER=4.3.85(56098/-727) DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-206;42703;T1.UNIVL_PLAN_ID, DRIVER=4.3.85"DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=T1.UNIVL_PLAN_ID, DRIVER=4.3.85Server error occurred
Launch completed: 2012-08-29 08:24:58.184[/size]
I am using Eclipse SDK
Version: 3.6.1
Build id: M20100909-0800
[SIZE=1]Database IBM DB2
Driver: db2jcc4.jar
Seems that the query is not getting created properly.
It is not appending the table alias in the field name e.g. SELECT t1.FIELD1, t1.FIELD2, t2.FIELD1.
We have applied JDBC_6.5_Fix35 to the JDBC Adapter, but still the problem persist.
Please help!
Thanks in advance!
Regards,
SMM
[/SIZE]