Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "Connecting to PostgreSQL 8.x"
| (3 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
==PostgreSQL 8.x== | ==PostgreSQL 8.x== | ||
| − | + | ===DTP 1.0=== | |
| − | ''DTP 0.9 does not have a separate PostgreSQL driver template. You can, however, override the values in another driver template to get what is needed here.'' | + | DTP 1.0 has driver definitions and a sample connection profile for PostgreSQL. While the catalog loader is not complete, this should give enough content in the Data Source Explorer to be useful. |
| − | + | ===DTP 0.9.x=== | |
| − | + | ''DTP 0.9.x does not have a separate PostgreSQL driver template. You can, however, override the values in another driver template to get what is needed here.'' | |
| − | + | ||
| − | + | ||
| − | + | ||
* Choose any driver template from the list and override all values | * Choose any driver template from the list and override all values | ||
| Line 15: | Line 12: | ||
* Driver: org.postgresql.Driver | * Driver: org.postgresql.Driver | ||
* Database name: postgres | * Database name: postgres | ||
| − | * URL: jdbc:postgresql:postgres | + | * URL: jdbc:postgresql:postgres |
| + | (edit: URL: jdbc:postgresql:\\servername\databasename) | ||
Next, create the connection profile: | Next, create the connection profile: | ||
| Line 23: | Line 21: | ||
* Choose the driver template you just created from the combo box | * Choose the driver template you just created from the combo box | ||
* "Finish" to save the connection profile | * "Finish" to save the connection profile | ||
| + | |||
| + | '''Note''' that you might have to tweak these values for your case. Results in a partial tree in Data Source Explorer, and can be used with the SQL Editor. | ||
Latest revision as of 17:59, 3 November 2006
← Back to How Do I Connect to...
PostgreSQL 8.x
DTP 1.0
DTP 1.0 has driver definitions and a sample connection profile for PostgreSQL. While the catalog loader is not complete, this should give enough content in the Data Source Explorer to be useful.
DTP 0.9.x
DTP 0.9.x does not have a separate PostgreSQL driver template. You can, however, override the values in another driver template to get what is needed here.
- Choose any driver template from the list and override all values
- Name the driver template "PostgreSQL 8.x"
- Jar: postgresql-8.1-404.jdbc2.jar
- Driver: org.postgresql.Driver
- Database name: postgres
- URL: jdbc:postgresql:postgres
(edit: URL: jdbc:postgresql:\\servername\databasename)
Next, create the connection profile:
- Choose "SQL Model-JDBC Connection"
- Give the profile an appropriate name, such as "PostgreSQL"
- Choose the driver template you just created from the combo box
- "Finish" to save the connection profile
Note that you might have to tweak these values for your case. Results in a partial tree in Data Source Explorer, and can be used with the SQL Editor.