Re: [Geoserver-users] Problem with Oracle data store on session startup sql script
Hi,
please share the full stack trace, to be found in the logs
Cheers
Andrea
On Wed, Dec 31, 2014 at 9:41 AM, Kamardine YOUSSOUFA
kamardine.yousso...@somei.fr wrote:
Hi everyone,
I want to create an Oracle data store with defining Session startup SQL
parameter.
For example, when I set this parameter with the following PL/SQL bloc :
begin
fdp.trace_geoserver('Session startup');
end;
I have this message : Error creating data store, check the parameters.
Error message: Unable to obtain Oracle Connection require for SDO Geometry
access).Check connection pool implementation to unsure unwrap is available
My environment is :
- Windows 2008 R2 x64
- Oracle 11g R2 x64
- Geoserver 2.61
- Apache 7.0.47 x64
- Java 1.7
Thanks for your help.
Best regards,
Kamardine
--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is
your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.
Please, notice that GeoSolutions will be closed for seasonal holidays
from December the 24th to January the 6th
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*
Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.
---
--
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Geoserver with very poor performance
Hello everybody, I am trying the Geoserver the first time and just wondering regarding a very poor general performance. After my installation of the current stabele release (2.6.1) on a tomcat 7.0.52 with Oracle Java 8. For my server I use an Ubunutu 14.04 LTS. So far I did not configured any layer or database. Nevertheless when I try to load any side, e.g. settings, it takes very long to load the page, approx. 30s!!! I guess there is any issue but I could not found any hint. I already increased the the memory for my tomcat installation (Free memory: 862.67 MB Total memory: 1007.37 MB Max memory: 3035.37 MB). Is the current behaviour correct? If not what can I check? For me, the log files does show any issues. Thanks, Markus == tomcat log == Dec 31, 2014 10:23:39 AM org.apache.catalina.startup.ClassLoaderFactory validateFile WARNING: Problem with directory [/usr/share/tomcat7/common/classes], exists: [false], isDirectory: [false], canRead: [false] Dec 31, 2014 10:23:39 AM org.apache.catalina.startup.ClassLoaderFactory validateFile WARNING: Problem with directory [/usr/share/tomcat7/common], exists: [false], isDirectory: [false], canRead: [false] Dec 31, 2014 10:23:39 AM org.apache.catalina.startup.ClassLoaderFactory validateFile WARNING: Problem with directory [/usr/share/tomcat7/server/classes], exists: [false], isDirectory: [false], canRead: [false] Dec 31, 2014 10:23:39 AM org.apache.catalina.startup.ClassLoaderFactory validateFile WARNING: Problem with directory [/usr/share/tomcat7/server], exists: [false], isDirectory: [false], canRead: [false] Dec 31, 2014 10:23:39 AM org.apache.catalina.startup.ClassLoaderFactory validateFile WARNING: Problem with directory [/usr/share/tomcat7/shared/classes], exists: [false], isDirectory: [false], canRead: [false] Dec 31, 2014 10:23:39 AM org.apache.catalina.startup.ClassLoaderFactory validateFile WARNING: Problem with directory [/usr/share/tomcat7/shared], exists: [false], isDirectory: [false], canRead: [false] Dec 31, 2014 10:23:40 AM org.apache.coyote.AbstractProtocol init INFO: Initializing ProtocolHandler [http-bio-8080] Dec 31, 2014 10:23:40 AM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 733 ms Dec 31, 2014 10:23:40 AM org.apache.catalina.core.StandardService startInternal INFO: Starting service Catalina Dec 31, 2014 10:23:40 AM org.apache.catalina.core.StandardEngine startInternal INFO: Starting Servlet Engine: Apache Tomcat/7.0.52 (Ubuntu) Dec 31, 2014 10:23:40 AM org.apache.catalina.startup.HostConfig deployDescriptor INFO: Deploying configuration descriptor /etc/tomcat7/Catalina/localhost/host-manager.xml Dec 31, 2014 10:23:40 AM org.apache.catalina.startup.HostConfig deployDescriptor INFO: Deploying configuration descriptor /etc/tomcat7/Catalina/localhost/manager.xml Dec 31, 2014 10:23:40 AM org.apache.catalina.startup.HostConfig deployWAR INFO: Deploying web application archive /var/lib/tomcat7/webapps/geoserver.war 31 Dec 10:23:49 DEBUG [geoserver.global] - Found Java environment variable GEOSERVER_DATA_DIR to be unset 31 Dec 10:23:49 DEBUG [geoserver.global] - Found Servlet context parameter GEOSERVER_DATA_DIR to be unset 31 Dec 10:23:49 DEBUG [geoserver.global] - Found System environment variable GEOSERVER_DATA_DIR to be unset 31 Dec 10:23:49 DEBUG [geoserver.global] - Found Java environment variable GEOSERVER_DATA_ROOT to be unset 31 Dec 10:23:49 DEBUG [geoserver.global] - Found Servlet context parameter GEOSERVER_DATA_ROOT to be unset 31 Dec 10:23:49 DEBUG [geoserver.global] - Found System environment variable GEOSERVER_DATA_ROOT to be unset 31 Dec 10:23:49 INFO [geoserver.global] - Falling back to embedded data directory: /var/lib/tomcat7/webapps/geoserver/data Dec 31, 2014 10:23:49 AM org.geoserver.platform.GeoServerExtensions checkContext WARNING: Extension lookup XStreamPersisterInitializer, but ApplicationContext is unset. log4j:WARN File option not set for appender [geoserverlogfile]. log4j:WARN Are you using FileAppender instead of ConsoleAppender? 31 Dec 10:23:51 INFO [geoserver.global] - Falling back to embedded data directory: /var/lib/tomcat7/webapps/geoserver/data Dec 31, 2014 10:23:51 AM org.geoserver.platform.GeoServerExtensions checkContext WARNING: Extension lookup GeoServerSecurityProvider, but ApplicationContext is unset. 31 Dec 10:23:52 INFO [org.geoserver] - Loaded style restricted 31 Dec 10:23:52 INFO [org.geoserver] - Loaded style polygon 31 Dec 10:23:52 INFO [org.geoserver] - Loaded style point 31 Dec 10:23:52 INFO [org.geoserver] - Loaded style green 31 Dec 10:23:52 INFO [org.geoserver] - Loaded style raster 31 Dec 10:23:52 INFO [org.geoserver] - Loaded style burg 31 Dec 10:23:52 INFO [org.geoserver] - Loaded style giant_polygon 31 Dec 10:23:52 INFO [org.geoserver] - Loaded style dem 31 Dec 10:23:52 INFO [org.geoserver] - Loaded style poly_landmarks 31 Dec 10:23:52 INFO [org.geoserver] - Loaded style tiger_roads 31 Dec 10:23:52 INFO [org.geoserver] - Loaded
Re: [Geoserver-users] How to create orthoimagery service?
On Tue, Dec 30, 2014 at 8:43 PM, Bistrais, Bob bob.bistr...@maine.gov wrote: Hello again Andrea, I have upgraded so I now have a GeoServer 2.6x release. I created a simple ImageMosaic and this seems to work now. I probably created the original problem- some of my imagery is in jpeg2000 format as well as Geotif. I was confused on the instructions to add the jpeg2000 support, and I think I may have copied files to the wrong location. (I am still trying to resolve the jpeg2000 support, but that is another topic) Maybe that broke the ImageMosaic? It could be, hard to tell without examining the actual installation, logs, and data Cheers Andrea -- == GeoServer Professional Services from the experts! Visit http://goo.gl/NWWaa2 for more information. Please, notice that GeoSolutions will be closed for seasonal holidays from December the 24th to January the 6th == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003* Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003. The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc. --- -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Geoserver with very poor performance
I have the same issue. Java 7. But the performance of serving up layers seems much like 2.5.2 so not a big problem for me. Would be interesting to see if I need to do something to fix it all the same Russ --- On 31 Dec 2014, at 09:29, markus.sigg...@web.de wrote: Hello everybody, I am trying the Geoserver the first time and just wondering regarding a very poor general performance. After my installation of the current stabele release (2.6.1) on a tomcat 7.0.52 with Oracle Java 8. For my server I use an Ubunutu 14.04 LTS. So far I did not configured any layer or database. Nevertheless when I try to load any side, e.g. settings, it takes very long to load the page, approx. 30s!!! I guess there is any issue but I could not found any hint. I already increased the the memory for my tomcat installation (Free memory: 862.67 MB Total memory: 1007.37 MB Max memory: 3035.37 MB). Is the current behaviour correct? If not what can I check? For me, the log files does show any issues. Thanks, Markus == tomcat log == Dec 31, 2014 10:23:39 AM org.apache.catalina.startup.ClassLoaderFactory validateFile WARNING: Problem with directory [/usr/share/tomcat7/common/classes], exists: [false], isDirectory: [false], canRead: [false] Dec 31, 2014 10:23:39 AM org.apache.catalina.startup.ClassLoaderFactory validateFile WARNING: Problem with directory [/usr/share/tomcat7/common], exists: [false], isDirectory: [false], canRead: [false] Dec 31, 2014 10:23:39 AM org.apache.catalina.startup.ClassLoaderFactory validateFile WARNING: Problem with directory [/usr/share/tomcat7/server/classes], exists: [false], isDirectory: [false], canRead: [false] Dec 31, 2014 10:23:39 AM org.apache.catalina.startup.ClassLoaderFactory validateFile WARNING: Problem with directory [/usr/share/tomcat7/server], exists: [false], isDirectory: [false], canRead: [false] Dec 31, 2014 10:23:39 AM org.apache.catalina.startup.ClassLoaderFactory validateFile WARNING: Problem with directory [/usr/share/tomcat7/shared/classes], exists: [false], isDirectory: [false], canRead: [false] Dec 31, 2014 10:23:39 AM org.apache.catalina.startup.ClassLoaderFactory validateFile WARNING: Problem with directory [/usr/share/tomcat7/shared], exists: [false], isDirectory: [false], canRead: [false] Dec 31, 2014 10:23:40 AM org.apache.coyote.AbstractProtocol init INFO: Initializing ProtocolHandler [http-bio-8080] Dec 31, 2014 10:23:40 AM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 733 ms Dec 31, 2014 10:23:40 AM org.apache.catalina.core.StandardService startInternal INFO: Starting service Catalina Dec 31, 2014 10:23:40 AM org.apache.catalina.core.StandardEngine startInternal INFO: Starting Servlet Engine: Apache Tomcat/7.0.52 (Ubuntu) Dec 31, 2014 10:23:40 AM org.apache.catalina.startup.HostConfig deployDescriptor INFO: Deploying configuration descriptor /etc/tomcat7/Catalina/localhost/host-manager.xml Dec 31, 2014 10:23:40 AM org.apache.catalina.startup.HostConfig deployDescriptor INFO: Deploying configuration descriptor /etc/tomcat7/Catalina/localhost/manager.xml Dec 31, 2014 10:23:40 AM org.apache.catalina.startup.HostConfig deployWAR INFO: Deploying web application archive /var/lib/tomcat7/webapps/geoserver.war 31 Dec 10:23:49 DEBUG [geoserver.global] - Found Java environment variable GEOSERVER_DATA_DIR to be unset 31 Dec 10:23:49 DEBUG [geoserver.global] - Found Servlet context parameter GEOSERVER_DATA_DIR to be unset 31 Dec 10:23:49 DEBUG [geoserver.global] - Found System environment variable GEOSERVER_DATA_DIR to be unset 31 Dec 10:23:49 DEBUG [geoserver.global] - Found Java environment variable GEOSERVER_DATA_ROOT to be unset 31 Dec 10:23:49 DEBUG [geoserver.global] - Found Servlet context parameter GEOSERVER_DATA_ROOT to be unset 31 Dec 10:23:49 DEBUG [geoserver.global] - Found System environment variable GEOSERVER_DATA_ROOT to be unset 31 Dec 10:23:49 INFO [geoserver.global] - Falling back to embedded data directory: /var/lib/tomcat7/webapps/geoserver/data Dec 31, 2014 10:23:49 AM org.geoserver.platform.GeoServerExtensions checkContext WARNING: Extension lookup 'XStreamPersisterInitializer', but ApplicationContext is unset. log4j:WARN File option not set for appender [geoserverlogfile]. log4j:WARN Are you using FileAppender instead of ConsoleAppender? 31 Dec 10:23:51 INFO [geoserver.global] - Falling back to embedded data directory: /var/lib/tomcat7/webapps/geoserver/data Dec 31, 2014 10:23:51 AM org.geoserver.platform.GeoServerExtensions checkContext WARNING: Extension lookup 'GeoServerSecurityProvider', but ApplicationContext is unset. 31 Dec 10:23:52 INFO [org.geoserver] - Loaded style 'restricted' 31 Dec 10:23:52 INFO [org.geoserver] - Loaded style 'polygon' 31 Dec 10:23:52 INFO [org.geoserver] - Loaded style 'point' 31 Dec 10:23:52 INFO [org.geoserver] - Loaded
Re: [Geoserver-users] Geoserver with very poor performance
On Wed, Dec 31, 2014 at 10:29 AM, markus.sigg...@web.de wrote: Hello everybody, I am trying the Geoserver the first time and just wondering regarding a very poor general performance. After my installation of the current stabele release (2.6.1) on a tomcat 7.0.52 with Oracle Java 8. For my server I use an Ubunutu 14.04 LTS. So far I did not configured any layer or database. Nevertheless when I try to load any side, e.g. settings, it takes very long to load the page, approx. 30s!!! To load the page is too generic of a statement. I can see from the logs GeoServer starts up in 25s, which is a normal time, from there it should be fast though. Are you using Firefox as the browser? Try changing it with something else, you might be affected by an issue with css gzip compression that makes Firefox believe the CSS file is actually longer than it is, search the archives of this mailing list for details Cheers Andrea -- == GeoServer Professional Services from the experts! Visit http://goo.gl/NWWaa2 for more information. Please, notice that GeoSolutions will be closed for seasonal holidays from December the 24th to January the 6th == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003* Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003. The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc. --- -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Geoserver with very poor performance
On Wed, Dec 31, 2014 at 10:39 AM, Russ Hore r...@russ-hore.co.uk wrote: I have the same issue. Java 7. But the performance of serving up layers seems much like 2.5.2 so not a big problem for me. Would be interesting to see if I need to do something to fix it all the same See the archives, they describe a change to be made to the gzip filter settings in web.xml to restore good page serving performance Or, you can upgrade Firefox or use a different browser Cheers Andrea -- == GeoServer Professional Services from the experts! Visit http://goo.gl/NWWaa2 for more information. Please, notice that GeoSolutions will be closed for seasonal holidays from December the 24th to January the 6th == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003* Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003. The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc. --- -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Possible getFeatureInfo bug in 2.6.1
I think I've discovered a bug in 2.6.1 but I need a second opinion. I upgraded to 2.6.1 from 2.2.5 so as far as I know the issue could have been introduced anywhere in between. I have a line layer in Oracle Locator 11gR2 with around 100,000 features (all 2-vertex lines, no line strings). Rendering a map showing an area within the layer, containing perhaps 500 features, is nice and fast - maybe two seconds. However, a getFeatureInfo operation with the same parameters (bbox, style, cql_filter etc.) is extremely slow - over two minutes. The issue was originally observed in a custom application but I /can/ replicate it in the OpenLayers layer preview. I enabled verbose logging and did some digging. The issue appears to come from the SQL query that GeoServer sends to Oracle. In 2.2.5 getMap and getFeatureInfo, and 2.6.1 getMap, the spatial part of the query looks like this: SELECT ... FROM ... WHERE (SDO_FILTER(LINE, MDSYS.SDO_GEOMETRY(2003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(minx,miny,maxx,maxy)), 'mask=anyinteract querytype=WINDOW') = 'TRUE' However, in 2.6.1 getFeatureInfo the spatial part looks like this: SELECT ... FROM ... WHERE (SDO_FILTER(LINE, MDSYS.SDO_GEOMETRY(2003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(minx,miny,maxx,maxy)), 'mask=anyinteract querytype=WINDOW') = 'TRUE' *OR* (SDO_FILTER(LINE, MDSYS.SDO_GEOMETRY(2003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(minx,miny,maxx,maxy)), 'mask=anyinteract querytype=WINDOW') = 'TRUE' Presumably the severe slowdown comes from both clauses trying to do the same thing simultaneously. Perhaps if my line layer had fewer features I wouldn't even notice that this was an issue. Does this look like something that warrants a new bug report? -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Possible-getFeatureInfo-bug-in-2-6-1-tp5179690.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] jp2 images will not load
-I have also found these messages in the GeoServer log file: 2014-12-31 13:44:37,704 WARN [coverageio.jp2k] - Unavailable envelope for this coverage org.geotools.data.DataSourceException: Unavailable envelope for this coverage at org.geotools.coverageio.jp2k.JP2KReader.setCoverageProperties(JP2KReader.java:161) at org.geotools.coverageio.jp2k.JP2KReader.init(JP2KReader.java:504) at org.geotools.coverageio.jp2k.JP2KFormat.getReader(JP2KFormat.java:123) at org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1418) at org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1346) at ... 2014-12-31 14:00:46,322 INFO [geoserver.web] - Getting list of coverages for saved store file:C:\mapserver_data\wms_raster_data\augusta_man_08\tiles\19TDJ290855.jp2 java.lang.RuntimeException: Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:C:\mapserver_data\wms_raster_data\augusta_man_08\tiles\19TDJ290855.jp2 and hints null ... at org.geoserver.web.data.layer.NewLayerPageProvider.getItemsInternal(NewLayerPageProvider.java:151) Caused by: java.io.IOException: Failed to create reader from file:C:\mapserver_data\wms_raster_data\augusta_man_08\tiles\19TDJ290855.jp2 and hints null at org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1420) at org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1346) at org.geoserver.catalog.impl.CoverageStoreInfoImpl.getGridCoverageReader(CoverageStoreInfoImpl.java:59) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.geoserver.catalog.impl.ModificationProxy.invoke(ModificationProxy.java:146) at com.sun.proxy.$Proxy20.getGridCoverageReader(Unknown Source) at org.geoserver.web.data.layer.NewLayerPageProvider.getItemsInternal(NewLayerPageProvider.java:90) ... 120 more From: Bistrais, Bob [mailto:bob.bistr...@maine.gov] Sent: Tuesday, December 30, 2014 4:28 PM To: geoserver-users@lists.sourceforge.net Subject: [Geoserver-users] jp2 images will not load I am having problems with jpeg2000 support (GeoServer 2.6x on Windows 7). I have tried to follow the instructions on: http://docs.geoserver.org/latest/en/user/data/raster/gdal.html I installed the GDAL extension, placed the files in WEB-INF/lib directory of GeoServer I downloaded the gdal-data.zip from http://demo.geo-solutions.it/share/github/imageio-ext/releases/1.1.X/1.1.10/native/gdal/, -The instruction said to place these in a proper directory, I'm not sure what is proper. I created a C:\gdal-data folder for it. -I then added this to the GDAL_DATA environment variable Then I downloaded the native libraries: http://demo.geo-solutions.it/share/github/imageio-ext/releases/1.1.X/1.1.10/native/gdal/windows/ -I used the MSVC2010, but to be honest I am not sure that is the right one. But, again I extracted this to C:\msvc2010, then I put that folder in my PATH. I rebooted the machine. When I try to add a raster store, I see an option for JP2k (Direct). So when I try to create a new store with that, the following error message appears: Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:C:\mapserver_data\wms_raster_data\augusta_man_08\tiles\19TDJ290855.jp2 and hints null Can anyone advise me on this? -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
