ATTENTION: MySQL does not really support the OpenGIS Spec. If you read the manual carefully, you will see that the geometric operations use the bounding box of the geometries, not the geometry itself.
I think this is not what you want. Databases at no charge having these capabilities are PostGIS Oracle XE DB2 Community Edition + Spatial Extender Geotools hides the db access behind class JDBCFeatureStore. If you plan to modifying geometries and other tables in one transaction, contact me again, since the JDBCFeatureStore is not able to handle this out of the box. Andre-John Mas writes: > Hi, > > I am new to GeoTools and I am currently investigating what it has to offer, > and I am hoping someone can help speed me in learning the basics: > > My goal is to be able to use the OpenGIS extensions in MySQL to be able to > store geographical data, such as longitude/latitude and use the built in > functions. Since MySQL doesn't offer anything in its JDBC drivers, I need > a way to easily access this data. > > I have looked at the GeoTools examples in the wiki, but I am unable to find > anything as simple as a HelloWorld that would show me how to query a MySQL > database, using JDBC and then make sense of the OpenGIS values with Geotools. > > Additionally, in the binary distribution, amongst the 157 jars, what is the > minimum set of jars do I need to be able to use with MySQL and JDBC? > > Lastly, has anyone used GeoTools with Hibernate or JPA? > > Thanks > > André-John > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Geotools-gt2-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Geotools-gt2-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
