[postgis] JDBC with Postgis 0.6.2

[Paul Ramsey]

Oh, the reason it does not work now, is *probably* because your SQL is
not strictly speaking OpenGIS compliant. OpenGIS says  (quietly) that if
you do a "select geom from mytable" you will get the canonical form,
which could be absolutely anything. In our case, it is the funny form
with SRID=1; prepended to it. If you want normal, nice geometries, which
the JDBC objects can understand, ask for "select AsText(geom) as geom
from mytable" and all should work just as before.

David Graham wrote:
> 
> Have been using JDBC with the 0.2 PostGIS.  Now I have upgraded to 0.6.2
> and it does not work.
> 
> Here is the problem: the new introduction of the SRID.
> 
> I looked at the JDBC code released with 0.6.2 and it is the same old
> code that will not run with 0.6.2.
> 
> Questions:
> 
> Has anyone fixed this yet?
> 
> If not is anyone interested in a hack that totally ignores the SRID?
> 
> Dave Graham
> information integration and imaging, LLC
> dgraham at i3.com
> http://www.i3.com
> 

-- 
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey at refractions.net
     | Phone: (250) 885-0632
     \_

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Sponsored by VeriSign - The Value of Trust
Secure all your Web servers now - with a proven 5-part
strategy. The FREE Server Security Guide shows you how.
http://us.click.yahoo.com/uCuuSA/VdiDAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/