[Geoserver-users] Oracle connection

GeoServer GeoServer User
1

Hi folks,

I am setting up a WFS-server using Geoserver 1.5.0. I added a new datastore
(an oracle spatial database) and everything went fine, but now when setting
the featuretype section when I pressed the "generate" button to
automatically fill in the lat/lon, I got the following error: "The
FeatureType 'Name of the table' has a NULL extent. HINT: the dataset is
empty or has no default geometry attribute." However my Featuretype has not
a NULL-extent.

I read on the forum that someone solved this problem creating a primary key
for the table, Does anyone know any other way to solve it??

Thanks for your help, much appreciated,

Best regards,

Juan Arévalo.

--
View this message in context: http://www.nabble.com/Oracle-connection-tf3865826.html#a10951648
Sent from the GeoServer - User mailing list archive at Nabble.com.

2

Juan Arévalo ha scritto:

Hi folks,

I am setting up a WFS-server using Geoserver 1.5.0. I added a new datastore
(an oracle spatial database) and everything went fine, but now when setting
the featuretype section when I pressed the "generate" button to
automatically fill in the lat/lon, I got the following error: "The
FeatureType 'Name of the table' has a NULL extent. HINT: the dataset is
empty or has no default geometry attribute." However my Featuretype has not
a NULL-extent.

I read on the forum that someone solved this problem creating a primary key
for the table, Does anyone know any other way to solve it??

None. The oracle datastore won't function properly if you don't have a primary key in the tables.

Cheers
Andrea