while creating the View object based on sql query (read only access) i got two errors:
1) In the query "select * from suppliers where suppliers.supplier_id = :sid" i am getting
Error: missing in or out parameter at index:1
i don't know whts wrng. however just as a work around i used following query "select * from suppliers where suppliers.supplier_id = ?" and it worked.
2) Error: <Utils><buildFacesMessage> ADF: Adding the following JSF error message: Invalid column index java.sql.SQLException: Invalid column index
Solution: I got this error when i created two bind variables that i used in my query from VO->Query tab. The problem was, for first bind variable i used 1 as bind position. However bind position must start from zero (as per developer's logic :) ).
1) In the query "select * from suppliers where suppliers.supplier_id = :sid" i am getting
Error: missing in or out parameter at index:1
i don't know whts wrng. however just as a work around i used following query "select * from suppliers where suppliers.supplier_id = ?" and it worked.
2) Error: <Utils><buildFacesMessage> ADF: Adding the following JSF error message: Invalid column index java.sql.SQLException: Invalid column index
Solution: I got this error when i created two bind variables that i used in my query from VO->Query tab. The problem was, for first bind variable i used 1 as bind position. However bind position must start from zero (as per developer's logic :) ).
No comments:
Post a Comment