|
From: Lars H. <Lar...@Su...> - 2006-10-19 12:16:25
|
Robert Manning wrote, On 10/19/06 03:43: > On 10/18/06, Lars Heill <Lar...@su...> 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 ------------------------------------------------------ |
