Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#834 Unable to list ddl-sourcecode

snapshot
open
Rob Manning
DB2 Plugin (16)
5
2012-12-29
2010-03-04
Anonymous
No

We are using squirrelsql 3.1 with DB2 z/OS 9.

If i try to display the sourcecode we get the following exception on the commandline:

---
java.lang.IllegalStateException: Dialect (DB2) doesn't provide a java type for native type = ROWID
at net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect.getJavaTypeForNativeType(CommonHibernateDialect.java:584)
at net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect.getTypeName(CommonHibernateDialect.java:570)
at net.sourceforge.squirrel_sql.fw.dialects.DialectUtils.getCreateTableSQL(DialectUtils.java:1800)
at net.sourceforge.squirrel_sql.fw.dialects.DB2DialectExt.getCreateTableSQL(DB2DialectExt.java:648)
at net.sourceforge.squirrel_sql.plugins.db2.tab.TableSourceTab.getRegularTableSelectSql(TableSourceTab.java:182)
at net.sourceforge.squirrel_sql.plugins.db2.tab.TableSourceTab.getTableSelectSql(TableSourceTab.java:156)
at net.sourceforge.squirrel_sql.plugins.db2.tab.TableSourceTab.createStatement(TableSourceTab.java:102)
at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseSourceTab.refreshComponent(BaseSourceTab.java:135)
at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseObjectTab.select(BaseObjectTab.java:113)
at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreeTabbedPane.selectCurrentTab(ObjectTreeTabbedPane.java:151)
at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreePanel$TabbedPaneListener.stateChanged(ObjectTreePanel.java:1080)
at javax.swing.JTabbedPane.fireStateChanged(JTabbedPane.java:400)
at javax.swing.JTabbedPane$ModelListener.stateChanged(JTabbedPane.java:253)
at javax.swing.DefaultSingleSelectionModel.fireStateChanged(DefaultSingleSelectionModel.java:116)
at javax.swing.DefaultSingleSelectionModel.setSelectedIndex(DefaultSingleSelectionModel.java:50)
at javax.swing.JTabbedPane.setSelectedIndexImpl(JTabbedPane.java:599)
at javax.swing.JTabbedPane.setSelectedIndex(JTabbedPane.java:574)
at javax.swing.plaf.basic.BasicTabbedPaneUI$Handler.mousePressed(BasicTabbedPaneUI.java:3622)
at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:262)
at java.awt.Component.processMouseEvent(Component.java:6260)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6028)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4235)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2475)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at net.sourceforge.squirrel_sql.client.Application$1.dispatchEvent(Application.java:195)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
---

Probably this allso happens on DB2 for Linux - if you have hints to trace the problem, please provide information :-)

Discussion

  • Rob Manning
    Rob Manning
    2010-03-13

    Please provide a small create table script (and data if necessary) that can be used to reproduce the problem.