Hi,
Try it like "select asbinary(geom),attribute_1,attribute_2 from table".
-Jukka Rahkonen-
-----Alkuperäinen viesti-----
Lähettäjä: [EMAIL PROTECTED] puolesta: Luiz Gustavo Ribeiro Pagani
Lähetetty: ti 22.4.2008 5:05
Vastaanottaja: jump-pilot-devel@lists.sourceforge.net
Aihe: [JPP-Devel] Datastore query - Error: Unknown WKB type
Hi,
I load some ESRI Shapes in PostGIS using shp2pgsql loader.
I can successful add and use this tables in OpenJUMP using "Add Datastore
Layer" functionality.
But trying to execute a valid query(select * from table) to load the same
tables, "Run Datastore query" functionality threw this exception:
com.vividsolutions.jts.io.ParseException: *Unknown WKB type 48*
at com.vividsolutions.jts.io.WKBReader.readGeometry(WKBReader.java:164)
at com.vividsolutions.jts.io.WKBReader.read(WKBReader.java:127)
at com.vividsolutions.jts.io.WKBReader.read(WKBReader.java:112)
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(Unknown Source)
Im using PostGIS 1.3.2 for PostgreSQL 8.3 and OpenJUMP 1.2.
Anyone knows how to solve this problem?
--
Luiz Gustavo Ribeiro Pagani
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
