Ok, I am able to connect to my data store which is Ms Sql Server 2008
(Express edition). Perhaps, I am not able to show anything on my OpenLayer
map.
Example of point in my database:
POINT (2.66131 48.8792)
POINT (2.66131 48.8792)
POINT (2.67789 48.8982)
POINT (2.67789 48.8982)
POINT (2.70361 48.9402)
POINT (2.76454 48.9866)
In my GeoServer 2.0.2, I actually use the default style for point (Red
square point). The EPSG of these point in the database is "0" because
GeoServer when querying the database it does a polygon to look-in in EPSG:0.
In the configuration of GeoServer, it is 4326 with boundaries (BBOX) like
this:
Min X: -180
Min Y: -90
Max X: 180
Max Y: 90
Definition of my table
id int (PK)
lon float
lat float
geom geometry
Here's an example of the query coming from GeoServer:
SELECT "id",CAST("geom".STSrid as VARCHAR) + ':' + "geom".STAsText()
as "geom" FROM "TestGeom" WHERE
"geom".Filter(geometry::STGeomFromText('POLYGON ((-236.25 -120.234375,
-236.25 120.234375, 236.25 120.234375, 236.25 -120.234375, -236.25
-120.234375))', 0)) = 1
It returns a list of points but it does not show in the openlayer "preview
mode".
Is there anything I am missing?
*System:* Windows XP with GeoServer + JDBC 3.0 plugin + the implementation
of MS SQL Server available on sourceforge.
*Java JDK/JRE: *1.6
Note: I was looking at the prompt command line window and I saw a lot of
error coming out when the query was returning.
Nordès
------------------------------------------------------------------------------
Virtualization is moving to the mainstream and overtaking non-virtualized
environment for deploying applications. Does it make network security
easier or more difficult to achieve? Read this whitepaper to separate the
two and get a better understanding.
http://p.sf.net/sfu/hp-phase2-d2d
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
