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!

oracle.jbo.SQLStmtException & java.sql.SQLException: Invalid column index

user10264958Apr 30 2012 — edited Apr 30 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 28 2012
Added on Apr 30 2012
1 comment
630 views