Hi,
can anyone help me? I can't create new SLD for featuretype (there is no menu
with colours, ect..) because my geom type is null.
I'm using oracle 10g, and I tried few versions of geoserver including latest
one. My connection is ok, I suppose, because I can view featuretype and it's
ok, but I want to do some decorations using SLD... (SRS is ok, bounding box
too). My table have a primary key, (also have some foreing keys, I hope it's
not problem?)
--
View this message in context: http://www.nabble.com/Geometry-type%3A-NULL%2C-oracle-10g-used!-tp15177224p15177224.html
Sent from the GeoServer - Dev mailing list archive at Nabble.com.
pedja_pg ha scritto:
Hi,
can anyone help me? I can't create new SLD for featuretype (there is no menu
with colours, ect..) because my geom type is null (when I open featuretype,
on the bottom there is list of attributes from my table, every attribute is
ok, just geom is null). ? ? ?
I'm using oracle 10g, and I tried few versions of geoserver including latest
one. My connection is ok, I suppose, because I can view featuretype and it's
ok, but I want to do some decorations using SLD... (SRS is ok, bounding box
too). My table have a primary key, (also have some foreing keys, I hope it's
not problem?)
I already mentioned that I can see the data from the table using geoserver,
and I can see them using oracle MapBuilder...
If you create your style by hand you'll be able to use your table as
is (have you tried using the generic line/point/polygon styles?).
Anyways, to have GeoServer recognize the geometry type in your column,
as far as I know, you'll have to declare it as metadata in your
index creation statement (given that oracle has no other means of
stating what kind of geometry is in a column). For example, when
creating an index on a point column use:
CREATE INDEX ORA_TEST_POINTS_SHAPE_IDX
ON ORA_TEST_POINTS (SHAPE) INDEXTYPE IS
MDSYS.SPATIAL_INDEX PARAMETERS ('SDO_INDX_DIMS=2 LAYER_GTYPE="POINT"')
Then force GeoServer to load its feature type information by either
restarting it or by pressing the "apply" button.
Hope this helps
Cheers
Andrea
Public SORRY to ANDREA for sending two private mails, first was 'cause I'm
new here, and second was because I didn't read her response before
sending...
adding "('SDO_INDX_DIMS=2 LAYER_GTYPE="POLYGON"')" when creating index
helped me, geoserver now recognizes geometry type (polygonProperty, is that
ok?), but I still can't create new SLD.
P.S. I need SLD just to show one atribute from the table in polygon. (Like a
state name inside her boundaries). Any help ?
Andrea, sorry one more time..
Thank you..
--
View this message in context: http://www.nabble.com/Geometry-type%3A-NULL%2C-oracle-10g-used!-tp15177224p15201147.html
Sent from the GeoServer - Dev mailing list archive at Nabble.com.