Ma*** about 2 years ago
I am having trouble using JPA to run Teradata queries. I am able to run the generated query in SQL Assistant but not from JPA. Below is the exception.
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=UY_DEV_DATA.EQ_EV_H, DRIVER=3.62.56
equipevent0_.EQ_IN as EQ_INIT_1_13_,
equipevent0_.EV_DT as EVENT_DT2_13_,
equipevent0_.EV_TM as EVENT_TM3_13_,
equipevent0_.EV_TYPE as EVENT_TY4_13_,
equipevent0_.WB_N as WB_SN5_13_,
equipevent0_.CI_NA_19 as CITY_NAM6_13_,
equipevent0_.LO_EY as LOAD_EMP7_13_,
equipevent0_.R_BL_TM_RD as RPT_BLK_8_13_,
equipevent0_.SP as SPLC9_13_,
equipevent0_.ST_PR_IN as STATE_P10_13_,
equipevent0_.TR_B_N as TRANS_W11_13_
equipevent0_.EQ_IN = 'ABCD123456'
and equipevent0_.WB_N = '654654'
The query runs successfully in SQL Assist and the schema.table is valid too.
Can you please help ?