ADFBC
EkeDec 1 2008 — edited Dec 4 2008Hi all,
I developed the sample in the link http://www.oracle.com/technology/products/jdev/11/cuecards/adf_set_21/ccset21_ALL.html step by step. But I receive an error when I run the project.
The error I get is :
WARNING: ADFc: Error while selecting entity for Orders
oracle.jbo.DMLException: JBO-26080: Error while selecting entity for Orders
.....
.....
.....
Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
The SQL statement generated is :
SELECT Orders.ORDER_ID,
Orders.ORDER_DATE,
Orders.ORDER_SHIPPED_DATE,
Orders.ORDER_STATUS_CODE,
Orders.ORDER_TOTAL,
Orders.CUSTOMER_ID,
Orders.SHIP_TO_NAME,
Orders.SHIP_TO_ADDRESS_ID,
Orders.SHIP_TO_PHONE_NUMBER,
Orders.SHIPPING_OPTION_ID,
Orders.FREE_SHIPPING_FLAG,
Orders.CUSTOMER_COLLECT_FLAG,
Orders.GIFTWRAP_FLAG,
Orders.GIFTWRAP_MESSAGE
FROM ORDERS Orders