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:
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
i had the same problem and i fixed it. i created a primary index for my
table. you should try creating primary index for RWG_TBS.
Daniel Goetz wrote:
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:
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
thank you for your quick answer. But I don't know what a "primary index" is and more than ever I don't know how to create such a "primary index". But if this is the solution I am glad to learn about it.
I have a "primary key" defined for the table (RWG_TBS). It's a numeric one. And I have a spatial index for the GEOM column. And of course I have tested whether the table has an entry in the "users_sdo_geom_metadata". Everything seems to be all right. I even did a validate procedure on the GEOM column of the table and the result was O.K.
But as I mentioned I don' t know how to create a "primary index". Would you please be so kind and give me a short description on how to create a "primary index" and on what (the whole table or a single column?).
Thank you so much for your time and your help. That's really nice. Thank you.
i had the same problem and i fixed it. i created a primary index for my
table. you should try creating primary index for RWG_TBS.
Daniel Goetz wrote:
>
> 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
>
>
-------------------------------------------------------------------------
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
Instead of primary KEY i wrote primary INDEX.
Try setting geoserver logging level to fine and check what sql statement
geoserver sends to database.
And then try executing this sql on this table (in sqlDeveloper or something
similar).
Daniel Goetz wrote:
Hi community, hi GeoUser,d I have a spat
thank you for your quick answer. But I don't know what a "primary index"
is and more than ever I don't know how to create such a "primary index".
But if this is the solution I am glad to learn about it.
I have a "primary key" defined for the table (RWG_TBS). It's a numeric
one. Anial index for the GEOM column. And of course I have tested whether
the table has an entry in the "users_sdo_geom_metadata". Everything seems
to be all right. I even did a validate procedure on the GEOM column of the
table and the result was O.K.
But as I mentioned I don' t know how to create a "primary index". Would
you please be so kind and give me a short description on how to create a
"primary index" and on what (the whole table or a single column?).
Thank you so much for your time and your help. That's really nice. Thank
you.
i had the same problem and i fixed it. i created a primary index for my
table. you should try creating primary index for RWG_TBS.
Daniel Goetz wrote:
>
> 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
>
>
-------------------------------------------------------------------------
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
-------------------------------------------------------------------------
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
thank you for your tip with the logfile. But unfortunately I don't know how to analyse that logfile. I noticed a WARNING, but this WARNING also appears when I set up a point featuretype form an oracle spatial database (oddly setting up point featuretypes does not cause any error, only line and polygon geodata). It says:
WARNUNG: Could not map SRID 82032 to CRS:java.io.IOException: No CRS for srid 82032
But perhaps someone (perhaps you GeoUser?) could check my logfile for any exceptional entries that give a sign why geoserver complains:
The FeatureType 'RWG_TBS' has a NULL extent.
HINT: the dataset is empty or has no default geometry attribute.
Thank you all for your help and ideas. Many thanks.
best regards
Daniel
P.S. I have added the whole logfile as an attechment to this mail.
Instead of primary KEY i wrote primary INDEX.
Try setting geoserver logging level to fine and check what sql statement
geoserver sends to database.
And then try executing this sql on this table (in sqlDeveloper or
something
similar).
