Support for Cloudscape/Derby

MyEclipse IDE

Feature Requests

This topic has 19 replies, 4 voices, and was last updated 20 years, 1 month ago by Joel Rosi-Schwartz.

Viewing 15 posts - 1 through 15 (of 20 total)

1 2 →

Author

Posts

August 31, 2004 at 3:35 am #214027 Reply

Joel Rosi-Schwartz

Member

Hi,

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

September 1, 2004 at 9:44 am #214196 Reply

Riyad Kalla

Member

Ahh, good call Joel I’ll pass it along.

September 2, 2004 at 9:50 pm #214440 Reply

support-jeff

Member

Can 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.

September 6, 2004 at 12:37 pm #214620 Reply

nat101

Member

This 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

September 6, 2004 at 8:51 pm #214637 Reply

support-jeff

Member

If 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….

September 13, 2004 at 1:00 pm #215101 Reply

Joel Rosi-Schwartz

Member

I 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

September 13, 2004 at 10:20 pm #215137 Reply

support-jeff

Member

Sounds 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/NSSimpleDB

or even:
jdbc:cloudscape://localhost:1527/NSSimpleDB

and let me know if either one works better (or worse).

September 14, 2004 at 4:02 am #215149 Reply

Joel Rosi-Schwartz

Member

Jeff,

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)

September 14, 2004 at 5:53 pm #215217 Reply

support-jeff

Member

Looks 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?

September 15, 2004 at 11:04 am #215262 Reply

Joel Rosi-Schwartz

Member

Jeff,

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

September 16, 2004 at 1:48 pm #215366 Reply

Joel Rosi-Schwartz

Member

I 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

September 18, 2004 at 6:53 am #215494 Reply

Joel Rosi-Schwartz

Member

Jeff,

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

September 18, 2004 at 8:37 am #215495 Reply

support-jeff

Member

Joel –

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.

September 18, 2004 at 11:49 am #215506 Reply

Joel Rosi-Schwartz

Member

Jeff,

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

September 19, 2004 at 3:21 pm #215530 Reply

support-jeff

Member

Ok, 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.SCHEMAID

Sorry 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.

Author

Posts

Viewing 15 posts - 1 through 15 (of 20 total)

1 2 →