Thanks Jukka, It works!
2009/3/31 Rahkonen Jukka <jukka.rahko...@mmmtike.fi> > Hi, > > You need to query the geometry column as binary, like > > select asbinary(geom), attr from my_table > > -Jukka- > > Nacho Uve wrote: > > I've tried with 'Run database query' and now the exception is parsing WKB > types [1]. But again with all my postgis layers (polygons and linestrings). > > Nacho. > > [1] > com.vividsolutions.jts.io.ParseException: Unknown WKB type 48 > at com.vividsolutions.jts.io.WKBReader.readGeometry(WKBReader.java:183) > at com.vividsolutions.jts.io.WKBReader.read(WKBReader.java:137) > at com.vividsolutions.jts.io.WKBReader.read(WKBReader.java:118) > at > > com.vividsolutions.jump.datastore.postgis.PostgisValueConverterFactory$WKBGeometryValueConverter.getValue(PostgisValueConverterFactory.java:75) > at > > com.vividsolutions.jump.datastore.postgis.PostgisResultSetConverter.getFeature(PostgisResultSetConverter.java:47) > at > > com.vividsolutions.jump.datastore.postgis.PostgisFeatureInputStream.getFeature(PostgisFeatureInputStream.java:72) > at > > com.vividsolutions.jump.datastore.postgis.PostgisFeatureInputStream.readNext(PostgisFeatureInputStream.java:66) > at > > com.vividsolutions.jump.io.BaseFeatureInputStream.hasNext(BaseFeatureInputStream.java:38) > at > > com.vividsolutions.jump.workbench.ui.plugin.datastore.RunDatastoreQueryPlugIn.createLayer(RunDatastoreQueryPlugIn.java:55) > at > > com.vividsolutions.jump.workbench.ui.plugin.datastore.RunDatastoreQueryPlugIn.createLayerable(RunDatastoreQueryPlugIn.java:27) > at > > com.vividsolutions.jump.workbench.ui.plugin.datastore.AbstractAddDatastoreLayerPlugIn.run(AbstractAddDatastoreLayerPlugIn.java:32) > at > > com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$TaskWrapper.run(TaskMonitorManager.java:149) > at java.lang.Thread.run(Thread.java:619) > > 2009/3/31 Larry Becker <becker.la...@gmail.com> > > > I don't know what everyone else has found, but I have concluded that the > > DataStore code is fundamentally flawed. Perhaps we should remove it from > > the menu. > > > > Larry > > > > > > On Tue, Mar 31, 2009 at 11:01 AM, Rahkonen Jukka < > > jukka.rahko...@mmmtike.fi> wrote: > > > >> Hi, > >> > >> I get the same error. However, database query in the Layer menu works > >> with the same connection and PostGIS table. > >> > >> -Jukka- > >> > >> > >> Nacho Uve wrote: > >> > >> Yes, the same error with all layers on my localhost postgis and at in > the > >> office server. > >> :( > >> > >> > >> > >> 2009/3/31 Sunburned Surveyor <sunburned.surve...@gmail.com> > >> > >> > Nacho, > >> > > >> > Do you get the same error when you load a different layer from > PostGIS? > >> > > >> > The Sunburned Surveyor > >> > > >> > On Tue, Mar 31, 2009 at 6:59 AM, Nacho Uve <nacho...@gmail.com> > wrote: > >> > > Hello, > >> > > > >> > > I'm running the nightly build of OJ and I got the exception [1] when > I > >> > try > >> > > to load the layer "tramos2" of my localhost postgis. > >> > > Best regards, > >> > > Nacho > >> > > > >> > > > >> > > [1] > >> > > com.vividsolutions.jts.util.AssertionFailedException: If this event > is > >> > being > >> > > fired because you are constructing a Layer, cat will be null because > >> you > >> > > haven't yet added the Layer to the LayerManager. While constructing > a > >> > layer, > >> > > you should set firingEvents to false. (Layerable = tramos2) > >> > > at com.vividsolutions.jts.util.Assert.isTrue(Assert.java:71) > >> > > at > >> > > > >> > > >> > com.vividsolutions.jump.workbench.model.LayerManager.fireLayerChanged(LayerManager.java:446) > >> > > at > >> > > > >> > > >> > com.vividsolutions.jump.workbench.model.AbstractLayerable.fireLayerChanged(AbstractLayerable.java:95) > >> > > at > >> > > > >> > > >> > com.vividsolutions.jump.workbench.model.Layer.setFeatureCollectionModified(Layer.java:541) > >> > > at > >> > > > >> > > >> > com.vividsolutions.jump.workbench.ui.plugin.OpenProjectPlugIn.load(OpenProjectPlugIn.java:259) > >> > > at > >> > > > >> > > >> > com.vividsolutions.jump.workbench.ui.plugin.datastore.AddDatastoreLayerPlugIn.createLayer(AddDatastoreLayerPlugIn.java:47) > >> > > at > >> > > > >> > > >> > com.vividsolutions.jump.workbench.ui.plugin.datastore.AddDatastoreLayerPlugIn.createLayerable(AddDatastoreLayerPlugIn.java:61) > >> > > at > >> > > > >> > > >> > com.vividsolutions.jump.workbench.ui.plugin.datastore.AbstractAddDatastoreLayerPlugIn.run(AbstractAddDatastoreLayerPlugIn.java:32) > >> > > at > >> > > > >> > > >> > com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$TaskWrapper.run(TaskMonitorManager.java:149) > >> > > at java.lang.Thread.run(Thread.java:619) > >> > > > >> > > > >> > > > >> > > >> > ------------------------------------------------------------------------------ > >> > > > >> > > _______________________________________________ > >> > > Jump-pilot-devel mailing list > >> > > Jump-pilot-devel@lists.sourceforge.net > >> > > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > >> > > > >> > > > >> > > >> > > >> > > >> > ------------------------------------------------------------------------------ > >> > _______________________________________________ > >> > Jump-pilot-devel mailing list > >> > Jump-pilot-devel@lists.sourceforge.net > >> > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > >> > > >> > >> > >> > >> > ------------------------------------------------------------------------------ > >> _______________________________________________ > >> Jump-pilot-devel mailing list > >> Jump-pilot-devel@lists.sourceforge.net > >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > >> > > > > > > > > -- > > http://amusingprogrammer.blogspot.com/ > > > > > > > ------------------------------------------------------------------------------ > > > > _______________________________________________ > > Jump-pilot-devel mailing list > > Jump-pilot-devel@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > > > > > > > ------------------------------------------------------------------------------ > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >
------------------------------------------------------------------------------
_______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel