Caroline, Although we are losing a little in your translation from Portuguese to English, I think I understand what you are trying to do. Let's see if I do...
1. You have GIS data in a database that OpenJump can access (for example: PostGIS). You will perform a "Run Datastore Query" to load this data into OpenJump. 2. You have related data in another database that has a common key, and you would lilke to join some of this data to the GIS features so that it can be accessed normally within OpenJump as attributes. If 1 and 2 are true, here are the steps: You should create a plugin option on the Layer menu that invokes your class called something like JoinExternalDB. It should either get the selected layer, or present layer names in a drop down list or both. It should have a method of specifying the external database and table to join, the field to join from and to, and the subset of fields to add. Perhaps this is just SQL. If the initial database connection succeeds, the new fields should be added to the specified layer's schema. See the View/Edit Schema tool for an example of how to do this. It would then iterate though the specified layers features performing database queries on the non-GIS database table and populating the new fields. See the Tools->Edit Attributes sub-menu for examples of how to do this. regards, Larry 2010/5/17 Caroline Julliê Freitas Ribeiro <[email protected]> > Hi, I'm in need of help here ... > > In my project I'll create my own template to access distinct databases (a > framework) and set up a query 'association' that resulting in populate data > from my GIS(the OpenJump) > > On this part of the project I'll have to worry me on the way as GIS and her > respective database will store the results of my queries, using > ViewAttributesPlugIn and the ViewSchemaPlugIn classes .. The problem's that > I don't know how can I call the method of these classes and pass the result > of my query to the openJump. > My project is more or less similar to the jumpdbplugin-0.7.1 plugin.. > > The aim is obviously to use OpenJUMP for making a kind of database link > between two databases.Example: I want to make queries between two distinct > databases . > I would import the data into one database first with create a view or > whatever with the link. To populate it, I want to use the openjump storing > the different of queries in database ... > To save data from my query (where I use my own framework) thought of usingthe > openJump structure ready. > > Thanks. > > -- > Caroline Julliê de Freitas Ribeiro > Graduando em Análise e Desenvolvimento de Sistemas > > Instituto Federal Minas Gerais - IFMG > Campus Bambuí > > > ------------------------------------------------------------------------------ > > > _______________________________________________ > Jump-pilot-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > >
------------------------------------------------------------------------------
_______________________________________________ Jump-pilot-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
