Re: [JPP-Devel] Multiple Layers from the same database connection

2007-05-29 Thread Sunburned Surveyor
I may have a little something to add to this discussion, although I don't know how helpful it would be. :] A while back a company had hired me to do some work on one of the PostGIS Drivers. It sounds like they wanted something related to what Paul and Larry are discussing. They wanted to be able t

Re: [JPP-Devel] Multiple Layers from the same database connection

2007-05-29 Thread Larry Becker
Paul, The issue we are having with DataStore is that precisely what you are referring to. Each layer is trying to do its own connection in a separate thread to the server and Oracle is running out of connections. Some kind of connection pooling would probably solve this problem, but we haven'

Re: [JPP-Devel] Multiple Layers from the same database connection

2007-05-29 Thread Paul Austin
Hi Larry, I've just downloaded SkyJump and seen how the DataStores work and it looks as if it is roughly what I'm looking for. I notice that when you save the Project to a .jmp file that the connection information is duplicated for each layer. Does this mean that each layer will connect direc

Re: [JPP-Devel] Multiple Layers from the same database connection

2007-05-29 Thread Larry Becker
Hi Paul, As usual, you are interested in many of the same things that I am. The single DataSource multiple layer concept is currently only implemented in WMS and MrSID (which is based on WMSLayer) and you actually end up with only a single layer in JUMP, but you can manage it as multiples. Sk

Re: [JPP-Devel] Multiple Layers from the same database connection

2007-05-29 Thread Martin Davis
Paul, Look at the DataStore architecture in JUMP 1.2 - it does exactly what you're asking for, I think. Paul Austin wrote: > All, > > I've been looking at the existing database and file plugins and the > com.vividsolutions.jump.io.datasource.DataSource class and from what I > can tell there is a

[JPP-Devel] Multiple Layers from the same database connection

2007-05-29 Thread Paul Austin
All, I've been looking at the existing database and file plugins and the com.vividsolutions.jump.io.datasource.DataSource class and from what I can tell there is a one to one relationship between a layer and a data source. What I would like to do for some of the file and database based data sourc