Re: SQL Plus tells me it has deleted the row, but it hasn't?

Sorry, but I think you are wrong. If typing exit on the sqlplus command line an implicit commit is done. So the changes are commited. I assume there is a cache used in the servlet, that contains the deleted row. This follows from the fact that querying with sqlplus after exit and reconnect the row is gone but using the servlet (what servlet?) the row is still there.

Regards
Andy

On Tue, 27 Nov 2001 07:28:21 -0800, "Sean Fitzgerald" <sfitzgerald_at_centurytel.net> wrote:

>try typing "commit" after your delete -- you must commit or transaction will
>be rolled back once you leave your session.
>"David" <david.wynter_at_btclick.com> wrote in message
>news:CrLM7.82200$JZ3.231478_at_NewsReader...
>> Hello,
>>
>> I am using 8.1.5 on W2K server. I have a Servlet connected to the database
>> with the same login I am using for SQL Plus, GUI version. I prefer to use
>> the SQL Plus command line version but I ahve never been able to connect to
>> the database because of ORA-12560: TNS:protocol adapter error even thought
>> the servlet is using the same TNS Listener with the same user id through
>> JDBC?
>>
>> I use SQL Plus to delete a row ala
>>
>> <-----------------
>> SQL> select field_name, rw_field_id, record_id from rw_field where
>> field_name like 'New%';
>>
>> FIELD_NAME RW_FIELD_ID RECORD_ID
>> -------------------------------------------------- ----------- ---------
>> New MSCI Industrial Class Code 8993 161
>>
>> SQL> delete from rw_field where rw_field_id = 8993;
>>
>> 1 row deleted.
>>
>> SQL> select field_name, rw_field_id, record_id from rw_field where
>> field_name like 'New%';
>>
>> no rows selected
>>
>> <-----------------
>>
>> I exit Sql Plus and the servlet and restart SQLPlus and the row has gone.
>> But when I restart the servlet and look at the page that has a selector
>for
>> these records that row is still there, but I cannot select it with a
>normal
>> query in SQLPlus. My knowledge of Oracle is limited but this is too weird.
>>
>> Any explanations?
>>
>> Regards
>>
>> David
>>
>>
>
>
Received on Tue Nov 27 2001 - 08:17:12 CST