You'll have to write your own plug-in to do this. It''ll have the
following steps
1. Create a FeatureSchema definition for all the columns
2. Create a java.util.Map with the key being the ID column and the
value being a Feature instance
3. Open your three data sources in turn and loop through the features
from each source. Look up a feature instance in the map from #2 if
one doesn't exists create it and add it to the map. Set the
attributes from the feature from the data source on the merged
feature in the map
4. When all features are loaded you should have all the data merged.
Now create a feature collection for all the values in the map and
add a layer for it.
Paul
Eric Lemesre wrote:
I can create a view only if i have some right in the database.
And it is not necessary the case.
It is dangerous in verry big compagny.
At this time i have only read rigth in some Database.
Eric
2007/11/4, Paul Austin <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>:
Layers are tied to a feature collection and all features must
share the same schema.
If you create custom Java code to load the date from each of those
sources and populate the feature collection with that data then
there is no reason why you couldn't do what you want. But there is
nothing out of the box to do this.
What is the use case behind getting the attributes from many
places? If the geometry and attributes are in a shape file why not
load these into one of the databases then you can create a view of
the tables and load that into JUMP?
Paul
Eric Lemesre wrote:
Hi,
It possible to have more than one datasource by layer?
1 for Geo datasource (a data source for the géometry)
1..n data source for attributes
Exemple :
* shapeFile for the geometry
* a flat CSV file for some attribute
* MysQL database for some other
* PostgreSQL database for some others.
Eric
------------------------------------------------------------------------
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
------------------------------------------------------------------------
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
<mailto:Jump-pilot-devel@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a
browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
<mailto:Jump-pilot-devel@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
------------------------------------------------------------------------
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
------------------------------------------------------------------------
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel