SQLDeveloper is hanging constantly
JosirMay 2 2006 — edited Jun 30 2006Hi folks,
my sqldeveloper is hanging several times a day since I started to use it but I could not find a way to reproduce the problem in order to send to you. Today I could make a reproducible steps:
1) I have to process the same script on several schemas/databases. So I double-click on Connections treeview, select the first schema, the Dialog opens and I click on Connect button. A new SQL Worksheet opened.
2) After that, I select the menu option File / Open and open the script that I want to run. A new SQL Worksheet opened with the script. The script is very simple: it compiles a trigger, does an update followed by a commit.
3) On the Worksheet window, the Connection combobox is correctly empty, so I select the first schema and click on the 'Run script' button (F5). The Script Output shows that everything is ok.
4) Then, I select the second schema (using the Combobox) and click on the 'Run script' button again. The progress bar glimpses and the script is executed on the database. But after that, the IDE hang and CPU Usage goes to 100%. I have to close it on the Windows Task Manager.
WinXP Pro, Java 1.5.0_06
SQLDeveloper 1.0.0.14.67
If you need some other configs, I will be glad to help.
Josir Gomes