I'm having some problems with mysql database as my spatial data source. I
create a new feature store and then a feature type. Everything goes well
untill i press Apply. Then i get this exception. What am i doing wrong?
shapes:road org.geotools.data.DataSourceException: SQL Error building
FeatureType for road Syntax error or access violation, message from
server: "You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'://www.test.com.ceste_utm WHERE 0=1' at line 1"
No one among the developers as far as I know. You can try on
the users list, but I don't remember hearing about this datastore in
the last two months, so probably the answer is no even there...
It should be MySQL. Anyway i fixed the above problem.
Now i can execute GetFeature and it works with no problems. But i can not
execute WMSGetMap. I'm using Geoserver 1.5.x and i get this exception:
<?xml version="1.0" encoding="UTF-8" standalone="no" ?><!DOCTYPE
ServiceExceptionReport SYSTEM
"http://localhost:50/geoserver/schemas//wms/1.1.1/WMS_exception_1_1_1.dtd">
<ServiceExceptionReport version="1.1.1"> <ServiceException>The provided
envelope is outside the source CRS definition area</ServiceException> </ServiceExceptionReport>
Ouch... can you provide us with the CRS you're using and the bounding
box used with the query?
I still haven't moved to 1.5.x (Geosolutions guys are still the drivers
for that release) and never seen this error.
Cheers
Andrea
but if i change the srs to 2170. everything goes well but i get back an
empty picture.
--
View this message in context: http://www.nabble.com/MySQL-tf2779319.html#a7794566
Sent from the GeoServer - Dev mailing list archive at Nabble.com.
This request does not make sense, since the coordinates you're using
are outside the world in lat/lon
but if i change the srs to 2170. everything goes well but i get back an
empty picture.
This is where the problem lies I guess. Can you enable FINE logging and
see what queries are issued?
Moreover, is your data really declared to be in 2170?
How did u fix the Error you were mentioning earlier?
worldbase:world_table
org.geotools.data.DataSourceException: SQL Error building FeatureType for
world_table Syntax error or access violation message from server: "You have
an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near
':\\www.worlddb.com.world_table WHERE 0=1' at line 1"
GeoUser wrote:
It should be MySQL. Anyway i fixed the above problem.
Now i can execute GetFeature and it works with no problems. But i can not
execute WMSGetMap. I'm using Geoserver 1.5.x and i get this exception:
<?xml version="1.0" encoding="UTF-8" standalone="no" ?><!DOCTYPE
ServiceExceptionReport SYSTEM
"http://localhost:50/geoserver/schemas//wms/1.1.1/WMS_exception_1_1_1.dtd">
<ServiceExceptionReport version="1.1.1"> <ServiceException>The
provided envelope is outside the source CRS definition
area</ServiceException> </ServiceExceptionReport>
i constructed WMS request from the data i got in geoserver.
then i restarted geoserver. and it started working.
daedalus12 wrote:
Hi,
How did u fix the Error you were mentioning earlier?
worldbase:world_table
org.geotools.data.DataSourceException: SQL Error building FeatureType for
world_table Syntax error or access violation message from server: "You
have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near
':\\www.worlddb.com.world_table WHERE 0=1' at line 1"
GeoUser wrote:
It should be MySQL. Anyway i fixed the above problem.
Now i can execute GetFeature and it works with no problems. But i can not
execute WMSGetMap. I'm using Geoserver 1.5.x and i get this exception:
<?xml version="1.0" encoding="UTF-8" standalone="no" ?><!DOCTYPE
ServiceExceptionReport SYSTEM
"http://localhost:50/geoserver/schemas//wms/1.1.1/WMS_exception_1_1_1.dtd">
<ServiceExceptionReport version="1.1.1"> <ServiceException>The
provided envelope is outside the source CRS definition
area</ServiceException> </ServiceExceptionReport>
i constructed WMS request from the data i got in geoserver.