Re: Cannot browse object tree nodes

Robert Manning wrote, On 10/19/06 03:43:
> On 10/18/06, Lars Heill <Lars.Heill@xxxxxxx> wrote:
>> Lars Heill wrote:
...
>>> Only I do not see any of my tables or views in the various
>>> schemas, just a generic
>>>
>>>  <alias>
>>>    <schema>
>>>      SYSTEM TABLE
>>>      TABLE
>>>      VIEW
>>>      UDT
>>>
>>> Refreshing "Tree and Cache" or "Item", I see my table names
>>> flash by on the status line, but no tables/views show up in
>>> the object tree.
> 
> DatabaseMetaData is used to build the object tree.  supportsSchemas or
> supportsCatalogs need to return true.  Beyond that getTables needs to return
> the tables for the selected schema/catalog.
> 
>> In case it matters: it is a JDBC 3.0 driver, and the database
>> has 72 schemas.
> 
> I believe I've seen this issue with SQLBase in the past due to an incomplete
> driver implementation.  What database and driver are you using?  Any 
> exceptions
> in the log?

Thanks Rob,

I have done some more checking, and it turns out it is not a problem
with my database or driver (Sun HADB), as everything works nicely in
StarOffice 8 and in SQuirreL 2.2 final.

Below are snippets from my attempts with SQuirreL 2.3 final (which I
tried on both Windows XP pro and Solaris 10 x86), showing some exceptions
I get whenever I try to browse a TABLE or VIEW object:

  * GUI work done in wrong thread
  * GUI Thread is doing database work

Is this a known issue?  - with a known workaround?

I am happy with 2.2 final for now, though :)  Snappy little thing!

Regards,
Lars


--- BEGIN log snippets ----------------------------------------------------
0    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
No logger configuration file passed on command line arguments. Using default 
log file: /home/xxx/.squirrel-sql/logs/squirrel-sql.log
2    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
#############################################################################################################
4    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
# Starting SQuirreL SQL Client Version 2.3 final at 10/19/06 1:23 PM
4    [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
#############################################################################################################
10   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
SQuirreL SQL Client Version 2.3 final started: Thu Oct 19 13:23:27 CEST 2006
11   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
Copyright (c) 2001-2006 
Colin Bell, Gerd Wagner, Rob Manning and others
11   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
java.vendor: Sun Microsystems Inc.
11   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
java.version: 1.5.0_07
11   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
java.runtime.name: Java(TM) 2 Runtime Environment, Standard Edition
11   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
os.name: SunOS
18   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
os.version: 5.10
18   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
os.arch: x86
18   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
user.dir: /home/xxx
18   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
user.home: /home/xxx
18   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
java.home: /usr/jdk/instances/jdk1.5.0/jre
18   [main] INFO  net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory  - 
java.class.path: /home/xxx/opt/SQuirreL/squirrel-sql.jar
144  [main] DEBUG net.sourceforge.squirrel_sql.fw.util.ProxyHandler  - Not 
using HTTP proxy
505  [main] DEBUG net.sourceforge.squirrel_sql.fw.util.Resources  - No resource 
found for 
action.net.sourceforge.squirrel_sql.client.mainframe.action.AboutAction : image
515  [main] DEBUG net.sourceforge.squirrel_sql.fw.util.Resources  - No resource 
found for 
action.net.sourceforge.squirrel_sql.client.session.action.ToolsPopupAction : 
image

...etc...

95118 [AWT-EventQueue-1] DEBUG 
net.sourceforge.squirrel_sql.fw.util.TaskThreadPool  - Creating thread nbr: 1
95124 [Thread-3] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool  - 
Returning thread. 1 threads available
95124 [Thread-3] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool  - 
Using a thread. 0 threads available
95747 [Thread-3] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool  - 
Creating thread nbr: 2
95748 [Thread-4] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool  - 
Returning thread. 1 threads available
95761 [Thread-4] DEBUG net.sourceforge.squirrel_sql.fw.util.TaskThreadPool  - 
Using a thread. 0 threads available
95766 [Thread-3] DEBUG 
net.sourceforge.squirrel_sql.client.gui.util.ThreadCheckingRepaintManager  - 
GUI work done in wrong thread
java.lang.Exception: GUI work done in wrong thread
        at 
net.sourceforge.squirrel_sql.client.gui.util.ThreadCheckingRepaintManager.checkThread(ThreadCheckingRepaintManager.java:48)
        at 
net.sourceforge.squirrel_sql.client.gui.util.ThreadCheckingRepaintManager.addDirtyRegion(ThreadCheckingRepaintManager.java:59)
        at javax.swing.JComponent.repaint(JComponent.java:4518)
        at java.awt.Component.repaint(Component.java:2731)
        at javax.swing.JComponent.setEnabled(JComponent.java:2575)
        at javax.swing.AbstractButton.setEnabled(AbstractButton.java:1918)
        at 
javax.swing.AbstractButton$ButtonActionPropertyChangeListener.propertyChange(AbstractButton.java:1188)
        at 
java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:333)
        at 
java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:270)
        at 
javax.swing.AbstractAction.firePropertyChange(AbstractAction.java:178)
        at javax.swing.AbstractAction.setEnabled(AbstractAction.java:138)
        at 
net.sourceforge.squirrel_sql.client.session.action.ToggleAutoCommitAction.setSession(ToggleAutoCommitAction.java:63)
        at 
net.sourceforge.squirrel_sql.client.action.ActionCollection.setCurrentSession(ActionCollection.java:377)
        at 
net.sourceforge.squirrel_sql.client.gui.WindowManager$SessionListener.sessionActivated(WindowManager.java:1159)
        at 
net.sourceforge.squirrel_sql.client.session.SessionManager.fireSessionActivated(SessionManager.java:476)
        at 
net.sourceforge.squirrel_sql.client.session.SessionManager.setActiveSession(SessionManager.java:152)
        at 
net.sourceforge.squirrel_sql.client.session.SessionManager.createSession(SessionManager.java:142)
        at 
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.createSession(ConnectToAliasCommand.java:349)
        at 
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:313)
        at 
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
        at java.lang.Thread.run(Thread.java:595)

...many more...then:

95796 [AWT-EventQueue-1] DEBUG 
net.sourceforge.squirrel_sql.client.gui.WindowManager  - Registering 
net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame in 
WindowManager
95830 [AWT-EventQueue-1] DEBUG 
net.sourceforge.squirrel_sql.client.session.Session  - GUI Thread is doing 
database work
java.lang.Exception: GUI Thread is doing database work
        at 
net.sourceforge.squirrel_sql.client.session.Session.checkThread(Session.java:914)
        at 
net.sourceforge.squirrel_sql.client.session.Session.getSQLConnection(Session.java:360)
        at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreeModel$RootNode.createDbo(ObjectTreeModel.java:371)
        at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreeModel$RootNode.<init>(ObjectTreeModel.java:366)
        at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreeModel.createRootNode(ObjectTreeModel.java:265)
        at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreeModel.<init>(ObjectTreeModel.java:81)
        at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree.<init>(ObjectTree.java:128)
        at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreePanel.createGUI(ObjectTreePanel.java:871)
        at 
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreePanel.<init>(ObjectTreePanel.java:155)
        at 
net.sourceforge.squirrel_sql.client.session.mainpanel.ObjectTreeTab.getComponent(ObjectTreeTab.java:83)
        at 
net.sourceforge.squirrel_sql.client.gui.session.MainPanel.addMainPanelTab(MainPanel.java:198)
        at 
net.sourceforge.squirrel_sql.client.gui.session.MainPanel.<init>(MainPanel.java:108)
        at 
net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.createGUI(SessionPanel.java:456)
        at 
net.sourceforge.squirrel_sql.client.gui.session.SessionPanel.<init>(SessionPanel.java:121)
        at 
net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame.createGUI(SessionInternalFrame.java:160)
        at 
net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame.<init>(SessionInternalFrame.java:53)
        at 
net.sourceforge.squirrel_sql.client.gui.WindowManager.createInternalFrame(WindowManager.java:367)
        at 
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$Runner.run(ConnectToAliasCommand.java:375)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
        at 
net.sourceforge.squirrel_sql.client.Application$1.dispatchEvent(Application.java:168)
        at 
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
        at 
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

...many more...

--- END log snippets ------------------------------------------------------


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642