facebook

SQL Explorer – Database Meta Data

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #217705 Reply

    I am using the following:

    Eclipse Platform
    Version: 3.0.1
    Build id: 200409161125

    MyEclipse: 3.8.2

    Other Plugins:
    Spring IDE: 1.0.2
    AJDT: 1.1.12

    The problem I am havings is that ever since version 3.8.2 I am unable to cancel out of the database meta date refresh. I used to be able to that under 3.8.1 and I could still open up a database connection. The reason this is a problem for me is that I am going up against a Mainframe based DB2 database and it takes several minutes to pull down the meta data, so I want to avoid it at all costs.

    #217765 Reply

    jsather
    Member

    I have a similar problem–DB2 -> Mainframe. Mine just fails on the Metadata load. It seems odd that it even tries to pull it since I have the Preferences -> MyEclipse -> Database Explorer flag for getting metadata turned off. Once the metadata fails to load, the connection dies.

    I don’t know if this is the same problem that difranr has, but here is the stack trace from the log file that I get:

    !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Oct 15, 2004 13:04:24.942
    !MESSAGE Error creating database model
    !STACK 0
    com.ibm.db2.jcc.c.DisconnectException: unsupported encoding for result set column
    at com.ibm.db2.jcc.c.f.a(f.java:351)
    at com.ibm.db2.jcc.a.bt.a(bt.java:1893)
    at com.ibm.db2.jcc.a.d.a(d.java:1080)
    at com.ibm.db2.jcc.a.be.a(be.java:1523)
    at com.ibm.db2.jcc.a.be.l(be.java:376)
    at com.ibm.db2.jcc.a.be.k(be.java:294)
    at com.ibm.db2.jcc.a.be.e(be.java:89)
    at com.ibm.db2.jcc.a.s.e(s.java:108)
    at com.ibm.db2.jcc.a.bq.i(bq.java:143)
    at com.ibm.db2.jcc.c.cf.j(cf.java:966)
    at com.ibm.db2.jcc.c.cg.a(cg.java:1551)
    at com.ibm.db2.jcc.c.ch.executeQuery(ch.java:124)
    at com.ibm.db2.jcc.c.p.a(p.java:7296)
    at com.ibm.db2.jcc.c.p.getSchemas(p.java:6206)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:242)
    at com.genuitec.eclipse.sqlexplorer.dbviewer.model.DatabaseModel.initializeMetaData(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.dbviewer.model.DatabaseModel.<init>(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.sessiontree.model.SessionTreeNode.<init>(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.sessiontree.model.SessionTreeModel.createSessionTreeNode(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.sessiontree.actions.RetrievingTableDataProgress$RetrieveData.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

    !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Oct 15, 2004 13:04:26.254
    !MESSAGE Error getting database metadata
    !STACK 0
    com.ibm.db2.jcc.c.SQLException: invalid operation: connection closed
    at com.ibm.db2.jcc.c.l.P(l.java:1588)
    at com.ibm.db2.jcc.c.l.getMetaData(l.java:677)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getJDBCMetaData(SQLDatabaseMetaData.java:476)
    at com.genuitec.eclipse.sqlexplorer.plugin.views.ConnectionInfo.setInput(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.sessiontree.ui.DatabaseTreeViewer$4.selectionChanged(Unknown Source)
    at org.eclipse.jface.viewers.Viewer$2.run(Viewer.java:159)
    at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:616)
    at org.eclipse.core.runtime.Platform.run(Platform.java:747)
    at org.eclipse.jface.viewers.Viewer.fireSelectionChanged(Viewer.java:157)
    at org.eclipse.jface.viewers.StructuredViewer.updateSelection(StructuredViewer.java:1394)
    at org.eclipse.jface.viewers.StructuredViewer.setSelection(StructuredViewer.java:1093)
    at org.eclipse.jface.viewers.Viewer.setSelection(Viewer.java:356)
    at com.genuitec.eclipse.sqlexplorer.sessiontree.ui.DatabaseTreeViewer$3.run(Unknown Source)
    at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
    at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:106)
    at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:2749)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2434)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.block(ModalContext.java:136)
    at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:262)
    at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:397)
    at com.genuitec.eclipse.sqlexplorer.sessiontree.actions.OpenPasswordConnectDialogAction.perfomLoginAndRetrieval(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.sessiontree.actions.OpenPasswordConnectDialogAction.run(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.sessiontree.actions.NewConnection.run(Unknown Source)
    at org.eclipse.jface.action.Action.runWithEvent(Action.java:881)
    at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:915)
    at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:866)
    at org.eclipse.jface.action.ActionContributionItem$7.handleEvent(ActionContributionItem.java:785)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:796)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2772)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2431)
    at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1377)
    at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1348)
    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:254)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:141)
    at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:96)
    at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:335)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:273)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:129)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.eclipse.core.launcher.Main.basicRun(Main.java:183)
    at org.eclipse.core.launcher.Main.run(Main.java:644)
    at org.eclipse.core.launcher.Main.main(Main.java:628)

    Thanks,
    Joel

    #217779 Reply

    I do not get any errors when it happens to me, but if I let it run long enough it comes back. Then I can work with it, but I hate the delay. I have Metadata turned on, but on 1 schema and that did not seem to make any difference.

    #218487 Reply

    duckman75
    Member

    I just opened a new thread for this… sorry i did not see it here, i have the same issue DB2 on Mainframe.

    #218944 Reply

    Ed ross
    Member

    trying to use the database explorer but can not get past the connection

    After may failed attempts at connecting to postgresql, I finnaly found the combination that works in my application. However when I try and use the database exporer, it seems to connect ok – but get the following error:

    Error while trying to login to database:
    attempt to get or create node with key of zero length

    I don’t think it is related to the login as I use the user id and password in the application without problems and I do not get an error on the server side

    #221275 Reply

    Gerd
    Member

    Hi edross,,

    I had the same problem with my postgresql. Since I changed the JDBC Driver from version 7.3 to 7.4 everything seems to work.

    #222070 Reply

    The latest version of MyEclipse seems to correct this problem.

Viewing 7 posts - 1 through 7 (of 7 total)
Reply To: SQL Explorer – Database Meta Data

You must be logged in to post in the forum log in