We are using the Oracle Native SRID.
I actually set the geometry to 26910 first before inserting the metadata and
creating the index.
I drop the entire database and reloaded it again and this time it worked
without a hitch using the same exact scripts I had before.
Sure is odd but thank you for
Hi,
Is your projection this one
http://epsg-registry.org/report.htm?type=selection&entity=urn:ogc:def:crs:EPSG::26910&reportDetail=short&style=urn:uuid:report-style:default-with-code&style_name=OGP%20Default%20With%20Code&title=26910
If it is, your bounds cover only 360 by 180 meters. Or do you u
I had to do this again with another set of shapes and is ending up with
Geoserver timing out even if I had created the indexes. Is there something
else I might be missing?
I create the metadata and indexes as follows:
INSERT INTO USER_SDO_GEOM_METADATA
VALUES (
'GEOSERVER_CEMDATA',
'THE_G
Unquoted Oracle identifiers are converted to uppercase; this may be
significant in USER_SDO_GEOM_METADATA values, as lowercase string values
(table and column names) will not match.
Kind regards,
Ben.
On 19/11/13 21:09, rkliao wrote:
> Thanks for the reply.
>
> I have figured out the problem.
On Tue, Nov 19, 2013 at 2:09 PM, rkliao wrote:
> Thanks for the reply.
>
> I have figured out the problem. It had to do with the creation of an entry
> in the ORACLE USER_SDO_GEOM_METADATA table in order to create the Spatial
> index.
>
> I originally set it to the ff (copied this off the web as
Thanks for the reply.
I have figured out the problem. It had to do with the creation of an entry
in the ORACLE USER_SDO_GEOM_METADATA table in order to create the Spatial
index.
I originally set it to the ff (copied this off the web as I was not able to
create spatial indexes without it):
INS
Hi,
sounds odd, very odd. I guess you have the gt-jdbc-oraclexxx.jar and the
ojdbc14.jar in the lib directories. I further assume the tables are
indexed, including a spatial index and analysed.
I would do two things first before doing anything with Geoserver. Download
QGis and try to display it
Am a little bit in a bind. I have loaded the shape files in an SQL database
and am able to make in work with Geoserver with no issues under Layer
Preview. The problem arises when I have loaded the exact same shape files
into an Oracle database. Nothing seems to load and it comes up with a
renderi