oracle.jbo.SQLStmtException & java.sql.SQLException: Invalid column index
Hi,
I am using Jdeveloper 10.1.2.3 and created a ADFBC JSP struts application. I have an entity based viewobject which we have modified, enhance over the years. Some where along this way a bug was introduced in the viewobject that has the following exception
JBO-30003: The application pool (pkgEmpContExp.amEmpContExpSnLocal) failed to checkout an application module due to the following exception:
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.jbo.SQLStmtException, msg=JBO-27122: SQL error during statement preparation. Statement: SELECT statement here
## Detail 0 ##oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation
## Detail 0 ##java.sql.SQLException: Invalid column index
The viewobject query on its own has no indexes. It does have a lot of transient attributes which are populated with Preparestatements and callablestatements.
If you want I can give the whole stacktrace.
This always occurs after we insert into this table and we click on another link. If we clear the browser cache, it works properly.
Can anyone please guide me in resolving this issue.
Thanks in advance