[Ronald R DiFrango]

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.

[jsather]

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

[Ronald R DiFrango]

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.

[duckman75]

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

[Ed ross]

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

[Gerd]

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.

[Ronald R DiFrango]

The latest version of MyEclipse seems to correct this problem.

[Author]

Posts