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
