MySQLInnoDBSpatialDialect

[Carsten Höhne-3]

Hello,
short Question: Is it easy to create an spatial Dialect for MySql InnoDB?
We are working with InnoDB Tables to use Transactions and foreign keys. We do not want to drop this support.
InnoDB is supported. Read here.
From the mysql reference documentation

"MySQL supports spatial extensions to allow the generation, storage, and analysis of geographic features. Before MySQL 5.0.16, these features are available for MyISAM tables only. As of MySQL 5.0.16, InnoDB, NDB, BDB, and ARCHIVE also support spatial features."

 
Ciao,
Carsten

_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users

[Karel Maesen]

Hi,

This could be very simple (having the spatial dialect extends the  
specialized Hibernate dialect for Mysql InnoDB, rather than the  
vanilla MySQL dialect). I'll check this later this day.

Can you build Hibernate Spatial from source? There are some pointers  
on the mailing list on how to do that.

Regards,

Karel

On 19 Feb 2008, at 11:51, Carsten Höhne wrote:

> Hello,
> short Question: Is it easy to create an spatial Dialect for MySql  
> InnoDB?
> We are working with InnoDB Tables to use Transactions and foreign  
> keys. We do not want to drop this support.
> InnoDB is supported. Read here.
> From the mysql reference documentation
> "MySQL supports spatial extensions to allow the generation,  
> storage, and analysis of geographic features. Before MySQL 5.0.16,  
> these features are available for MyISAM tables only. As of MySQL  
> 5.0.16, InnoDB, NDB, BDB, and ARCHIVE also support spatial features."
>
>
> Ciao,
> Carsten
> _______________________________________________
> hibernatespatial-users mailing list
> [hidden email]
> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> hibernatespatial-users

_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users

[Carsten Höhne-3]

Hello,

This could be very simple (having the spatial dialect extends the
specialized Hibernate dialect for Mysql InnoDB, rather than the
vanilla MySQL dialect). I'll check this later this day.

This is, what i intended to do. But the real solution is to have both dialects on board:-)Thats a little bit more complicated, 
but i do not know both the internas of hibernatespatiaal and the creation of a dialect,yet:-( 

Can you build Hibernate Spatial from source? There are some pointers
on the mailing list on how to do that.

I will try it some time around Easter.
(The InnoDB Dialect is only really needed, if either the schema  or foreign keys should be created.
For accessing the tables the normal dialect is sufficient. So we are taking the time until Easter to become familar with hibernatespatial.)
Ciao,
Carsten

_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users