<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7638.1">
<TITLE>RE: [postgis-users] Using Postgis with hibernate</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Hi David,<BR>
<BR>
there is a tutorial available here on using postgis and hibernate<BR>
<BR>
<A HREF="http://postgis.refractions.net/support/wiki/index.php?SpatialEJB3">http://postgis.refractions.net/support/wiki/index.php?SpatialEJB3</A><BR>
<BR>
This defines a hibernate geometry user type that maps a postgis geometry (so anything that subclasses geometry) to and from postgis.<BR>
<BR>
in addition in the subversion source control there is also a hibernate postgis dialect to allow you to make hibernate spatial object queries.<BR>
<BR>
Though the tutorial uses Java 5 annotations, this also works with hibernate property files.<BR>
<BR>
Please let me know if you have any problems.<BR>
<BR>
thanks,<BR>
<BR>
Norman<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: postgis-users-bounces@postgis.refractions.net on behalf of David Robison<BR>
Sent: Mon 3/19/2007 3:46 AM<BR>
To: postgis-users@postgis.refractions.net<BR>
Subject: [postgis-users] Using Postgis with hibernate<BR>
<BR>
I am running a standalone console application which uses Hibernate3 and connects to a postgis database. I have been successful in reading the geomoetry from the database when I define my geometry column in Hibernate as<BR>
<BR>
<property<BR>
name="theGeom"<BR>
type="java.lang.String"<BR>
formula="AsText(force_2d(the_geom))"<BR>
length="-1"<BR>
/><BR>
<BR>
This returns the geometry as a WKT string that can easily be read by my application. However, using this definition I am not able to set the value of the geometry. I have read the mailing list about postgis and hibernate and am just more confused. Is there a simple way to define the geometry column to Hibernate to make getting and setting the geometry simple? I would even be pleased with referencing the geometry data as a byte[] or a String from within Java.<BR>
<BR>
Any help and/or clarification would be appreciated.<BR>
<BR>
David Robison<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>