In our application we have a generic method which encodes an SQL statement to
extract geometry from a database, via encodeGeometryColumn (found in the
database dialects). Latter on we know it is an envelope, so use
decodeGeometryEnvelope to decode it, other methods which have made use of
encodeGeometryColumn before will use decodeGeometryColumn to extract the value.
This works fine in SQLServer and Oracle since encodeGeometryEnvelope,
encodeGeometryColumn, decodeGeometryColumn and decodeGeometryEvnvelope all
encode/decoded in the same format (binary for Oracle, WKT for SQLServer).
However with Postgis, the encodeGeometryEnvelope/decodeGeometryEvnvelope is
implemented using WKT and encodeGeometryColumn/decodeGeometryColumn is
implemented in WKB which prevents them from been mixed and is inconsistent with
API used on SQLServer/Oracle.
In my instance I can work around it, but this does seem like a bug with the API
since it is inconsistent across the different dialects.
Is this an actual design decision or an over sight?
Envitia
See the world as it really is
David Morris MSc, BSc (Hons)
Software Engineer
* Tel: +44 1403 273 173
7 Fax: +44 1403 273 123
* Email: david.mor...@envitia.com<mailto:david.mor...@envitia.com>
* Web: www.envitia.com<http://www.envitia.com/>
ISO 9001:2008 Quality Management System Accreditation
[Logo for SIGNATURE.jpg]
__________________________________________________________________________________________________
This email is intended for the use of the addressee(s) only. The content and
any attachments may be privileged and/or
contain confidential information and copyright material. If you are not the
addressee you may not use, copy or disclose
the information in it. If you receive this email by mistake, please advise the
sender by using the reply facility in your email
software or the contact information above, before deleting it and destroying
any hard copies.
We accept no responsibility or liability for content in this email that is
personal or otherwise unconnected with our business.
Although this email and attachments have been swept for viruses, we do not
accept liability for any loss arising from its use.
Envitia Ltd
Registered No: 2348404 England
North Heath Lane, Horsham, West Sussex RH12 5UX
__________________________________________________________________________________________________
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
