Two SQL Worksheets use same connection. THIS IS A CRITICAL PROBLEM
419978Apr 4 2006 — edited Apr 4 2006Client OS Windows XP
SQL Developer 1467
Oracle 10G on Windows 2003
Open two SQL Worksheet on one database user and put both of these statements as below.
-- Statement 1 in first worksheet
UPDATE ADDRESS
SET STREET1 = 'TEST'
WHERE ADDRESS_ID = 1
-- Statement 2 in second worksheet
SELECT STREET1
FROM ADDRESS
WHERE ADDRESS_ID = 1
run statement 1 in the first worksheet. Do not commit. Run the query in the second worksheet. The modified data is seen in the second worksheet. I think when we open the second worksheet, a new connection is created, but the second worksheet still uses the first connection. Can someone look at it please.
I have tried this on Oracle 9i also. The same problem exists.
More over, even if I close all worksheets and I Right Click -> Disconnect in the Connections window, all connections are not closed. Some of the connections still remain. If I go back to connect and than open worksheets, the connectins keep increasing and never get closed.
-Nags