Hello,
I try to open an oracle XE table on 3.1.0RC1 r23203-20090331-1457 via MetaDataDB Connection\InstanceName.
I can only open table without NUMBER data type.
I receive the
org.talend.cwm.management.api.DqRepositoryViewService - java.sql.SQLException: Stream has already been closed
Any idea, it's a bug?
java.sql.SQLException: Stream has already been closed
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
at oracle.jdbc.driver.LongAccessor.getBytes(LongAccessor.java:166)
at oracle.jdbc.driver.LongAccessor.getString(LongAccessor.java:207)
at oracle.jdbc.driver.T4CLongAccessor.getString(T4CLongAccessor.java:362)
at oracle.jdbc.driver.CharCommonAccessor.getObject(CharCommonAccessor.java:651)
at oracle.jdbc.driver.OracleResultSetImpl.getObject(OracleResultSetImpl.java:851)
at oracle.jdbc.driver.OracleResultSet.getObject(OracleResultSet.java:1547)
at org.talend.cwm.builders.ColumnBuilder.getColumns(Unknown Source)
at org.talend.cwm.management.api.DqRepositoryViewService.loadColumns(Unknown Source)
at org.talend.cwm.management.api.DqRepositoryViewService.getColumns(Unknown Source)
at org.talend.dataprofiler.core.model.nodes.foldernode.ColumnFolderNode.loadChildren(Unknown Source)
at org.talend.dataprofiler.core.ui.views.DQRespositoryView$4.selectionChanged(Unknown Source)
at org.eclipse.jface.viewers.Viewer$2.run(Viewer.java:162)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)
at org.eclipse.core.runtime.Platform.run(Platform.java:880)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:48)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)
at org.eclipse.jface.viewers.Viewer.fireSelectionChanged(Viewer.java:160)
at org.eclipse.jface.viewers.StructuredViewer.updateSelection(StructuredViewer.java:2062)
at org.eclipse.jface.viewers.StructuredViewer.handleSelect(StructuredViewer.java:1138)
at org.eclipse.ui.navigator.CommonViewer.handleSelect(CommonViewer.java:388)
at org.eclipse.jface.viewers.StructuredViewer$4.widgetSelected(StructuredViewer.java:1168)
at org.eclipse.jface.util.OpenStrategy.fireSelectionEvent(OpenStrategy.java:227)
at org.eclipse.jface.util.OpenStrategy.access$3(OpenStrategy.java:221)
at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:388)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3823)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3422)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2382)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2346)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2198)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:493)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:288)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:488)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.talend.dataprofiler.rcp.intro.Application.start(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:382)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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.equinox.launcher.Main.invokeFramework(Main.java:549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
Regards
Hi savoy,
does this error only appear when the table contains a NUMBER column?
It's seems that the connection is already closed when trying to get the columns metadata, but I don't see why it would be related to the NUMBER type of the column.
Can you try to reproduce this error on a table without a NUMBER column, please?
You are right it works on other tables with NUMBER data type but I can't open a series of tables, I don't find a rule to know why a table open or not.
I have done the same test with release 1.1.4, and I can open the tables.
Hi savoy,
I try to reproduce this bug on oracle9, windows XP, but things seems go smoothly.
So i need more infos about this bug. could you please state each step here for me on how to reproduce this bug?
And what's your oracle server version you use?
Thanks.
mzhao
