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