- This topic has 19 replies, 4 voices, and was last updated 20 years, 2 months ago by Joel Rosi-Schwartz.
-
AuthorPosts
-
Joel Rosi-SchwartzMemberHi,
IBM has recently contributed their Cloudscape Java database to the ASF where it will be renamed Derby. It would be great if is were added to the supported databases in the DB Exporer.
Thanks,
Joel
Riyad KallaMemberAhh, good call Joel I’ll pass it along.
support-jeffMemberCan be added easily by you yourself – just download the JDBC driver (which you would have to do anyway) and set up a driver and connection profile.
nat101MemberThis might be off-topic..
Can Cloudscape/Derby be [transparently] used as the DB in various (Sun One, JoNas) j2ee servers? Do they have the connectors, or is this part of the MyEclipse space?
Thanks;
-nat
support-jeffMemberIf there is a JDBC driver for Cloudscape (which there almost certainly is – its a Java db fer cryin out loud!), then it ought to work transparently in any J2EE app server. The only non-transparent part: SQL syntax may not be the same as others, so the farther your app strays from SQL standards, the worse-off you are….
Joel Rosi-SchwartzMemberI am experiencing odd behaviour with Cloudscape. I have defined my own connection profile which is
jdbc:cloudscape:net://localhost:1527/NSSimpleDB:retrieveMessagesFromServerOnGetMessage=true;
I can connect to the database no problem. When I expand the connection in the DB Explorer I see all of the schemas I expect, e.g. APP, SYS, SYSCAT, etc. When I expand these nodes I see the SYSTEM TABLE, TABLE and VIEW nodes, however, these are all empty. On the otherhand, I can open an SQL Editor and query the database just fine, so this does not seem to be an issue with the database itself.
Any idea what may be causing this behaviour and how to work around it?
Thanks,
Joel
support-jeffMemberSounds like (yet another) DBMetaData problem. Is anything at all showing up in the Eclipse error logs? Probably not since the original plugin was pretty weak on logging. I will have to install Cloudscape and debug myself. That is going to take some time, so expect no resolution real soon. What version of Cloudscape are you using?
Also, have you tried accessing with a connection URL that does not have the ‘retrieveMessages….’ part? Try this:
jdbc:cloudscape:net://localhost:1527/NSSimpleDBor even:
jdbc:cloudscape://localhost:1527/NSSimpleDBand let me know if either one works better (or worse).
Joel Rosi-SchwartzMemberJeff,
Yes, there are messages in the error log. Silly of me, I really should have looked in the first place. I will tack them on to the end of this post.
I tried the other URLs that you suggest. The first comes back with a bad url error “Unable to create connection.”. The other has the same behaviour as I reported.
Thanks for looking into this and please let me know if there is anything I can do to assist.
Cheers,
Joel!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:42.859 !MESSAGE Error Retrieving schema children in plugin !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.SchemaNode.fastLoadSchema(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.RetrievingTableDataProgress.run(Unknown Source) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:101) !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:42.890 !MESSAGE Error Retrieving schema children in plugin !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.SchemaNode.fastLoadSchema(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.RetrievingTableDataProgress.run(Unknown Source) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:101) !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:42.906 !MESSAGE Error Retrieving schema children in plugin !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.SchemaNode.fastLoadSchema(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.RetrievingTableDataProgress.run(Unknown Source) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:101) !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:42.953 !MESSAGE Error Retrieving schema children in plugin !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.SchemaNode.fastLoadSchema(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.RetrievingTableDataProgress.run(Unknown Source) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:101) !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:42.968 !MESSAGE Error Retrieving schema children in plugin !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.SchemaNode.fastLoadSchema(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.RetrievingTableDataProgress.run(Unknown Source) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:101) !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:43.46 !MESSAGE Error Retrieving schema children in plugin !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.SchemaNode.fastLoadSchema(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.RetrievingTableDataProgress.run(Unknown Source) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:101) !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:43.62 !MESSAGE Error Retrieving schema children in plugin !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.SchemaNode.fastLoadSchema(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.RetrievingTableDataProgress.run(Unknown Source) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:101) !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:43.93 !MESSAGE Error Retrieving schema children in plugin !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.SchemaNode.fastLoadSchema(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.RetrievingTableDataProgress.run(Unknown Source) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:101) !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:43.109 !MESSAGE Error Retrieving schema children in plugin !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.SchemaNode.fastLoadSchema(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.RetrievingTableDataProgress.run(Unknown Source) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:101) !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:43.140 !MESSAGE Error Retrieving schema children in plugin !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.SchemaNode.fastLoadSchema(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.RetrievingTableDataProgress.run(Unknown Source) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:101) !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:43.171 !MESSAGE Error Retrieving schema children in plugin !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.SchemaNode.fastLoadSchema(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.RetrievingTableDataProgress.run(Unknown Source) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:101) !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:48.125 !MESSAGE Error getting table information !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.TableObjectTypeNode.load(Unknown Source) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.TableObjectTypeNode.getChildren(Unknown Source) at com.genuitec.eclipse.sqlexplorer.sessiontree.ui.DatabaseContentProvider.getChildren(Unknown Source) at com.genuitec.eclipse.sqlexplorer.sessiontree.ui.DatabaseContentProvider.hasChildren(Unknown Source) at org.eclipse.jface.viewers.AbstractTreeViewer.isExpandable(AbstractTreeViewer.java:1139) at org.eclipse.jface.viewers.AbstractTreeViewer.updatePlus(AbstractTreeViewer.java:1587) at org.eclipse.jface.viewers.AbstractTreeViewer.createTreeItem(AbstractTreeViewer.java:382) at org.eclipse.jface.viewers.AbstractTreeViewer$1.run(AbstractTreeViewer.java:361) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69) at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.java:342) at org.eclipse.jface.viewers.AbstractTreeViewer.handleTreeExpand(AbstractTreeViewer.java:754) at org.eclipse.jface.viewers.AbstractTreeViewer$4.treeExpanded(AbstractTreeViewer.java:765) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:179) 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.Widget.sendEvent(Widget.java:820) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:805) at org.eclipse.swt.widgets.Tree.wmNotifyChild(Tree.java:2074) at org.eclipse.swt.widgets.Control.WM_NOTIFY(Control.java:4002) at org.eclipse.swt.widgets.Composite.WM_NOTIFY(Composite.java:722) at org.eclipse.swt.widgets.Control.windowProc(Control.java:3019) at org.eclipse.swt.widgets.Display.windowProc(Display.java:3338) at org.eclipse.swt.internal.win32.OS.CallWindowProcW(Native Method) at org.eclipse.swt.internal.win32.OS.CallWindowProc(OS.java:1391) at org.eclipse.swt.widgets.Tree.callWindowProc(Tree.java:170) at org.eclipse.swt.widgets.Tree.WM_LBUTTONDOWN(Tree.java:1668) at org.eclipse.swt.widgets.Control.windowProc(Control.java:3001) at org.eclipse.swt.widgets.Display.windowProc(Display.java:3338) at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method) at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:1467) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2429) 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) !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:48.171 !MESSAGE Error getting table information !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.TableObjectTypeNode.load(Unknown Source) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.TableObjectTypeNode.getChildren(Unknown Source) at com.genuitec.eclipse.sqlexplorer.sessiontree.ui.DatabaseContentProvider.getChildren(Unknown Source) at com.genuitec.eclipse.sqlexplorer.sessiontree.ui.DatabaseContentProvider.hasChildren(Unknown Source) at org.eclipse.jface.viewers.AbstractTreeViewer.isExpandable(AbstractTreeViewer.java:1139) at org.eclipse.jface.viewers.AbstractTreeViewer.updatePlus(AbstractTreeViewer.java:1587) at org.eclipse.jface.viewers.AbstractTreeViewer.createTreeItem(AbstractTreeViewer.java:382) at org.eclipse.jface.viewers.AbstractTreeViewer$1.run(AbstractTreeViewer.java:361) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69) at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.java:342) at org.eclipse.jface.viewers.AbstractTreeViewer.handleTreeExpand(AbstractTreeViewer.java:754) at org.eclipse.jface.viewers.AbstractTreeViewer$4.treeExpanded(AbstractTreeViewer.java:765) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:179) 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.Widget.sendEvent(Widget.java:820) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:805) at org.eclipse.swt.widgets.Tree.wmNotifyChild(Tree.java:2074) at org.eclipse.swt.widgets.Control.WM_NOTIFY(Control.java:4002) at org.eclipse.swt.widgets.Composite.WM_NOTIFY(Composite.java:722) at org.eclipse.swt.widgets.Control.windowProc(Control.java:3019) at org.eclipse.swt.widgets.Display.windowProc(Display.java:3338) at org.eclipse.swt.internal.win32.OS.CallWindowProcW(Native Method) at org.eclipse.swt.internal.win32.OS.CallWindowProc(OS.java:1391) at org.eclipse.swt.widgets.Tree.callWindowProc(Tree.java:170) at org.eclipse.swt.widgets.Tree.WM_LBUTTONDOWN(Tree.java:1668) at org.eclipse.swt.widgets.Control.windowProc(Control.java:3001) at org.eclipse.swt.widgets.Display.windowProc(Display.java:3338) at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method) at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:1467) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2429) 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) !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:48.218 !MESSAGE Error getting table information !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.TableObjectTypeNode.load(Unknown Source) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.TableObjectTypeNode.getChildren(Unknown Source) at com.genuitec.eclipse.sqlexplorer.sessiontree.ui.DatabaseContentProvider.getChildren(Unknown Source) at com.genuitec.eclipse.sqlexplorer.sessiontree.ui.DatabaseContentProvider.hasChildren(Unknown Source) at org.eclipse.jface.viewers.AbstractTreeViewer.isExpandable(AbstractTreeViewer.java:1139) at org.eclipse.jface.viewers.AbstractTreeViewer.updatePlus(AbstractTreeViewer.java:1587) at org.eclipse.jface.viewers.AbstractTreeViewer.createTreeItem(AbstractTreeViewer.java:382) at org.eclipse.jface.viewers.AbstractTreeViewer$1.run(AbstractTreeViewer.java:361) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69) at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.java:342) at org.eclipse.jface.viewers.AbstractTreeViewer.handleTreeExpand(AbstractTreeViewer.java:754) at org.eclipse.jface.viewers.AbstractTreeViewer$4.treeExpanded(AbstractTreeViewer.java:765) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:179) 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.Widget.sendEvent(Widget.java:820) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:805) at org.eclipse.swt.widgets.Tree.wmNotifyChild(Tree.java:2074) at org.eclipse.swt.widgets.Control.WM_NOTIFY(Control.java:4002) at org.eclipse.swt.widgets.Composite.WM_NOTIFY(Composite.java:722) at org.eclipse.swt.widgets.Control.windowProc(Control.java:3019) at org.eclipse.swt.widgets.Display.windowProc(Display.java:3338) at org.eclipse.swt.internal.win32.OS.CallWindowProcW(Native Method) at org.eclipse.swt.internal.win32.OS.CallWindowProc(OS.java:1391) at org.eclipse.swt.widgets.Tree.callWindowProc(Tree.java:170) at org.eclipse.swt.widgets.Tree.WM_LBUTTONDOWN(Tree.java:1668) at org.eclipse.swt.widgets.Control.windowProc(Control.java:3001) at org.eclipse.swt.widgets.Display.windowProc(Display.java:3338) at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method) at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:1467) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2429) 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) !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:50.984 !MESSAGE Error getting table information !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.TableObjectTypeNode.load(Unknown Source) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.TableObjectTypeNode.getChildren(Unknown Source) at com.genuitec.eclipse.sqlexplorer.sessiontree.ui.DatabaseContentProvider.getChildren(Unknown Source) at com.genuitec.eclipse.sqlexplorer.sessiontree.ui.DatabaseContentProvider.hasChildren(Unknown Source) at org.eclipse.jface.viewers.AbstractTreeViewer.isExpandable(AbstractTreeViewer.java:1139) at org.eclipse.jface.viewers.AbstractTreeViewer.updatePlus(AbstractTreeViewer.java:1587) at org.eclipse.jface.viewers.AbstractTreeViewer.createTreeItem(AbstractTreeViewer.java:382) at org.eclipse.jface.viewers.AbstractTreeViewer$1.run(AbstractTreeViewer.java:361) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69) at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.java:342) at org.eclipse.jface.viewers.AbstractTreeViewer.handleTreeExpand(AbstractTreeViewer.java:754) at org.eclipse.jface.viewers.AbstractTreeViewer$4.treeExpanded(AbstractTreeViewer.java:765) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:179) 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.Widget.sendEvent(Widget.java:820) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:805) at org.eclipse.swt.widgets.Tree.wmNotifyChild(Tree.java:2074) at org.eclipse.swt.widgets.Control.WM_NOTIFY(Control.java:4002) at org.eclipse.swt.widgets.Composite.WM_NOTIFY(Composite.java:722) at org.eclipse.swt.widgets.Control.windowProc(Control.java:3019) at org.eclipse.swt.widgets.Display.windowProc(Display.java:3338) at org.eclipse.swt.internal.win32.OS.CallWindowProcW(Native Method) at org.eclipse.swt.internal.win32.OS.CallWindowProc(OS.java:1391) at org.eclipse.swt.widgets.Tree.callWindowProc(Tree.java:170) at org.eclipse.swt.widgets.Tree.WM_LBUTTONDOWN(Tree.java:1668) at org.eclipse.swt.widgets.Control.windowProc(Control.java:3001) at org.eclipse.swt.widgets.Display.windowProc(Display.java:3338) at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method) at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:1467) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2429) 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) !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:51.00 !MESSAGE Error getting table information !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.TableObjectTypeNode.load(Unknown Source) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.TableObjectTypeNode.getChildren(Unknown Source) at com.genuitec.eclipse.sqlexplorer.sessiontree.ui.DatabaseContentProvider.getChildren(Unknown Source) at com.genuitec.eclipse.sqlexplorer.sessiontree.ui.DatabaseContentProvider.hasChildren(Unknown Source) at org.eclipse.jface.viewers.AbstractTreeViewer.isExpandable(AbstractTreeViewer.java:1139) at org.eclipse.jface.viewers.AbstractTreeViewer.updatePlus(AbstractTreeViewer.java:1587) at org.eclipse.jface.viewers.AbstractTreeViewer.createTreeItem(AbstractTreeViewer.java:382) at org.eclipse.jface.viewers.AbstractTreeViewer$1.run(AbstractTreeViewer.java:361) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69) at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.java:342) at org.eclipse.jface.viewers.AbstractTreeViewer.handleTreeExpand(AbstractTreeViewer.java:754) at org.eclipse.jface.viewers.AbstractTreeViewer$4.treeExpanded(AbstractTreeViewer.java:765) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:179) 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.Widget.sendEvent(Widget.java:820) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:805) at org.eclipse.swt.widgets.Tree.wmNotifyChild(Tree.java:2074) at org.eclipse.swt.widgets.Control.WM_NOTIFY(Control.java:4002) at org.eclipse.swt.widgets.Composite.WM_NOTIFY(Composite.java:722) at org.eclipse.swt.widgets.Control.windowProc(Control.java:3019) at org.eclipse.swt.widgets.Display.windowProc(Display.java:3338) at org.eclipse.swt.internal.win32.OS.CallWindowProcW(Native Method) at org.eclipse.swt.internal.win32.OS.CallWindowProc(OS.java:1391) at org.eclipse.swt.widgets.Tree.callWindowProc(Tree.java:170) at org.eclipse.swt.widgets.Tree.WM_LBUTTONDOWN(Tree.java:1668) at org.eclipse.swt.widgets.Control.windowProc(Control.java:3001) at org.eclipse.swt.widgets.Display.windowProc(Display.java:3338) at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method) at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:1467) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2429) 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) !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Sep 14, 2004 09:47:51.00 !MESSAGE Error getting table information !STACK 0 com.ibm.db2.jcc.c.SqlException: Invalid operation: result set closed at com.ibm.db2.jcc.c.qc.mb(qc.java:3413) at com.ibm.db2.jcc.c.qc.c(qc.java:290) at com.ibm.db2.jcc.c.qc.next(qc.java:277) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getTables(SQLDatabaseMetaData.java:640) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.TableObjectTypeNode.load(Unknown Source) at com.genuitec.eclipse.sqlexplorer.dbviewer.model.TableObjectTypeNode.getChildren(Unknown Source) at com.genuitec.eclipse.sqlexplorer.sessiontree.ui.DatabaseContentProvider.getChildren(Unknown Source) at com.genuitec.eclipse.sqlexplorer.sessiontree.ui.DatabaseContentProvider.hasChildren(Unknown Source) at org.eclipse.jface.viewers.AbstractTreeViewer.isExpandable(AbstractTreeViewer.java:1139) at org.eclipse.jface.viewers.AbstractTreeViewer.updatePlus(AbstractTreeViewer.java:1587) at org.eclipse.jface.viewers.AbstractTreeViewer.createTreeItem(AbstractTreeViewer.java:382) at org.eclipse.jface.viewers.AbstractTreeViewer$1.run(AbstractTreeViewer.java:361) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69) at org.eclipse.jface.viewers.AbstractTreeViewer.createChildren(AbstractTreeViewer.java:342) at org.eclipse.jface.viewers.AbstractTreeViewer.handleTreeExpand(AbstractTreeViewer.java:754) at org.eclipse.jface.viewers.AbstractTreeViewer$4.treeExpanded(AbstractTreeViewer.java:765) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:179) 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.Widget.sendEvent(Widget.java:820) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:805) at org.eclipse.swt.widgets.Tree.wmNotifyChild(Tree.java:2074) at org.eclipse.swt.widgets.Control.WM_NOTIFY(Control.java:4002) at org.eclipse.swt.widgets.Composite.WM_NOTIFY(Composite.java:722) at org.eclipse.swt.widgets.Control.windowProc(Control.java:3019) at org.eclipse.swt.widgets.Display.windowProc(Display.java:3338) at org.eclipse.swt.internal.win32.OS.CallWindowProcW(Native Method) at org.eclipse.swt.internal.win32.OS.CallWindowProc(OS.java:1391) at org.eclipse.swt.widgets.Tree.callWindowProc(Tree.java:170) at org.eclipse.swt.widgets.Tree.WM_LBUTTONDOWN(Tree.java:1668) at org.eclipse.swt.widgets.Control.windowProc(Control.java:3001) at org.eclipse.swt.widgets.Display.windowProc(Display.java:3338) at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method) at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:1467) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2429) 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)
support-jeffMemberLooks like a driver issue – not clear why the ResultSet would be closed. I will take a look at the code again, but until I have a Cloudscape install available, I won’t be able to do much for you. Have you checked the Cloudscape user/support lists for any known JDBC driver issues with ResultSet closing?
Joel Rosi-SchwartzMemberJeff,
I have tried to conenct to the Cloudscape forum a couple of times today, but I keep on getting Internal Server Error messages. I will give this a try again tomorrow and let you know if I have any joy.
– joel
Joel Rosi-SchwartzMemberI finally got through to the Cloudscape forum it had been down for a few days. I looked through all of the topics and there is no discussion of the type of issue we have. I posted a message explaining the situation. The url is http://www-128.ibm.com/developerworks/forums/dw_thread.jsp?forum=370&thread=61622&cat=19 if you want to follow it.
– joel
Joel Rosi-SchwartzMemberJeff,
Have you seen the reply to thread that I started on the Cloudscape forum? It suggests:
This error is common in applications that use standard cursors and leave autocommit on (a commit will occur with each statement excuted. When using JDBC cursors most people find it useful to use Holdable Cursor (see: http://publib.boulder.ibm.com/infocenter/cldscp10/topic/com.ibm.cloudscape.doc/develop69.htm#sii-concepts-holdablecursors for more information). Try the same process with holdable cursors (or turn autocommit off) and see it this resolves the problem.
Does this apply to your code?
– joel
support-jeffMemberJoel –
Interesting, and makes sense. Please try this then: in either the preference page for DE (Window -> Prefrences -> MyEclipse -> Database Explorer) or when you open a connection to your database, you will notice that you can turn AutoCommit on/off (as well as Commit on Close). Please play with these settings and see if it affects the behavior of the plugin in working with Cloudscape. If it does not work regardless of the setting, let me know ASAP and I will see what I can do code-wise for the upcoming 3.8.2 release.
Joel Rosi-SchwartzMemberJeff,
Turning off autocommit does clear up the exceptions, but, unfortunately, the behaviour remains the same. I would very much appreciate if you were able to get this in 3.8.2.
Thanks,
Joel
support-jeffMemberOk, Joel. Just spent the last couple hours installing Cloudscape on a linux box and figuring out how to get the server running and connect (no easy task – what a funky little rdbms this thing is 😉 and I am sorry to say that I cannot replicate the behavior you describe (except for the auto-commit) part. Are you sure you are looking at the correct schema for your application? Please check both APP and your userid schemas. Also, you can execute the following to see which tables are in what schema:
SELECT T.TABLENAME, S.SCHEMANAME FROM SYS.SYSTABLES T, SYS.SYSSCHEMAS S WHERE T.SCHEMAID = S.SCHEMAIDSorry I can be of no more help here. The DE plugin seems to do just fine by Cloudscape. I do notice that connecting is a bit weird – could not establish more than one connection at a time, and give up if you want to connect using ij after using the DE plugin. Not sure why that would happen, but it does not seem to prevent DE from connecting multiple times in succession.
-
AuthorPosts