Your problem does not make sense to me; shapefile is a file format - and mysql 
is a database?

In any case it sounds like mysql wants to lookup the "spatial reference system 
identifier" for the table prova - column ogc_geom. There should be a table 
somewhere in mysql that documents what the geometry columns are; and stores 
extra metadata about them (such as the srid number they use). The srid number 
is important in determining what your geometry is measured in...

I expect you don't have your mysql database configured correctly for working 
with spatial data; I always use postgis so cannot be of much direct assistance.

-- 
Jody Garnett


On Monday, 13 June 2011 at 12:39 AM, Alessandro La Sala wrote:

> Hi guys I have some problems with an application i'm developing. I'm
> tryng to open a shapefile from a table in mysql database. But I got
> these errors:
> 12-giu-2011 14.27.57 org.geotools.jdbc.JDBCFeatureSource buildFeatureType
> AVVERTENZA: Error occured determing srid for prova.ogc_geom
> com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '4.294967295E9' in
> column '1' is outside valid range for the datatype INTEGER.
> What I'm doing wrong?????????
> 
> 
> I want to post this message, but I don't understand how to do. Can you
> explane me please??
> 
> ------------------------------------------------------------------------------
> EditLive Enterprise is the world's most technically advanced content
> authoring tool. Experience the power of Track Changes, Inline Image
> Editing and ensure content is compliant with Accessibility Checking.
> http://p.sf.net/sfu/ephox-dev2dev
> _______________________________________________
> Geotools-gt2-users mailing list
> [email protected] 
> (mailto:[email protected])
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users

------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users

Reply via email to