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

Reply via email to