Hi Ryan,
Can you include the java stack trace you get when you attempt to calculate
the bounds? Also if you could include a little sql script to create the
table and populate it with a few records that would help a lot.
Thanks.
-Justin
On Mon, Oct 25, 2010 at 10:03 AM, Ryan Williams <
[email protected]> wrote:
> 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
>
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
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
