为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:windows
【CPU】:
【问题描述】*:
客户端版本如下:
现有问题描述,多条SQL查询需导出数据,其中某条SQL查询获取的结果集无法无法直接导出所有(客户端默认只获取前100条数据),包括未加载的结果集;
使用DTS工具通过SQL查询的方式,获取任务数为 0
在 manager工具中,加载所有结果集后,可正常导出;
这里应该如何调整,直接导出所有结果集?
tool 日志如下
2024-06-26 14:20:05 [com.dameng.common.gui.dialog.SimpleMessageDialog]
[ERROR] 导出失败
com.dameng.common.persistence.dao.DataAccessException: java.lang.NullPointerException
at com.dameng.common.persistence.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:136) ~[?:?]
at com.dameng.common.aop.DefaultMethodInvocation.proceed(DefaultMethodInvocation.java:85) ~[?:?]
at com.dameng.common.aop.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:84) ~[?:?]
at com.sun.proxy.$Proxy37.execute(Unknown Source) ~[?:?]
at com.dameng.isql.editor.ResultTableViewer$ExportAllAction.nextRow(ResultTableViewer.java:2164) ~[?:?]
at com.dameng.isql.editor.ResultTableViewer$ExportAllAction.nextRow(ResultTableViewer.java:1) ~[?:?]
at com.dameng.tool.action.TableExportAction.exportExcels(TableExportAction.java:207) ~[?:?]
at com.dameng.tool.action.TableExportAction.run(TableExportAction.java:71) ~[?:?]
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498) ~[?:?]
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584) ~[?:?]
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501) ~[?:?]
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411) ~[?:?]
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) ~[?:?]
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4418) ~[?:?]
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1079) ~[?:?]
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4236) ~[?:?]
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3824) ~[?:?]
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2640) ~[?:?]
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604) ~[?:?]
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438) ~[?:?]
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671) ~[?:?]
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332) ~[?:?]
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664) ~[?:?]
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) ~[?:?]
at com.dameng.manager.ManagerApplication.start(ManagerApplication.java:30) ~[?:?]
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196) ~[?:?]
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:369) ~[?:?]
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179) ~[?:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_332]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_332]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_332]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_332]
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:620) ~[org.eclipse.equinox.launcher_1.1.1.R36x_v20101122_1400.jar:?]
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:575) ~[org.eclipse.equinox.launcher_1.1.1.R36x_v20101122_1400.jar:?]
at org.eclipse.equinox.launcher.Main.run(Main.java:1408) ~[org.eclipse.equinox.launcher_1.1.1.R36x_v20101122_1400.jar:?]
Caused by: java.lang.NullPointerException
at java.io.StringReader.<init>(StringReader.java:50) ~[?:1.8.0_332]
at com.dameng.common.util.StringUtil.lexN(SourceFile:779) ~[?:?]
at com.dameng.common.util.StringUtil.lexFirst(SourceFile:767) ~[?:?]
at com.dameng.common.sql.util.SQLUtil.getSqlType(SQLUtil.java:2000) ~[?:?]
at com.dameng.common.persistence.jdbc.SQLExecute.execute(SQLExecute.java:48) ~[?:?]
at com.dameng.common.persistence.jdbc.JdbcSupport.execute(JdbcSupport.java:109) ~[?:?]
at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_332]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_332]
at com.dameng.common.aop.DefaultMethodInvocation.proceed(DefaultMethodInvocation.java:77) ~[?:?]
at com.dameng.common.persistence.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:114) ~[?:?]
... 36 more
导出当前,后续步骤可以导出全部数据的
可以暂时通过如下方式取消返回100行的限制:
窗口-选项-查询分析其-结果集-取消勾选“分页显示结果集”