To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113250 Issue #|113250 Summary|Cannot stop database query when retreiving large data |sets Component|Database access Version|OOO330m1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|osavill
------- Additional comments from osav...@openoffice.org Mon Jul 19 14:34:43 +0000 2010 ------- The Stop button is ineffective when trying to run a database report. The only way to stop it is to kill the application. Run the Report Wizard, In the last step select Create Report Now and Finish, A collecting data dialog appears with a Stop button. The query takes a long time to run hence the attempt at stopping it. I cannot run other query based reports (see my next issue report) so I don't know if this is general for all query based reports. When running a report I also get: Run SQL Command Directlycom.sun.star.beans.UnknownPropertyException: FormatsSupplier at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method) at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175) at $Proxy6.setPropertyValue(Unknown Source) at com.sun.star.wizards.common.NumberFormatter.setNumberFormat(NumberFormatter.java:204) at com.sun.star.wizards.report.DBColumn.initializeNumberFormat(DBColumn.java:244) at com.sun.star.wizards.report.ReportTextDocument.insertColumnstoRecordTable(ReportTextDocument.java:440) at com.sun.star.wizards.report.ReportTextDocument.setupRecordSection(ReportTextDocument.java:325) at com.sun.star.wizards.report.ReportTextImplementation.layout_setupRecordSection(ReportTextImplementation.java:546) at com.sun.star.wizards.report.ReportLayouter.initialize(ReportLayouter.java:229) at com.sun.star.wizards.report.ReportWizard.leaveStep(ReportWizard.java:238) at com.sun.star.wizards.ui.WizardDialog.switchToStep(WizardDialog.java:363) at com.sun.star.wizards.ui.WizardDialog.gotoNextAvailableStep(WizardDialog.java:681) 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 com.sun.star.wizards.ui.event.MethodInvocation.invoke(MethodInvocation.java:96) at com.sun.star.wizards.ui.event.AbstractListener.invoke(AbstractListener.java:89) at com.sun.star.wizards.ui.event.CommonListener.actionPerformed(CommonListener.java:49) at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method) at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175) at $Proxy89.execute(Unknown Source) at com.sun.star.wizards.ui.UnoDialog.executeDialog(UnoDialog.java:742) at com.sun.star.wizards.report.ReportWizard.startReportWizard(ReportWizard.java:492) at com.sun.star.wizards.report.CallReportWizard$ReportWizardImplementation.trigger(CallReportWizard.java:140) com.sun.star.beans.UnknownPropertyException: FormatsSupplier at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method) at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175) at $Proxy6.setPropertyValue(Unknown Source) at com.sun.star.wizards.common.NumberFormatter.setNumberFormat(NumberFormatter.java:204) at com.sun.star.wizards.report.DBColumn.initializeNumberFormat(DBColumn.java:244) at com.sun.star.wizards.report.ReportTextDocument.insertColumnstoRecordTable(ReportTextDocument.java:440) at com.sun.star.wizards.report.ReportTextDocument.setupRecordSection(ReportTextDocument.java:325) at com.sun.star.wizards.report.ReportTextImplementation.layout_setupRecordSection(ReportTextImplementation.java:546) at com.sun.star.wizards.report.ReportLayouter.initialize(ReportLayouter.java:229) at com.sun.star.wizards.report.ReportWizard.leaveStep(ReportWizard.java:238) at com.sun.star.wizards.ui.WizardDialog.switchToStep(WizardDialog.java:363) at com.sun.star.wizards.ui.WizardDialog.gotoNextAvailableStep(WizardDialog.java:681) 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 com.sun.star.wizards.ui.event.MethodInvocation.invoke(MethodInvocation.java:96) at com.sun.star.wizards.ui.event.AbstractListener.invoke(AbstractListener.java:89) at com.sun.star.wizards.ui.event.CommonListener.actionPerformed(CommonListener.java:49) at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method) at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175) at $Proxy89.execute(Unknown Source) at com.sun.star.wizards.ui.UnoDialog.executeDialog(UnoDialog.java:742) at com.sun.star.wizards.report.ReportWizard.startReportWizard(ReportWizard.java:492) at com.sun.star.wizards.report.CallReportWizard$ReportWizardImplementation.trigger(CallReportWizard.java:140) com.sun.star.beans.UnknownPropertyException: FormatsSupplier at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method) at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175) at $Proxy6.setPropertyValue(Unknown Source) at com.sun.star.wizards.common.NumberFormatter.setNumberFormat(NumberFormatter.java:204) at com.sun.star.wizards.report.DBColumn.initializeNumberFormat(DBColumn.java:244) at com.sun.star.wizards.report.ReportTextDocument.insertColumnstoRecordTable(ReportTextDocument.java:440) at com.sun.star.wizards.report.ReportTextDocument.setupRecordSection(ReportTextDocument.java:325) at com.sun.star.wizards.report.ReportTextImplementation.layout_setupRecordSection(ReportTextImplementation.java:546) at com.sun.star.wizards.report.ReportLayouter.initialize(ReportLayouter.java:229) at com.sun.star.wizards.report.ReportWizard.leaveStep(ReportWizard.java:238) at com.sun.star.wizards.ui.WizardDialog.switchToStep(WizardDialog.java:363) at com.sun.star.wizards.ui.WizardDialog.gotoNextAvailableStep(WizardDialog.java:681) 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 com.sun.star.wizards.ui.event.MethodInvocation.invoke(MethodInvocation.java:96) at com.sun.star.wizards.ui.event.AbstractListener.invoke(AbstractListener.java:89) at com.sun.star.wizards.ui.event.CommonListener.actionPerformed(CommonListener.java:49) at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method) at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175) at $Proxy89.execute(Unknown Source) at com.sun.star.wizards.ui.UnoDialog.executeDialog(UnoDialog.java:742) at com.sun.star.wizards.report.ReportWizard.startReportWizard(ReportWizard.java:492) at com.sun.star.wizards.report.CallReportWizard$ReportWizardImplementation.trigger(CallReportWizard.java:140) com.sun.star.beans.UnknownPropertyException: FormatsSupplier at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method) at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175) at $Proxy6.setPropertyValue(Unknown Source) at com.sun.star.wizards.common.NumberFormatter.setNumberFormat(NumberFormatter.java:204) at com.sun.star.wizards.report.DBColumn.initializeNumberFormat(DBColumn.java:244) at com.sun.star.wizards.report.ReportTextDocument.insertColumnstoRecordTable(ReportTextDocument.java:440) at com.sun.star.wizards.report.ReportTextDocument.setupRecordSection(ReportTextDocument.java:325) at com.sun.star.wizards.report.ReportTextImplementation.layout_setupRecordSection(ReportTextImplementation.java:546) at com.sun.star.wizards.report.ReportLayouter.initialize(ReportLayouter.java:229) at com.sun.star.wizards.report.ReportWizard.leaveStep(ReportWizard.java:238) at com.sun.star.wizards.ui.WizardDialog.switchToStep(WizardDialog.java:363) at com.sun.star.wizards.ui.WizardDialog.gotoNextAvailableStep(WizardDialog.java:681) 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 com.sun.star.wizards.ui.event.MethodInvocation.invoke(MethodInvocation.java:96) at com.sun.star.wizards.ui.event.AbstractListener.invoke(AbstractListener.java:89) at com.sun.star.wizards.ui.event.CommonListener.actionPerformed(CommonListener.java:49) at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method) at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175) at $Proxy89.execute(Unknown Source) at com.sun.star.wizards.ui.UnoDialog.executeDialog(UnoDialog.java:742) at com.sun.star.wizards.report.ReportWizard.startReportWizard(ReportWizard.java:492) at com.sun.star.wizards.report.CallReportWizard$ReportWizardImplementation.trigger(CallReportWizard.java:140) com.sun.star.beans.UnknownPropertyException: FormatsSupplier at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method) at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175) at $Proxy6.setPropertyValue(Unknown Source) at com.sun.star.wizards.common.NumberFormatter.setNumberFormat(NumberFormatter.java:204) at com.sun.star.wizards.report.DBColumn.initializeNumberFormat(DBColumn.java:244) at com.sun.star.wizards.report.ReportTextDocument.insertColumnstoRecordTable(ReportTextDocument.java:440) at com.sun.star.wizards.report.ReportTextDocument.setupRecordSection(ReportTextDocument.java:325) at com.sun.star.wizards.report.ReportTextImplementation.layout_setupRecordSection(ReportTextImplementation.java:546) at com.sun.star.wizards.report.ReportLayouter.initialize(ReportLayouter.java:229) at com.sun.star.wizards.report.ReportWizard.leaveStep(ReportWizard.java:238) at com.sun.star.wizards.ui.WizardDialog.switchToStep(WizardDialog.java:363) at com.sun.star.wizards.ui.WizardDialog.gotoNextAvailableStep(WizardDialog.java:681) 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 com.sun.star.wizards.ui.event.MethodInvocation.invoke(MethodInvocation.java:96) at com.sun.star.wizards.ui.event.AbstractListener.invoke(AbstractListener.java:89) at com.sun.star.wizards.ui.event.CommonListener.actionPerformed(CommonListener.java:49) at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method) at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175) at $Proxy89.execute(Unknown Source) at com.sun.star.wizards.ui.UnoDialog.executeDialog(UnoDialog.java:742) at com.sun.star.wizards.report.ReportWizard.startReportWizard(ReportWizard.java:492) at com.sun.star.wizards.report.CallReportWizard$ReportWizardImplementation.trigger(CallReportWizard.java:140) --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org