[Geoserver-users] Oracle Data in Geoserver

GeoServer GeoServer User
1

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 use the native Oracle SRID code, not EPSG?

-Jukka Rahkonen-

rkliao wrote:

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_GEOM',
  MDSYS.SDO_DIM_ARRAY(
    MDSYS.SDO_DIM_ELEMENT('X', -180, 180, 0.005),
MDSYS.SDO_DIM_ELEMENT('Y', -90, 90, 0.005)
     ),
  26910 -- SRID
);

CREATE INDEX GEOSERVER_CEMDATA_idx ON GEOSERVER_CEMDATA
(the_geom) INDEXTYPE IS MDSYS.SPATIAL_INDEX;

The only different is the SRID is now 26910 instead of 4326.

Thanks.

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Oracle-
Data-in-Geoserver-tp5089732p5132967.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

2

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 your feedback.

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Oracle-Data-in-Geoserver-tp5089732p5134393.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

3

I applied an sld from OS in the uk to the mastermap topographicline layer

Anyone have a clue what the error message I got means ?

<ServiceException> java.lang.RuntimeException: org.xml.sax.SAXParseException; lineNumber: 711; columnNumber: 30; The processing instruction target matching "[xX][mM][lL]" is not allowed. org.xml.sax.SAXParseException; lineNumber: 711; columnNumber: 30; The processing instruction target matching "[xX][mM][lL]" is not allowed. The processing instruction target matching "[xX][mM][lL]" is not allowed. </ServiceException>

Mark Ismail
Principal IT Officer
Tel: 0151 443 3021
Knowsley Council K Westmorland Road Huyton L36 9GL

Save time - use the IT Service Desk Self Serve Application

-----Original Message-----
From: rkliao [mailto:rkliao@anonymised.com]
Sent: 10 April 2014 15:54
To: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Oracle Data in Geoserver

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 your feedback.

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Oracle-Data-in-Geoserver-tp5089732p5134393.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Put Bad Developers to Shame
Dominate Development with Jenkins Continuous Integration
Continuously Automate Build, Test & Deployment
Start a new project now. Try Jenkins in the cloud.
http://p.sf.net/sfu/13600_Cloudbees
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

4

Hi Mark,
it looks like your sld is malformed, please check that the xml
declaration is the very first line of your file.

Regards
Lorenzo Pini
Software Engineer

==
Meet us at GEO Business 2014! in London! Visit http://goo.gl/fES3aK
for more information.

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

On Thu, Apr 10, 2014 at 5:03 PM, Ismail, Mark
<mark.ismail@anonymised.com> wrote:

I applied an sld from OS in the uk to the mastermap topographicline layer

Anyone have a clue what the error message I got means ?

<ServiceException> java.lang.RuntimeException: org.xml.sax.SAXParseException; lineNumber: 711; columnNumber: 30; The processing instruction target matching "[xX][mM][lL]" is not allowed. org.xml.sax.SAXParseException; lineNumber: 711; columnNumber: 30; The processing instruction target matching "[xX][mM][lL]" is not allowed. The processing instruction target matching "[xX][mM][lL]" is not allowed. </ServiceException>

Mark Ismail
Principal IT Officer
Tel: 0151 443 3021
Knowsley Council K Westmorland Road Huyton L36 9GL

Save time - use the IT Service Desk Self Serve Application

-----Original Message-----
From: rkliao [mailto:rkliao@anonymised.com]
Sent: 10 April 2014 15:54
To: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Oracle Data in Geoserver

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 your feedback.

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Oracle-Data-in-Geoserver-tp5089732p5134393.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Put Bad Developers to Shame
Dominate Development with Jenkins Continuous Integration
Continuously Automate Build, Test & Deployment
Start a new project now. Try Jenkins in the cloud.
http://p.sf.net/sfu/13600_Cloudbees
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
This e-mail and any attachments are confidential. It may contain privileged information and is intended for the named recipient(s) only. It must not be distributed without consent. If you are not one of the intended recipients, please notify the sender immediately and do not disclose, distribute, or retain this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual sender, and not of Knowsley MBC. Legally binding obligations can only be created for, or be entered into on behalf of, Knowsley MBC by duly authorised officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any direct or consequential loss arising from the use, or reliance on, this e-mail or its contents. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking and no responsibility is accepted for loss or damage arising from viruses or changes made to this message after it was sent. Knowsley MBC reserves the right to monitor and/or record all e-mail communications through its network in accordance with relevant legislation.

------------------------------------------------------------------------------
Put Bad Developers to Shame
Dominate Development with Jenkins Continuous Integration
Continuously Automate Build, Test & Deployment
Start a new project now. Try Jenkins in the cloud.
http://p.sf.net/sfu/13600_Cloudbees
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users