[Geoserver-users] oracle spatial

Maybe there is no entry for the layer in USER_SDO_GEOM_METADATA?

-----Original Message-----
From: geoserver-users-bounces@lists.sourceforge.net [mailto:geoserver-users-bounces@lists.sourceforge.net] On Behalf Of Daniel Goetz

Sent: 22. august 2006 12:59
To: geoserver-users@lists.sourceforge.net
Subject: [Geoserver-users] oracle spatial

Hi community,

I am struggling on serving data (polygon and line) lying in an oracle spatial database via geoserver as an WMS-server.

When configureing the data-section in the admin tool for oracle spatial data everything went find till I try to configure the setting in the config/data/featuretype section. When I push the “gnerate” button to automatically fill in the lat/lon bbox values an error-message on the left side of my browser window appears saying: “The FeatureType ‘RWG_TBS’ has a NULL extent. HINT: the dataset is empty or has no default geometry attribute.” But of course the Featuretype “RWG_TBS” has not a NULL-extent. One line of the feature-class “RWG_TBS” for example looks like this:

SDO_GEOMETRY(SDO_GTYPE(2003) SDO_SRID(82032) SDO_POINT(X(NULL) Y(NULL) Z(NULL) ) SDO_ELEM_INFO(1,1005,1,1,2,1) SDO_ORDINATES(4439277.45331143,5478678.34845644,4439076.925303,5478324.6435288,4439831.85420484,5477982.72872885,4440114.95256461,5478678.34845644,4439277.45331143,5478678.34845644) )

The strange thing is that this problem doesn’t occure on point geometries. Only when I try to configure polygonal or linear geodata in geoserver the above metioned error-message appears. Perhaps geoserver reads the SDO_POINT in the SDO_GEOMETRY object where all the values are set to “NULL” and doesn’t realize that in the SDO_ORDINATES obeject the relevant pairs of coordinates can be found? Might that be the problem? Or what else did I do wrong?

I already searched the mailinglist-archives and found out that more people haveing had the same problem. But I could not find any working solution to that problem. But perhaps somebody has a helpful hint and could help me on solveing this problem. Would be very nice. Thank you for your help.

Best regards

Daniel

Echte DSL-Flatrate dauerhaft für 0,- Euro*. Nur noch kurze Zeit!
“Feel free” mit GMX DSL: http://www.gmx.net/de/go/dsl


Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642


Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users