Stream has already been closed on Talend Open

One Star

Stream has already been closed on Talend Open

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
Employee

Re: Stream has already been closed on Talend Open

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?
One Star

Re: Stream has already been closed on Talend Open

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

Re: Stream has already been closed on Talend Open

Thanks. It's a bug.
Please file a bugtracker issue at http://talendforge.org/bugs/bug_report_advanced_page.php
We'll investigate it further.
Employee

Re: Stream has already been closed on Talend Open

See the state of this bug at 6840
Employee

Re: Stream has already been closed on Talend Open

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