domingo, 31 de mayo de 2015

enable connection to postgresql server on Eclipse Luna

On Eclipse Luna to add a connection to postgresql Server follow these steps:

1. go to "Data Source Explorer" tab, on "Database Connections" Double click and choose "New"
2. From the "Connection Profile Types" choose "PostgreSQL" and click on Next
3. On the new Window, on Drivers option click on the button called "New Driver Definition", on "Name/Type" click on "PostgreSQL JDBC Driver", next move to JAR List Tab, then click on "Add JAR/Zip" button
4. Now you have to download the PostgreSQL JDBC Driver available, go to https://jdbc.postgresql.org/download.html and download the appropriate driver for you, this depend on what jdk version you are using. Once you have downloaded it, go to the directory where it is, choose it and click on OK
5. Then just click on "OK"
6. Now, you back on the Window from step 3, in fact it is call "New JDBC Connection Profile", here you need to specify the connection details like Database Name, User Name and Password, you are free to choose the option "Save Password". Once you are done click on "Next", read the Summary page, check if everything is OK and click on "Finish".

Now, if everything is OK on the Data Source Explorer Tab you may click on your database name and see the tables, index and everything.

that's it

No hay comentarios:

Publicar un comentario