| Code: |
|
select inst.facilityType , pdatas.operationType from institutions as inst inner join patients as pat ON pat.institution_id = inst.id INNER JOIN patients_datas as pdatas ON pdatas.patient_id = pat.id |
| Code: |
|
org.eclipse.birt.report.designer.core.runtime.GUIException: Caused by java.lang.reflect.InvocationTargetException. at org.eclipse.birt.report.designer.core.runtime.GUIException.createGUIException(GUIException.java:78) at org.eclipse.birt.report.designer.internal.ui.util.ExceptionHandler.handle(ExceptionHandler.java:169) at org.eclipse.birt.report.designer.internal.ui.util.ExceptionHandler.handle(ExceptionHandler.java:150) at org.eclipse.birt.report.designer.internal.ui.util.ExceptionHandler.handle(ExceptionHandler.java:89) at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage.updateResultsProcess(ResultSetPreviewPage.java:548) at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage.access$1(ResultSetPreviewPage.java:414) at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$4.runInUIThread(ResultSetPreviewPage.java:264) at org.eclipse.ui.progress.UIJob$1.run(UIJob.java:95) at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:134) at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3342) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3071) at org.eclipse.jface.window.Window.runEventLoop(Window.java:825) at org.eclipse.jface.window.Window.open(Window.java:801) at org.eclipse.birt.report.designer.ui.dialogs.BaseDialog.open(BaseDialog.java:110) at org.eclipse.birt.report.designer.data.ui.providers.EditableDataSetNodeProvider.performEdit(EditableDataSetNodeProvider.java:99) at org.eclipse.birt.report.designer.internal.ui.views.DefaultNodeProvider.performRequest(DefaultNodeProvider.java:432) at org.eclipse.birt.report.designer.internal.ui.views.actions.EditAction.doAction(EditAction.java:90) at org.eclipse.birt.report.designer.internal.ui.views.actions.AbstractElementAction.run(AbstractElementAction.java:70) at org.eclipse.birt.report.designer.internal.ui.views.RenameListener.doubleClick(RenameListener.java:214) at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:821) at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42) at org.eclipse.core.runtime.Platform.run(Platform.java:888) 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.StructuredViewer.fireDoubleClick(StructuredViewer.java:819) at org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSelect(AbstractTreeViewer.java:1419) at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1195) at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:238) at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:235) at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:296) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1598) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1622) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1607) at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1396) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3484) at org.eclipse.swt.widgets.Control.sendTrackEvents(Control.java:3036) at org.eclipse.swt.widgets.Control.kEventControlTrack(Control.java:2116) at org.eclipse.swt.widgets.Widget.controlProc(Widget.java:375) at org.eclipse.swt.widgets.Display.controlProc(Display.java:863) at org.eclipse.swt.internal.carbon.OS.CallNextEventHandler(Native Method) at org.eclipse.swt.widgets.Tree.kEventMouseDown(Tree.java:2653) at org.eclipse.swt.widgets.Widget.mouseProc(Widget.java:1362) at org.eclipse.swt.widgets.Display.mouseProc(Display.java:2930) at org.eclipse.swt.internal.carbon.OS.SendEventToEventTarget(Native Method) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3051) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221) at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194) 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:368) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514) at org.eclipse.equinox.launcher.Main.run(Main.java:1311) Caused by: java.lang.reflect.InvocationTargetException at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:421) at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:507) at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage.updateResultsProcess(ResultSetPreviewPage.java:544) ... 62 more Caused by: org.eclipse.swt.SWTException: Invalid thread access at org.eclipse.swt.SWT.error(SWT.java:3884) at org.eclipse.swt.SWT.error(SWT.java:3799) at org.eclipse.swt.SWT.error(SWT.java:3770) at org.eclipse.swt.widgets.Widget.error(Widget.java:696) at org.eclipse.swt.widgets.Widget.checkWidget(Widget.java:341) at org.eclipse.swt.widgets.Tree.deselectAll(Tree.java:826) at org.eclipse.birt.report.designer.internal.ui.views.property.ReportPropertySheetPage.refresh(ReportPropertySheetPage.java:694) at org.eclipse.birt.report.designer.internal.ui.views.property.ReportPropertySheetPage.elementChanged(ReportPropertySheetPage.java:1000) at org.eclipse.birt.report.model.core.DesignElement.broadcast(DesignElement.java:799) at org.eclipse.birt.report.model.activity.NotificationRecordTask.doTask(NotificationRecordTask.java:278) at org.eclipse.birt.report.model.activity.ActivityRecord.performPostTasks(ActivityRecord.java:514) at org.eclipse.birt.report.model.activity.ActivityStack.execute(ActivityStack.java:362) at org.eclipse.birt.report.model.command.ComplexPropertyCommand.addItem(ComplexPropertyCommand.java:133) at org.eclipse.birt.report.model.command.ComplexPropertyCommand.addItem(ComplexPropertyCommand.java:165) at org.eclipse.birt.report.model.api.DesignElementHandle.setPropertyBinding(DesignElementHandle.java:3150) at org.eclipse.birt.report.model.api.DesignElementHandle.setPropertyBinding(DesignElementHandle.java:2363) at org.eclipse.birt.report.designer.data.ui.dataset.DataSetUIUtil.resetPropertyBinding(DataSetUIUtil.java:312) at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:517) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121) |
| Code: |
|
*** Date: Saturday, July 3, 2010 3:30:29 AM EEST ** System properties: OS=MacOSX OS version=10.6.4 Java version=1.6.0_20 *** MyEclipse details: MyEclipse Enterprise Workbench Version: 8.5 Build id: 8.5-20100319 *** Eclipse details: MyEclipse Enterprise Workbench Version: 8.5 Build id: 8.5-20100319 Eclipse startup command=-os macosx -ws carbon -arch x86 -showsplash -launcher /Library/Genuitec/MyEclipse 8.5/myeclipse.app/Contents/MacOS/myeclipse -name Myeclipse --launcher.library /Library/Genuitec/MyEclipse 8.5/myeclipse.app/Contents/MacOS//../../../../Common/plugins/org.eclipse.equinox.launcher.carbon.macosx_1.0.200.v20090520-1835/eclipse_1206.so -startup /Library/Genuitec/MyEclipse 8.5/myeclipse.app/Contents/MacOS/../../../../Common/plugins/org.eclipse.equinox.launcher_1.0.201.R35x_v20090715.jar -install /Library/Genuitec/MyEclipse 8.5 -configuration ../../../configuration -keyring /Users/maravelias/.eclipse_keyring -consoleLog -showlocation -vm /System/Library/Frameworks/JavaVM.framework |
| Code: |
|
select pocdetails.fset ,pocdetails.name ,pocdetails.value ,patient.patient_key ,surgeon.lastname ,institution.country ,institution.name from post_op_complications_details as pocdetails INNER JOIN post_op_complications_AND_details as pocanddetails on pocanddetails.detail_id = pocdetails.id INNER JOIN post_op_complications as postop on postop.id = pocanddetails.complication_id INNER JOIN patients_datas as pdatas on pdatas.id = postop.patientData_id INNER JOIN patients as patient on patient.id = pdatas.patient_id INNER JOIN surgeons as surgeon on surgeon.id = patient.surgeon_id INNER JOIN institutions as institution on institution.id = patient.institution_id where (pocdetails.name Like 'icu' OR pocdetails.name like 'icuRequired') and pocdetails.value like 'true' and pocdetails.fset like 'NO_COMPLICATION'; |