David Potts wrote:
Hi
I am using hibernate spatial as a front end to postgis(8.3) database
within a java program.
As far as I can tell, a valid sql statment is generated, I pass in
what I think is a valid geometry string.
I am getting a 'invalid geometry' error message.
Short off rebuilding the liblwgeom library is there any easy way off
getting a copy of the string that postgis being passed?
I want to ensure that what I am passing in to hibernate is actual being
supplied to postgis correctly.
I have turned on on the postgres statment processing in the postgres log
just shows the geometry string being passed in as the string '$1.' Which
is I assume its method of showing a binary argument.
D.
Hmmm newer versions of PostgreSQL should log the bind parameters with
log_statement set to 'all'. See
http://www.postgresql.org/docs/8.3/static/runtime-config-logging.html#GUC-LOG-STATEMENT
for more details.
HTH,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users