Database Development Perspective in Eclipse for Openbravo,Postgres
April 12, 2011 3 Comments
Eclipse IDE is a great tool for Development and specially for development for an ERP like Openbravo. For setting up Openbravo in Eclipse refer here. Also Eclipse Provides many plug ins that could make the development even easier. There are many perspectives provided in Eclipse. (Refer Screen shot below)
Lets see about the Database Development Perspective in this Blog. Database Development Perspective allows us to connect to database directly, export data as files, import data, query, etc…
To connect your Openbravo postgresql database, these are the steps to be performed.
1. Choose Database Development from the available list of perspectives.
2. Create a new Connection and connect the driver to database. Refer the following screen shots.
3. In the Driver definition, choose your host and database name, the database field can be anything (column1), it does not matter. Its just the name that will show in Eclipse.
4. Once this is done, your eclipse will be as below.
Under Schemas, you will have public that will have the tables and functions.
Now you are connected to your database and you can query, or use the other options as I have shown in the screen shot below.