Stream has already been closed on Talend Open

_AnonymousUser — Sat, 16 Nov 2024 14:00:44 GMT

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

Re: Stream has already been closed on Talend Open

Sebastiao_Qlik — Wed, 01 Apr 2009 14:01:53 GMT

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?

Re: Stream has already been closed on Talend Open

_AnonymousUser — Wed, 01 Apr 2009 14:13:26 GMT

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.

Re: Stream has already been closed on Talend Open

Sebastiao_Qlik — Wed, 01 Apr 2009 14:53:48 GMT

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.

Re: Stream has already been closed on Talend Open

Sebastiao_Qlik — Wed, 01 Apr 2009 15:59:23 GMT

See the state of this bug at 6840

Re: Stream has already been closed on Talend Open

Anonymous — Wed, 08 Apr 2009 02:27:34 GMT

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

topic Re: Stream has already been closed on Talend Open in Data Quality

Stream has already been closed on Talend Open

Re: Stream has already been closed on Talend Open

Re: Stream has already been closed on Talend Open

Re: Stream has already been closed on Talend Open

Re: Stream has already been closed on Talend Open

Re: Stream has already been closed on Talend Open