Hi there, I have two tables each containing point geometries of type 'geometry'. I need to find out the list of points from the two table within 'x' miles vicinity. So, I am trying to do something like
select pointA, point B FROM tableA a INNER JOIN tableB b on ST_DWithin(a.shape::geography, b.shape::geography, 1609) While this works without issues in pgAdmin, I get the following error when executing it via JDBC. org.postgresql.util.PSQLException: ERROR: type "geography" does not exist I have postgis-jdbc-2.2.1.jar and postgresql-42.2.4.jar in my classpath and using "org.postgis.DriverWrapper" driver class. And my connection string is in the format jdbc:postgresql_postGIS://<host>:<port>/<db>?currentSchema=<schema> Of course, I can have another column of type 'geography' created in tableA and tableB and execute the query without having to do the runtime type conversion. But I am trying to find out if I can avoid it by registering 'geography' as a valid type with Postgres / PostGIS driver. Thanks in advance for your insights. Thanks, Rama Sundaram ________________________________ This message is intended only for the use of the addressee and may contain information that is PRIVILEGED AND CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify the sender immediately. Thank you.
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
