Hi all, I'm working on getting Geoserver (2.0.SNAPSHOT) to connect to a mySQL database as a store / data source and publish a layer from that. I've successfully connected to the mySQL database and created a store in Geoserver. however, I'm not able to successfully publish a layer from that table. I get to the layer configuration screen, in the 'Data' tab, and I'm not able to successfully set the Coordinate Reference Systems. I set the Declared SRS to EPSG:4326, SRS handling to 'force declared'. If I click the 'compute from data' link I get a big Java error. If I click 'compute from native' nothing happens (obviously, because there are no native bounds set yet) I've read that mySQL is not 'spatially aware' and so it doesn't know anything about it's SRS or it's bounds. So then, do I need to manually enter in the bounding box numbers? I've found several docs on how to create a mySQL data source, but none on the nuances of actually publishing a layer from that source.
I have added a geometry type column in the mySQL table and used some mySQL functions to put points in that column based on a lat and a lon field in the same table. I understand mySQL isn't the best option for spatial data, but I'm trying to integrate with an existing application that has everything stored in mySQL, and there's no chance of changing that. Thanks, Ryan -- Ryan Williams, GISP GIS Analyst / Programmer PAQ Interactive Inc. Monticello, IL www.paqinteractive.com ------------------------------------------------------------------------------ Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
