Database Development Perspective in Eclipse for Openbravo,Postgres

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.

Happy Working..:)

Advertisements

About Shankar Balachandran
Technical Manager, Openbravo operations, Kailao Consulting Private Limited

3 Responses to Database Development Perspective in Eclipse for Openbravo,Postgres

  1. John Fandl says:

    Shankar, great post!

    In case you don’t know it, Hibernate Tools is another Eclipse plugin, and it lets you access Openbravo ERP data through the Openbravo DAL (Data Access Layer), in a database-independent way, see http://planet.openbravo.com/?p=8642, Would love to hear any feedback from you comparing to the two approaches, i.e. what cases you might prefer one over the other?

  2. Shankar Balachandran says:

    Hi John,
    I have tried using Hibernate Tools and its truely yet another remarkable plugin for Openbravo Development. I would put forth the following points in favour of Hibernate Tools

    1. Once you configure Hibernate tools, the underlying database development perspective will be formed by itself (its rather a subset of hibernate tools)

    2. Its not database specific which means irrespective of the database perspective, the HQL queries will remain the same mostly.

    3. With 3.0 gaining prominence we should slowly untie ourselves from SQL,SQLC and gradually move towards the novel DAL (Data Access Layer) way.

    4. With tools like HQL Query tool and these plugins, understanding the hibernate layer is also made easier and now I feel that the persistence layer has a purpose.

    Having said all this, I still feel for novice programmers new to Openbravo development, the database perspective will be a good starting point because they will be more familiar with SQL’s than Hibernate Queries.

    Would like to hear more on this from all…

  3. magomarcelo says:

    pgadmin3 any time, DTP does not even show sequences

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: