On Wed, Oct 30, 2013 at 6:03 PM, Pieter Roggemans <
[email protected]> wrote:
> Hello,****
>
> Thanks for looking into this.****
>
> ** **
>
> When I did my tests last year “Oracle NG” and “Oracle JNDI” gave the same
> results… but when I retested now on our current environment (geoserver
> 2.2.0 instead of 2.1.4) there are indeed significant differences between
> the two:****
>
> ** **
>
> - Oracle JNDI (using an “SQL view” layer):****
>
> - 16 calls to the database per layer, and query “SELECT NULL AS
> table_cat…” takes 0.1 second per execution****
>
> - 8 out of the 16 calls it is the validation query or the JNDI
> connection pool****
>
> ** **
>
> - Oracle NG (using an “SQL view” layer):****
>
> - 2 calls to the database per layer: ****
>
> - the query getting the data****
>
> - +- the data query but with an extra “where 1=0” appended
> ****
>
> - NO validation query, even though the “validation query” checkbox
> is enabled in the data store definition. Or is the “where 1=0” query the
> validation query?
>
It is not. No idea why it's not happening, I have it in my logs (from
2.3.x).
What's weird is that the JNDI one just sets up the connection pool in a
different way... and also strange, its name should be "Oracle NG (JNDI)",
not "Oracle JNDI"
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
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
-------------------------------------------------------
------------------------------------------------------------------------------
Android is increasing in popularity, but the open development platform that
developers love is also attractive to malware creators. Download this white
paper to learn more about secure code signing practices that can help keep
Android apps secure.
http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
