Couple of Sql Developer quality of life things.
1) Reports Autorefresh steals focus.
There are times I would like to have a report refreshing occasionally on my second
monitor this is impossible with SQL Developer stealing the focus when the report refreshes.
2) Mouse scroll wheel does not seem to work anywhere that there is a drop down list of connections.
3) When running a report as a script the output appears to be run through the same formatter that the
editor uses. Don't think this is needed.
4) reports of type script seem to be padded with spaces.
I have a select statement in a child report (type script) that generates sql commands that I can then
cut and paste into SQL*Plus to run. Those commands get padded with spaces on the right to such
a length that they exceed the length that SQL*Plus can handle on one line. Below is one example
but I have others some are shorter than others and they cut and paste fine. I am not sure what decides
the padding on the report.
I run this select as the query in the child.
select 'var output_number number;
print :output_number;' Command from dual;
Which produces this output when executed. Not sure if it will come through the forums but each
line is padded out to ~265 characters after being cut and paste from SQL*Developer. My version
of SQL*Plus seems to have a 258 character limit for one line. I left the below exactly the
way the paste happened. It should look more like the above.
var output_number number;
The first line 'var output_number number' is the only thing displayed (across 2 lines )
and my cursor gets stuck until I CTRL-C. Like I mentioned above this seems to be a
SQL*Plus issue on my platform but I still think developer should not pad with that
If I paste it into notepad first and trim all the spaces from the end I am able to then
copy from notepad and paste into SQL*Plus.
I'm unable to reproduce SQL Developer 'stealing' focus on a reports refresh on v4 or 3.2 in Windows 7 or on XP. In fact, Windows supposedly 'forbids' this behavior.
I do see this happening on OEL, but Linux allows such things, although I think there may be a property or preferences somewhere you can disable this.
Maybe it is not SQL Developer itself however here are the steps that I can reproduce it.
Open a report in Developer and set it to refresh every 5 seconds.
Open notepad on my other monitor and start typing random characters.
When the report refreshes I lose focus on notepad but it does not appear that SQL Developer gets that focus more like I just lose the focus on the current window. Wonder if its task bar related and not directly SQL Developer causing it.
Just checked the SQL Developer window does get the focus. The title bar changes like its active.
Thanks for taking the time to reply.