Hi Michaël,
Am 17.04.2013 20:43, schrieb Michaël Michaud:
> Hi Uwe,
>> 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?
>
> You tend to change your test from one mail to the other
Sorry for confusing you but I posted this test with my mail
from 16.04.2013 : 14:07
and you answered at
16.04.2013 : 20:19.
But I think this is not the problem.
The problem is not the text of the message,
the problem is that I do not get such a nice
Frame (JOptionPane?) with an error message like you.
My computer works with W7 (64bit) and JRE 1.7_21 (64bit) from Oracle.
Maybe it is a problem of the JRE?
What kind of OS and JRE do you have?
> With "select * from", I get the same message as you
> With "select * from xyz" where xyz does not exists, I get
> a more informative message
>
> I think this is also what you get from pgAdmin.
> From my last commit, you have also the query string
> as it has been sent to the server :
>
>
>
>
>
>
> Don't know exacly what way the exception follows in theses cases.
>
> 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?
> ...
> 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
