Hi!
When I execute an SQL it happens (not sure how to reproduce it in a reliable way unfortunately) that only a part of the table (e.g. the first two rows) update properly. Similar effect when using the horizontal scrollbar. When i then click into the table area, the problem is gone for the particular ResultSet.
Might be a problem of the JDK, but i tried with JDK 1.5 and 1.6 respectively. The effect does show in Windows XP, not in Win2000.
Configuration:
Version: SQuirreL SQL Client Version 2.5
Java: 1.6.0_02-b06
thanx for caring,
klemens
Logged In: NO
Ditto for me... this is really annoying. I'm not a java dev but if someone were to point at the appropriate areas in the code, I'd be willing to take a swing at fixing this.
Win XP SP 2; jdk 1.6.0_02; 2GB RAM w/ > 1GB free; ATI Mobility Radeon X1400
earl
squirrel bug blue at earlh dot jeans com
( take my bluejeans off to email me)
Logged In: YES
user_id=786519
Originator: NO
I see this too, and can reliably reproduce it.
I have a multi-monitor Windows XP setup, with the primary monitor to the right of the secondary monitor (i.e., I assume coordinates on the secondary monitor are negative in the X dimension).
Whenever Squirrel-SQL is on the secondary monitor and zoomed to full-screen (both the application window and the session window), it has big problems updating when I scroll the result set either vertically or horizontally. The rows in the middle of the grid do not get updated.
Scrolling works okay in all cases on the primary monitor, or if Squirrel is on the secondary monitor and is not full-screen.
I have not tried it with the secondary monitor to the right of the primary screen.
WinXP Pro SP2, Squirrel 2.6.1, JRE 1.6.0_03-b05
Logged In: YES
user_id=786519
Originator: NO
More data: it does not appear to be full-screen related.
It appears to be strongly related to the multi-monitor setup and the vertical scroll bar. If all of the session window's vertical scroll bar is on the main monitor it scrolls properly. The moment any part of the vertical scroll bar is on the secondary monitor, it does not scroll properly.
If the session window is larger than the application window, and the session window's vertical scroll bar is not visible (i.e. it is beyond the application window boundaries) then scrolling with a mousewheel works properly. While the application window is on the secondary monitor I can use the application window scroll bars to move the session window one pixel to the left or right, to hide or expose the session window's vertical scroll bar, and that affects whether or not vertical *and horizontal* scrolling of the grid is correct.
Take a look at the scroll bar code...
Logged In: NO
For me it was the same and surfing the net I found this: http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=4763448 which describes exactly the same.... so it seems to be a java bub and not a squirrel bug. Bottom line is that there is a workaround that could work (it did for me): run squirrel like this:
java -Dsun.java2d.noddraw=true -jar squirrel.jar
If you are interestedm in the link above you can find the explanation in the limitations found and its relation to the size of the window being controled java.
I have not seen if this have any side effect, but so far it works for me
Hope this helps,
Manuel