Hi Everybody,
I am using geoserver 2.8.3 with Oracle NG (JNDI) datasource. i have an SQL View
based wms layer.
I noticed that at org.geoserver.catalog.ResourcePool.java (line 929 ) there is
an internal check witch queries tha database at every WMS request.
the select is the following :
SELECT NULL AS table_cat,
o.owner AS table_schem,
o.object_name AS table_name,
o.object_type AS table_type,
NULL AS remarks
FROM all_objects o
WHERE o.owner LIKE :1 ESCAPE '/'
AND o.object_name LIKE :2 ESCAPE '/'
AND o.object_type IN ('xxx', 'TABLE', 'VIEW', 'SYNONYM')
ORDER BY table_type, table_schem, table_name;
Can somebody tell me why this query is running at every WMS request. Is a name
collision detection with database objects needed at every WMS request ?
because i thing this is a performance issue and a bug.
Or maybe i missing something ...
Thanks for Help,
Kiss Attila
Ez a lev?l v?rus- ?s spammentes. | This e-mail is virus-free.
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
