Java Development Tools

I wanted to share a recent challenge I encountered. I had created a transient attribute in my View Object and placed it on my .jspx page. When I would navigate to the page I would receive an error telling me, "oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 42 with java object of type java.lang.String due to java.sql.SQLException.".

After switching my run configuration to include the java option -Djbo.debugoutput = console, I noticed my sql statement was getting modified. I inspected the view object sql and realized the calculation for my transient object was not present. After adding the calculation for the column in my sql, I was able to run the page with no errors.

My problem was that I had my query in expert mode so I could utilize an outer join. When I added the transient attribute after putting the query in expert mode, JDEV would not automatically make the changes to my SQL.

It would really help if JDEV threw an alert to the user letting them know that their query is in expert mode and changes cannot be made to the SQL or it would also help if I remembered what I read in the Dev Guide. Such as when a file is read only.

(JDEV 10.1.3.4)