Difference between revisions of "Working with Databases"
Jump to navigation
Jump to search
| Line 13: | Line 13: | ||
[[File:SelectConnection.png]] | [[File:SelectConnection.png]] | ||
| − | + | The right icon representing a DataBase open the Connection Manager | |
| + | [[File:ConnectionManager.png]] | ||
| + | |||
| + | Creating a new connection open the following dialog box to configure the connection<br> | ||
[[File:ConfigureConnection.png]] | [[File:ConfigureConnection.png]] | ||
| + | |||
| + | To get more details about connection configuration, go to [[Configure a DataBase Connection]] | ||
=== '''Connecting a layer to a table''' === | === '''Connecting a layer to a table''' === | ||
Revision as of 01:45, 1 December 2012
back to New User Guide Index page
References
Database connection
There are several plugins in OpenJUMP, making use of DataBase connections
- DataStore Layer available in Files > Open...
- Run DataStore Query available in Files
- Save As PostGIS available in the layer contextuel menu : write click on the layer, then choose Save Dataset As... and select the PostGIS table format
All these plugins use the same Connection selector
The right icon representing a DataBase open the Connection Manager
Creating a new connection open the following dialog box to configure the connection
To get more details about connection configuration, go to Configure a DataBase Connection
Connecting a layer to a table
Creating a layer from a query
Other resources
See also Plugins for OpenJUMP
PostgreSQL/PostGIS
- PostGIS Tutorial (for OpenJUMP + postgis plugin) (german) by Uwe Dalluege
- PostGIS Manual by Paul Ramsey in English
- Manual PostGIS - Spanish version by Manuel Martìn Martìn
- Introduction to PostGIS (English) from Postgres online Journal
- OpenJUMP for PostGIS Spatial Ad-Hoc Queries (English) by Regina Obe from Postgres online Journal
- OpenJUMP 1.3 Tutorial (English) by S. Steiniger, M. Michaud and Erwan Brocher for OGRS 2009.
- Mineral Targeting Exercise by Ravi Kumar
Oracle
- jumpdbplugin by Larry Reeder
MySQL
- jumpdbplugin by Larry Reeder
back to New User Guide Index page