Hi Ede,
I like to find an error in OJ.
Michaël can see this error but I do not see it.
There must be something different between
Michaël environment and my environment.
Can *you* reproduce this error?
1. File>Run Datastore Query.
2. Connect to a PostGIS database.
3. Type after Query: select * from
(this must cause an SQL-Exception)
Michaël can see this excpetion and you?
Uwe
Am 17.04.2013 11:40, schrieb edgar.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
