Hibernate spatial & Grails

2 Messages Forum Options Options
Embed this topic
Permalink
K4rsten
Hibernate spatial & Grails
Reply Threaded More
Print post
Permalink
Hello,

first thank you all for the great work. I'm a newbie with PostGis and
the webframework  Grails and I'm trying to build a simple app to
insert GPS-Data into PostGIS.

I was quite successfull and managed to configure Grails. I have added
a Geometry property to a groovy domain object and hibernate builds the
table automatically, the column is of the right type "geometry" and I
can insert values =).

But it seems that hibernate spatial, when creating the schema, does
not use the function "addgeometrycolumn". There is no constraint on
the column for the correct srid and there is no reference in the
postgis-table "geometry_columns". Some questions:

Can I change the way the table is created? Or do I have to create it
manually? In PostGIS you have to define the SRID parameter when adding
the column to the table. Can I specify that in hibernate spatial?

thank you & kind regards,

Karsten
_______________________________________________
hibernatespatial-users mailing list
hibernatespatial-users@...
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users
Karel Maesen
Re: Hibernate spatial & Grails
Reply Threaded More
Print post
Permalink
Hi Karsten,

You're right. The addGeometrycolumn type of operations aren't run  
automatically. We plan to add this feature soon (as soon as we\ve  
figured out how to extend Hibernate's schema creation functions). For  
now you either create your tables manually, or you sue schema  
generation and manually add the SRID constraint and the spatial  
metadata after that.

Regards,

Karel


On 12 Aug 2008, at 20:55, Karsten Violka wrote:

> Hello,
>
> first thank you all for the great work. I'm a newbie with PostGis and
> the webframework  Grails and I'm trying to build a simple app to
> insert GPS-Data into PostGIS.
>
> I was quite successfull and managed to configure Grails. I have added
> a Geometry property to a groovy domain object and hibernate builds the
> table automatically, the column is of the right type "geometry" and I
> can insert values =).
>
> But it seems that hibernate spatial, when creating the schema, does
> not use the function "addgeometrycolumn". There is no constraint on
> the column for the correct srid and there is no reference in the
> postgis-table "geometry_columns". Some questions:
>
> Can I change the way the table is created? Or do I have to create it
> manually? In PostGIS you have to define the SRID parameter when adding
> the column to the table. Can I specify that in hibernate spatial?
>
> thank you & kind regards,
>
> Karsten
> _______________________________________________
> hibernatespatial-users mailing list
> hibernatespatial-users@...
> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> hibernatespatial-users

_______________________________________________
hibernatespatial-users mailing list
hibernatespatial-users@...
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users