Daniel, Sounds like an interesting project you're starting there. If MySQL is not a must, you could also evaluate PostGIS (from Postgres). Maybe, an integration with JDBC is a bit simpler there? But JDBC is an old standard. In the mean time, databases have evolved quicker than their JDBC drivers, unfortunately.
If you're still interested in using jOOQ for your database interaction, you could try to implement your own QueryParts, e.g. by extending CustomField for the POINT object: http://www.jooq.org/manual/JOOQ/Extend/ Writing support for GIS functions would be similar. I'll be adding more customisation support soon in jOOQ, so any discoveries you may make might lead jOOQ a little bit more towards your direction. Anyway, I put this on the roadmap: https://sourceforge.net/apps/trac/jooq/ticket/982 Cheers Lukas 2011/12/7 Danny D <[email protected]>: > 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 > > >
