database connection has been reset (SQL Developer only)
When I attempt to connect to an Oracle 9i database using SQLDeveloper 3.2.09 on Windows 7 32 bit, I get an error message that says "your database connection has been reset. Any pending transactions or session state has been lost". I only get this message when attempting to connect to this particular database and only with the SQL Developer client. Connecting to that same database using sqlplus for example, works fine.
I click OK to the message and it looks like I'm connected fine in the connections browser, but an attempt to look at anything gives a "no more data read from socket Vendor code 17410"
I even tried connecting using different usernames, but that didn't make a difference. My guess is that it has something to do with my computer in particular and the sql developer client is still stuck in the database, but I can't imagine what.
I think this has something to do with me rolling back a transaction and then attempting to kill that session that was rolling back. (not a good idea I know)