Application server WAS
Database Oracle 11g
API : java JDBC

I ADD a column(DESC) to a table A in one transaction. After this transaction is completed I fire a query select * from A where 1 =2 and try to get get resultset metdata in another transaction . The newly added column(DESC) is not found in the resulsetmetdata

IF i do the same after 2 minutes then I can find the newly added column.

This column is found immediately if a query is fired directly on sql prompt.

This is not replicated in most of the environments and being encountered only in one environment and looks specific to database or JDBC driver


Any help is appreciated.

Oracle always presents a read consistent view of the database as existed at start of transaction

Thanks for the prompt reply .
The second transaction started only after the first was finished.

>Thanks for the prompt reply .
>The second transaction started only after the first was finished.

If you deem Oracle's behavior to be incorrect, then file a bug report to MOS.