Hi Michaël, hi Ede, I tested it on two computer with different environments and it works fine.
Thank you for your patience and your help! Have a nice weekend. Uwe Am 18.04.2013 23:32, schrieb Michaël Michaud: > Hi Uwe, > > Good catch ! > I could reproduce the bug with th elast JRE. > I did not remove dispose as I think it it is usefull to free > all resources attached to the TaskMonitor dialog box, > but I moved it after the error message display. > > Available in r3513 > > Michaël > >> Hi, >> >> in the class TaskMonitorManager >> (package com.vividsolutions.jump.workbench.ui.task;) >> >> there is a method "public void run ( )" >> (line 148) >> >> under "finally" >> >> you will find: >> >> dialog.setVisible( false ); >> dialog.dispose(); >> >> >> When I comment out >> >> dialog.dispose(); >> >> then I see the error-gui with JRE 1.7.0_21! >> >> ... >> dialog.setVisible( false ); >> //dialog.dispose(); >> ... >> >> Please can you test it under your environment? >> >> Any idea why dialog should be dispose? >> >> Regards >> >> Uwe >> >> Am 18.04.2013 12:59, schrieb Uwe Dalluege: >>> Hi Michaël, >>> >>> I think I know why we get different >>> behaviours of OpenJUMP. >>> It is an JRE problem, I believe! >>> >>> I tested it now on several computer and different JRE. >>> >>> I *see* the error message (like you) on computer with JRE >>> >>> 1.6.0_30 (x86) and (amd64) >>> 1.6.0_31 (x86) >>> 1.6.0_33 (x86) >>> 1.7.0_02 (amd64) >>> 1.7.0_07 (x86) >>> >>> I do *not* see the error message on computer with JRE >>> >>> 1.6.0_45 (x86) and (amd64) >>> 1.7.0_17 (x86) >>> and >>> 1.7.0_21 (amd64) >>> >>> The JRE 1.7.0_21 (amd64) is my default environment. >>> >>> What JRE do you use? >>> >>> Is it possible for you to switch to JRE 1.7.0_21 >>> if you do not use it now? >>> >>> Regards >>> >>> Uwe >>> >>> >>> Am 18.04.2013 08:59, schrieb Michaël Michaud: >>>> Hi Uwe, >>>>> I would say : >>>>>> it is thrown by PostgisFeatureInputStreamIn >>>>>> it is tranformed into an error (no need to add throws clause to the >>>>>> method) >>>>>> it is wrapped into a string including sql + exception message + sql >>>>>> message >>>>>> it is thrown to the caller (see the stacktrace) >>>>> >>>>> This is the problem! I do not see a stacktrace. >>>>> Maybe you can send me the stacktrace? >>>> Here is the stack trace picked up from openjump.log >>>> >>>> 2013-04-18 08:56:31,404 INFO java.lang.Error: Error : select * from >>>> xyz >>>> ERROR: relation "xyz" does not exist >>>> Position : 15 >>>> at >>>> com.vividsolutions.jump.datastore.postgis.PostgisFeatureInputStream.getFeatureSchema(PostgisFeatureInputStream.java:95) >>>> >>>> >>>> at >>>> com.vividsolutions.jump.datastore.postgis.PostgisDSConnection.executeAdhocQuery(PostgisDSConnection.java:80) >>>> >>>> >>>> at >>>> com.vividsolutions.jump.datastore.postgis.PostgisDSConnection.execute(PostgisDSConnection.java:49) >>>> >>>> >>>> at >>>> com.vividsolutions.jump.workbench.ui.plugin.datastore.RunDatastoreQueryPlugIn.createLayer(RunDatastoreQueryPlugIn.java:72) >>>> >>>> >>>> at >>>> com.vividsolutions.jump.workbench.ui.plugin.datastore.RunDatastoreQueryPlugIn.createLayerable(RunDatastoreQueryPlugIn.java:41) >>>> >>>> >>>> at >>>> com.vividsolutions.jump.workbench.ui.plugin.datastore.AbstractAddDatastoreLayerPlugIn.run(AbstractAddDatastoreLayerPlugIn.java:33) >>>> >>>> >>>> at >>>> com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$TaskWrapper.run(TaskMonitorManager.java:152) >>>> >>>> >>>> at java.lang.Thread.run(Thread.java:662) >>>> >>>> Michaël >>>>> >>>>>> ... >>>>>> it is handled by TaskMonitorManager >>>>>> >>>>>> from there, it is displayed by WorkbenchFrame which is the >>>>>> ErrorHandler >>>>>> >>>>>> Maybe I missed something, I dont know why your System.out.println >>>>>> does not display it >>>>>> >>>>>> Regards, >>>>>> >>>>>> Michaël >>>>> >>>>> Regards >>>>> >>>>> Uwe >>>>> >>>>> >>>>>> >>>>>>> >>>>>>> Uwe >>>>>>> >>>>>>> Am 17.04.2013 11:40, schriebedgar.sol...@web.de: >>>>>>>> i suggested >>>>>>>>>> B. handle the error there, via >>>>>>>>>> JumpWorkbench.getInstance().getFrame().handleThrowable(t) >>>>>>>> below. why don't you use this? >>>>>>>> >>>>>>>> ..ede >>>>>>>> >>>>>>>> >>>>>>>> On 17.04.2013 11:27, Uwe Dalluege wrote: >>>>>>>>> Hi Michaël, >>>>>>>>> >>>>>>>>> now I have OJ3512 in eclipse. >>>>>>>>> >>>>>>>>> Is it right that the method toMessage ( ) >>>>>>>>> in com.vividsolutions.jump.workbench.ui.WorkbenchFrame >>>>>>>>> (line 1089) should be invoked by the exception of >>>>>>>>> the method public FeatureSchema getFeatureSchema() >>>>>>>>> from the class PostgisFeatureInputStream? >>>>>>>>> >>>>>>>>> >>>>>>>>> I put an System.out... into the method >>>>>>>>> >>>>>>>>> ... >>>>>>>>> public static String toMessage(Throwable t) { >>>>>>>>> String message; >>>>>>>>> System.out.println ( "WorkbenchFrame toMessage ( ) t: " + >>>>>>>>> t.getMessage ( >>>>>>>>> ) ); >>>>>>>>> ... >>>>>>>>> >>>>>>>>> >>>>>>>>> but it was not invoked if I cause an exception >>>>>>>>> with "select * from". >>>>>>>>> >>>>>>>>> Uwe >>>>>>>>> >>>>>>>>> >>>>>>>>> Am 16.04.2013 20:19, schrieb Michaël Michaud: >>>>>>>>>> Hi, >>>>>>>>>>> A. remove the catch.. it will be caught further up >>>>>>>>>> I think the catch is used to throw an error instead of an >>>>>>>>>> exception to >>>>>>>>>> conform to >>>>>>>>>> the method signature . >>>>>>>>>>> or >>>>>>>>>>> B. handle the error there, via >>>>>>>>>>> JumpWorkbench.getInstance().getFrame().handleThrowable(t) >>>>>>>>>> I did not know this trick, thanks. >>>>>>>>>> Don't know yet what is the best approach. >>>>>>>>>> >>>>>>>>>> @Uwe, >>>>>>>>>> The message you get is what SQL throws. >>>>>>>>>> It is more verbose in the case of a table name which does not >>>>>>>>>> exist. >>>>>>>>>> >>>>>>>>>> I made it a bit more verbose by adding the SQL string as it is >>>>>>>>>> sent >>>>>>>>>> to PostgreSQL (see release r3512) >>>>>>>>>> >>>>>>>>>> The modification I did in WorkbenchFrame (line 1100, I gave >>>>>>>>>> you the >>>>>>>>>> link) is to make SQL message more verbose, but in your case, >>>>>>>>>> FeatureInputStream is in charge of wrapping the message. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Michaël >>>>>>>>>> >>>>>>>>>> >>>>>>>>>>> .ede >>>>>>>>>>> >>>>>>>>>>> On 16.04.2013 14:07, Uwe Dalluege wrote: >>>>>>>>>>>> Hi Michaël, >>>>>>>>>>>> >>>>>>>>>>>> in the class PostgisFeatureInputStream >>>>>>>>>>>> from the package >>>>>>>>>>>> com.vividsolutions.jump.datastore.postgis; >>>>>>>>>>>> >>>>>>>>>>>> there is the method >>>>>>>>>>>> >>>>>>>>>>>> public FeatureSchema getFeatureSchema(){ ... >>>>>>>>>>>> >>>>>>>>>>>> which throw new Error ( ... >>>>>>>>>>>> >>>>>>>>>>>> ... >>>>>>>>>>>> catch (SQLException ex) { >>>>>>>>>>>> //savedException = ex; >>>>>>>>>>>> // from uwe >>>>>>>>>>>> System.out.println ( "PostgisFeatureInputStream >>>>>>>>>>>> getFeatureSchema() ex: " >>>>>>>>>>>> + ex.getNextException().getMessage() ); >>>>>>>>>>>> throw new >>>>>>>>>>>> Error(ex.getNextException().getMessage()); >>>>>>>>>>>> } >>>>>>>>>>>> ... >>>>>>>>>>>> >>>>>>>>>>>> The System.out... shows me >>>>>>>>>>>> when I made the simple wrong query: >>>>>>>>>>>> >>>>>>>>>>>> select * from >>>>>>>>>>>> >>>>>>>>>>>> FEHLER: Syntaxfehler am Ende der Eingabe >>>>>>>>>>>> Position: 14 >>>>>>>>>>>> >>>>>>>>>>>> Maybe in English: >>>>>>>>>>>> (ERROR: Syntaxerror at the end of line...) >>>>>>>>>>>> >>>>>>>>>>>> I do not see this exception on screen. >>>>>>>>>>>> You told me that the class WorkbenchFrame >>>>>>>>>>>> should catch this exception >>>>>>>>>>>> but I can not find the method in WorkbenchFrame >>>>>>>>>>>> which is resposible for this exception. >>>>>>>>>>>> >>>>>>>>>>>> Can you help me? >>>>>>>>>>>> >>>>>>>>>>>> Uwe >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> Am 16.04.2013 00:01, schrieb Michaël Michaud: >>>>>>>>>>>>> Hi Uwe, >>>>>>>>>>>>>> I have tested it again with the lates nightbuild >>>>>>>>>>>>>> (20130414 rev.3505) but I get no errormessage >>>>>>>>>>>>>> like you. >>>>>>>>>>>>>> Do you tested it with JRE 1.7.0_17? >>>>>>>>>>>>>> >>>>>>>>>>>>>> Do you know which class is resposible for the error-message? >>>>>>>>>>>>> This is WorkbenchFrame, >>>>>>>>>>>>> >>>>>>>>>>>>> Here is the diff from March 21th which fixed the problem (or >>>>>>>>>>>>> was suposed >>>>>>>>>>>>> to fix) >>>>>>>>>>>>> http://jump-pilot.svn.sourceforge.net/viewvc/jump-pilot/core/trunk/src/com/vividsolutions/jump/workbench/ui/WorkbenchFrame.java?sortby=date&r1=3323&r2=3393&pathrev=3393 >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> Michaël >>>>>>>>>>>>> >>>>>>>>>>>>>> Uwe >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> Am 11.04.2013 20:27, schrieb Michaël Michaud: >>>>>>>>>>>>>>> Hi, >>>>>>>>>>>>>>>> With OJ rev. 3459 >>>>>>>>>>>>>>>> and W7 (64 bit) I do not >>>>>>>>>>>>>>>> see errors or exceptions. >>>>>>>>>>>>>>>> There is no dialog window or a message >>>>>>>>>>>>>>>> in the status-line. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> I tested "Run Datastore Query" >>>>>>>>>>>>>>>> with this simple query: >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> select * from xyz >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> The table xyz does not exists in my database! >>>>>>>>>>>>>>>> But there is no error-message. >>>>>>>>>>>>>>> With a more recent version, I get the following : >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> Michaël >>>>>>>>>>>>>>>> Uwe >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> Inside the fence there is a polygon >>>>>>>>>>>>>>>>>>>> intersects the geometry from "Bauernhof" >>>>>>>>>>>>>>>>>>>> But this does not work. >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> 1. I do not see an error message. >>>>>>>>>>>>>>>>>>>> 2. What is the 0 after fence: ? >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> Regards >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> uwe >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> Am 10.04.2013 11:40, schrieb Rahkonen Jukka: >>>>>>>>>>>>>>>>>>>>> Hi, >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> They are helper shortcuts for adding a spatial filter >>>>>>>>>>>>>>>>>>>>> into the >>>>>>>>>>>>>>>>>>>>> query. >>>>>>>>>>>>>>>>>>>>> The result will be something like select * from >>>>>>>>>>>>>>>>>>>>> my_layer where >>>>>>>>>>>>>>>>>>>>> geoloc >>>>>>>>>>>>>>>>>>>>> && ${view:4326} >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> Thus only features intersecting the view, box drawn >>>>>>>>>>>>>>>>>>>>> with the >>>>>>>>>>>>>>>>>>>>> fence tool or >>>>>>>>>>>>>>>>>>>> total extents of the selected features will be >>>>>>>>>>>>>>>>>>>> selected. >>>>>>>>>>>>>>>>>>>>> -Jukka Rahkonen- >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> Uwe Dalluege wrote: >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> Hi, >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> I like to describe the >>>>>>>>>>>>>>>>>>>>>> function "Run Datastore Query" in my >>>>>>>>>>>>>>>>>>>>>> PostGIS tutorial but I can not find >>>>>>>>>>>>>>>>>>>>>> a desciption of this. >>>>>>>>>>>>>>>>>>>>>> What are the buttons >>>>>>>>>>>>>>>>>>>>>> "View, Fence and Selection" good for? >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> Regards >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> Uwe >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>> ------------------------------------------------------------------------------ >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> Precog is a next-generation analytics platform capable of >>>>>>>>>>>>> advanced >>>>>>>>>>>>> analytics on semi-structured data. The platform includes APIs >>>>>>>>>>>>> for building >>>>>>>>>>>>> apps and a phenomenal toolset for data science. Developers can >>>>>>>>>>>>> use >>>>>>>>>>>>> our toolset for easy data analysis & visualization. Get a free >>>>>>>>>>>>> account! >>>>>>>>>>>>> http://www2.precog.com/precogplatform/slashdotnewsletter >>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>> Jump-pilot-devel mailing list >>>>>>>>>>>>> Jump-pilot-devel@lists.sourceforge.net >>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>>>>>>>>>> >>>>>>>>>>>> ------------------------------------------------------------------------------ >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> Precog is a next-generation analytics platform capable of >>>>>>>>>>>> advanced >>>>>>>>>>>> analytics on semi-structured data. The platform includes APIs >>>>>>>>>>>> for building >>>>>>>>>>>> apps and a phenomenal toolset for data science. Developers >>>>>>>>>>>> can use >>>>>>>>>>>> our toolset for easy data analysis & visualization. Get a free >>>>>>>>>>>> account! >>>>>>>>>>>> http://www2.precog.com/precogplatform/slashdotnewsletter >>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>> Jump-pilot-devel mailing list >>>>>>>>>>>> Jump-pilot-devel@lists.sourceforge.net >>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>>>>>>>>> >>>>>>>>>>> ------------------------------------------------------------------------------ >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> Precog is a next-generation analytics platform capable of >>>>>>>>>>> advanced >>>>>>>>>>> analytics on semi-structured data. The platform includes APIs >>>>>>>>>>> for building >>>>>>>>>>> apps and a phenomenal toolset for data science. Developers >>>>>>>>>>> can use >>>>>>>>>>> our toolset for easy data analysis & visualization. Get a free >>>>>>>>>>> account! >>>>>>>>>>> http://www2.precog.com/precogplatform/slashdotnewsletter >>>>>>>>>>> _______________________________________________ >>>>>>>>>>> Jump-pilot-devel mailing list >>>>>>>>>>> Jump-pilot-devel@lists.sourceforge.net >>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> ------------------------------------------------------------------------------ >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Precog is a next-generation analytics platform capable of >>>>>>>>>> advanced >>>>>>>>>> analytics on semi-structured data. The platform includes APIs for >>>>>>>>>> building >>>>>>>>>> apps and a phenomenal toolset for data science. Developers can >>>>>>>>>> use >>>>>>>>>> our toolset for easy data analysis & visualization. Get a free >>>>>>>>>> account! >>>>>>>>>> http://www2.precog.com/precogplatform/slashdotnewsletter >>>>>>>>>> _______________________________________________ >>>>>>>>>> Jump-pilot-devel mailing list >>>>>>>>>> Jump-pilot-devel@lists.sourceforge.net >>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>>>>>>> >>>>>>>>> ------------------------------------------------------------------------------ >>>>>>>>> >>>>>>>>> >>>>>>>>> Precog is a next-generation analytics platform capable of advanced >>>>>>>>> analytics on semi-structured data. The platform includes APIs for >>>>>>>>> building >>>>>>>>> apps and a phenomenal toolset for data science. Developers can use >>>>>>>>> our toolset for easy data analysis & visualization. Get a free >>>>>>>>> account! >>>>>>>>> http://www2.precog.com/precogplatform/slashdotnewsletter >>>>>>>>> _______________________________________________ >>>>>>>>> Jump-pilot-devel mailing list >>>>>>>>> Jump-pilot-devel@lists.sourceforge.net >>>>>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>>>>>> >>>>>>>> ------------------------------------------------------------------------------ >>>>>>>> >>>>>>>> >>>>>>>> Precog is a next-generation analytics platform capable of advanced >>>>>>>> analytics on semi-structured data. The platform includes APIs for >>>>>>>> building >>>>>>>> apps and a phenomenal toolset for data science. Developers can use >>>>>>>> our toolset for easy data analysis & visualization. Get a free >>>>>>>> account! >>>>>>>> http://www2.precog.com/precogplatform/slashdotnewsletter >>>>>>>> _______________________________________________ >>>>>>>> Jump-pilot-devel mailing list >>>>>>>> Jump-pilot-devel@lists.sourceforge.net >>>>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>>>>> >>>>>>> ------------------------------------------------------------------------------ >>>>>>> >>>>>>> >>>>>>> Precog is a next-generation analytics platform capable of advanced >>>>>>> analytics on semi-structured data. The platform includes APIs for >>>>>>> building >>>>>>> apps and a phenomenal toolset for data science. Developers can use >>>>>>> our toolset for easy data analysis & visualization. Get a free >>>>>>> account! >>>>>>> http://www2.precog.com/precogplatform/slashdotnewsletter >>>>>>> _______________________________________________ >>>>>>> Jump-pilot-devel mailing list >>>>>>> Jump-pilot-devel@lists.sourceforge.net >>>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> ------------------------------------------------------------------------------ >>>>>> >>>>>> >>>>>> Precog is a next-generation analytics platform capable of advanced >>>>>> analytics on semi-structured data. The platform includes APIs for >>>>>> building >>>>>> apps and a phenomenal toolset for data science. Developers can use >>>>>> our toolset for easy data analysis & visualization. Get a free >>>>>> account! >>>>>> http://www2.precog.com/precogplatform/slashdotnewsletter >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Jump-pilot-devel mailing list >>>>>> Jump-pilot-devel@lists.sourceforge.net >>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>>> >>>>> >>>>> >>>> >>> >>> ------------------------------------------------------------------------------ >>> >>> Precog is a next-generation analytics platform capable of advanced >>> analytics on semi-structured data. The platform includes APIs for >>> building >>> apps and a phenomenal toolset for data science. Developers can use >>> our toolset for easy data analysis & visualization. Get a free account! >>> http://www2.precog.com/precogplatform/slashdotnewsletter >>> _______________________________________________ >>> Jump-pilot-devel mailing list >>> Jump-pilot-devel@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>> >> >> > ------------------------------------------------------------------------------ Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis & visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel