Re: why do JDBC queries only recognize data populated by JDBC and not through SQLPlus*Worsheet?

If your doing this back to back, look at the auto commit configuration for both tools. JDBC usually defaults to auto commit, and you may be trying to see an uncommitted transaction.

Slim wrote:

> I execute the query:
>
> select * from <table>
>
> SQL worksheet returns:
>
> ANN_ID ANN_NAME ANN_DESC
> ANN_EMAIL
> --------- ------------------------------ ------------------------------ ----
> ------
> 1 tic tac toe
> 2 a b c
> 3 x y z
> 4 f g h
> 10 f g h
>
> JDBC returns:
>
> ANN_ID ANN_NAME ANN_DESC
> ANN_EMAIL
> --------- ------------------------------ ------------------------------ ----
> ------
> 10 f g h
>
> ann_id 10 was inserted using JDBC, ann_id 1-4 were inserted using SQL
> worksheet.
>
> why does this happen?
>
> slim.
Received on Thu Feb 17 2000 - 00:00:00 CST