Re: [JPP-Devel] OpenJUMP 1.3.1 maintenance release

Nils Kuhn Wed, 09 Dec 2009 00:14:04 -0800

Hi Michaël,
here is the StackTrace from eclipse:

org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:235)
    at com.vividsolutions.jump.datastore.postgis.PostgisFeatureInputStream.init(PostgisFeatureInputStream.java:50)
    at com.vividsolutions.jump.datastore.postgis.PostgisFeatureInputStream.getFeatureSchema(PostgisFeatureInputStream.java:90)
    at com.vividsolutions.jump.workbench.model.cache.DynamicFeatureCollection.query(DynamicFeatureCollection.java:80)
    at com.vividsolutions.jump.workbench.model.cache.CachingFeatureCollection$2.iterator(CachingFeatureCollection.java:107)
    at com.vividsolutions.jump.workbench.ui.renderer.ImageCachingFeatureCollectionRenderer.renderHook(ImageCachingFeatureCollectionRenderer.java:53)
    at com.vividsolutions.jump.workbench.ui.renderer.ImageCachingFeatureCollectionRenderer.renderHook(ImageCachingFeatureCollectionRenderer.java:79)
    at com.vividsolutions.jump.workbench.ui.renderer.ImageCachingRenderer$1.run(ImageCachingRenderer.java:84)
    at com.vividsolutions.jump.workbench.ui.renderer.ThreadQueue$Worker.run(ThreadQueue.java:86)
java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
    at com.vividsolutions.jump.workbench.model.cache.DynamicFeatureCollection$1$1.hasNext(DynamicFeatureCollection.java:123)
    at com.vividsolutions.jump.workbench.model.cache.CachingFeatureCollection$2$1.hasNext(CachingFeatureCollection.java:118)
    at com.vividsolutions.jump.workbench.ui.renderer.ImageCachingFeatureCollectionRenderer.renderHook(ImageCachingFeatureCollectionRenderer.java:53)
    at com.vividsolutions.jump.workbench.ui.renderer.ImageCachingFeatureCollectionRenderer.renderHook(ImageCachingFeatureCollectionRenderer.java:79)
    at com.vividsolutions.jump.workbench.ui.renderer.ImageCachingRenderer$1.run(ImageCachingRenderer.java:84)
    at com.vividsolutions.jump.workbench.ui.renderer.ThreadQueue$Worker.run(ThreadQueue.java:86)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:235)
    at com.vividsolutions.jump.datastore.postgis.PostgisFeatureInputStream.init(PostgisFeatureInputStream.java:50)
    at com.vividsolutions.jump.datastore.postgis.PostgisFeatureInputStream.getFeatureSchema(PostgisFeatureInputStream.java:90)
    at com.vividsolutions.jump.workbench.model.cache.DynamicFeatureCollection.query(DynamicFeatureCollection.java:80)
    at com.vividsolutions.jump.workbench.model.cache.CachingFeatureCollection$2.iterator(CachingFeatureCollection.java:107)
    ... 4 more

regards Nils

Michaël Michaud schrieb:

Hi Nils,

I'm not aware of this bug because I always use the query datastore plugin.
Can you give the exact error message you get when you try to load empty 
table/view.


Michaël

Nils Kuhn a écrit :

Hi all,

just a question:
There is a bug in the "Load Data Store Layer"-function with loading 
empty geotables or views (syntax error). For that reason I use the 
separate postgis-plugin for working with postgis-layers.
Is this bug known (and maybe fixed) in version 1.3.1?

Best regards,
Nils

Stefan Steiniger schrieb:

Hei all,

After performing now a few tests with ArcGIS Feature to Raster tool and 
the Sextante rasterization function I think the fix I did for the pixel 
North-West shift when writing TIFF raster images is working as it 
supposed to (using the pirol/sextante file image export). That is raster 
and vector data are properly aligned when Open... >Sextante Raster Image 
is used.
So, I made a new OJ 1.3.1 release with that bug fix. It also contains 
the changes to the PostGIS query dialog (using a fence) to spatially 
restrict queries - made by Michael (thank you!).

That is, the new release is probably only interesting to PostGIS users 
and Sextante Users. Maybe interesting for both is an additional 
(Windows) download I created that contains both plugins plus the Cadplan 
printing plugin. I created this version for teaching a GIS course. 
According to user comments, this version (i.e. Sextante) unforntunately 
doesn't work on Ubuntu.

The downloads are available here:
http://sourceforge.net/projects/jump-pilot/files/


PS: Two side notes on the stats - showing that our work seems to spark 
some interest :)

i) The download statistic graphs on Sourceforge seem to be delayed now 
by 2 days or; and sometimes not working. However, it turns out we have 
about 1000 downloads/month for the OpenJUMP windows setup file (alone).

ii) Since we switched the domain wwww.openjump.org to our Sourceforge 
webpage I get some interesting user statistics (using Google Analytics). 
While we had about 30 visits on peak days for the old page, we have now 
up to 230 visits (i.e. unique visitors) a day. That shows how 
significant the openjump.org domain was/is.

cheers from sunny but cold Calgary
stefan

------------------------------------------------------------------------------
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing. 
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel



------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

-- 
Dipl.-Biol. Nils Kuhn
Email: nils.k...@bws-gmbh.de
Fon: +49 (0)40 - 23 16 65-26
Fax: +49 (0)40 - 23 16 65-01

BWS GmbH 
Gotenstraße 14
D-20097 Hamburg
Sitz der Gesellschaft: Hamburg
Amtsgericht Hamburg: HRB 87830
Geschäftsführer:
Dipl.-Geol. Robert Dési
Dipl.-Geogr. Hydr. Lutz Krob


*************************************************************************************************************

HINWEIS: 
Diese E-Mail und beigefügte Dateien dienen nur der Vorabstimmung und stellen 
keine rechtswirksame Willenserklärungen oder Beratungsleistungen dar. Es können 
keine Haftungsansprüche gegenüber der BWS GmbH geltend gemacht werden. 
Alle rechtswirksamen Äußerungen (Verträge, Stellungnahmen, Berechnungen, Vermerke etc.)
erhalten Sie von uns in schriftlicher Form und gegebenenfalls auf separatem Datenträger.
Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, 
informieren Sie bitte den Absender und vernichten Sie diese E-Mail. 
Unerlaubtes Kopieren und Weiterleiten dieser E-Mail sind nicht gestattet.

*************************************************************************************************************

------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev

_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Re: [JPP-Devel] OpenJUMP 1.3.1 maintenance release

Reply via email to