Re: [Geoserver-users] Oracle Data in Geoserver

2014-04-10 Thread rkliao
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

Re: [Geoserver-users] Oracle Data in Geoserver

2014-04-03 Thread Rahkonen Jukka (Tike)
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

Re: [Geoserver-users] Oracle Data in Geoserver

2014-04-03 Thread rkliao
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

Re: [Geoserver-users] Oracle Data in Geoserver

2013-11-19 Thread Ben Caradoc-Davies
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.

Re: [Geoserver-users] Oracle Data in Geoserver

2013-11-19 Thread Andrea Aime
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

Re: [Geoserver-users] Oracle Data in Geoserver

2013-11-19 Thread rkliao
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

Re: [Geoserver-users] Oracle Data in Geoserver

2013-11-18 Thread cmaul
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

[Geoserver-users] Oracle Data in Geoserver

2013-11-18 Thread rkliao
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