Working with tibco application.
Run the tibco application.
Without stopping the tibco program, go to sql prompt and rename the table that application is using. Now, execute query and as expected, we will see the error: "table or view does not exist". (<-- EXPECTED)
Rename the table back and again tibco app queries the table again.
This time, you get the error: java.sql.SQLException:
[tibcosoftwareinc][Oracle JDBC Driver][Oracle]ORA-01003:no statement
parsed
How can I resolve this issue?