1 Reply Latest reply on Jan 12, 2017 5:08 PM by shawkins

    Exception in Execution: java.sql.SQLException: Cannot perform operations on a closed connection.

    rahulsharma1392

      I created view successfully. when i went to see preview, it was throwing below exception.

       

      It throws exception randomly but not always.

       

      java.sql.SQLException: Cannot perform operations on a closed connection.

        at org.teiid.jdbc.ConnectionImpl.checkConnection(ConnectionImpl.java:787)

        at org.teiid.jdbc.StatementImpl.checkStatement(StatementImpl.java:351)

        at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:461)

        at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:455)

        at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:389)

        at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable.getExecutionPlan(TeiidAdHocScriptRunnable.java:374)

        at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable.handleShowExecutionPlan(TeiidAdHocScriptRunnable.java:291)

        at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable.access$0(TeiidAdHocScriptRunnable.java:290)

        at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable$UpdatePlanViewRunnable.run(TeiidAdHocScriptRunnable.java:332)

        at org.eclipse.ui.internal.UILockListener.doPendingWork(UILockListener.java:162)

        at org.eclipse.ui.internal.UISynchronizer$3.run(UISynchronizer.java:154)

        at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)

        at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:135)

        at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4155)

        at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3772)

        at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1127)

        at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)

        at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1018)

        at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:156)

        at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:694)

        at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)

        at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:606)

        at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)

        at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:139)

        at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)

        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:498)

        at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:669)

        at org.eclipse.equinox.launcher.Main.basicRun(Main.java:608)

        at org.eclipse.equinox.launcher.Main.run(Main.java:1515)

        at org.eclipse.equinox.launcher.Main.main(Main.java:1488)