|
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
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)
...
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
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
|
------------------------------------------------------------------------------
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
