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

Reply via email to