Thanks Lukas, To be honest, I'm just getting started with JOOQ, MySQL and GIS all at the same time.
My current Tomcat/Java project is in support of a location based game for mobile handsets. I have been supporting all of the information dynamically in memory, and I am migrating to a database back-end for persistence. I was hoping that the GIS extensions would simplify searching for nearby places of interest on the server side, I may have bitten off more than I can handle. After digging deeper on the JDBC driver, it appears that GIS is not well supported here ( http://www.dev-garden.org/2011/11/27/loading-mysql-spatial-data-with-jdbc-and-jts-wkbreader/ ). In addition, not all of the GIS functions are fully supported in MySQL (although this seems to be actively under development: http://forge.mysql.com/wiki/GIS_Functions ). There may be multiple breaks in the chain between JOOQ and MySQL All of the examples that I currently see using GIS with MySQL are using the extensions through the actual query string, for instance a POINT data type can be directly set via an SQL query something like: "GeomFromText('POINT(1.2 2.4)')". GIS integration in MySQL, directly accessible via Java, is an area of interest for me. I may need to scale my ambitions a little though, and just store Latitude and Longitude via regular table columns for the prototype. Thanks again for your help Lukas, DD
