Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

java.sql.SQLException: Invalid column index while updating on the viewobject.

User_UM8AVDec 27 2017 — edited Dec 30 2017

Dears

I have viewobject based on entityobject and I used this viewobject on my JSF page

when I create new row and commit to the database it work successfully but when I edit any attribute of this

row and press commit button I get the following error :

Exception type is SQL Exception

<oracle.adf.view> <Utils> <buildFacesMessage> <ADF: Adding the following JSF error message: Invalid column index>

java.sql.SQLException: Invalid column index

Kindly note that I checked "Calculate Optimized Query at Runtime" in the view object and all attribute mapped successfully as on the query. and I'm using JDeveloper 12.2.1.2

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 27 2018
Added on Dec 27 2017
7 comments
2,114 views