Hi all,
It is advised to cache the (Oracle) JDBCDatastore because it is a heavy object.
I experienced this as well because it searches for a lot of metadata during
feature layer queries that are executed during StreamingRenderer.paint()
So now I am trying to cache it in a servlet and reuse it for all sessions.
As far as I know it is thread-safe to use in this way.
The questions that I have:
- I use data from multiple database schema's. So I have to use
setDatabaseSchema() for the datastore. But if I do that for one session, other
sessions may have problems with that if they have to query data from other
database schema's. So this is probably not thread-safe. I probably need to
cache datastores for each database schema, correct?
I nicer way would be that database schema is not part of a datastore but part
of the feature layer query.
- If i set "min connections" of the datastore properties to a value larger than
1 there is still only one real Oracle database session active.
What is the use of " min connections"?
Thanks for any answers.
Ron
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
