sorry, unfortunately i have no postgis set up here. ..ede
On 17.04.2013 11:54, Uwe Dalluege wrote:
> 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
