Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Language IDEs » Java Development Tools (JDT) » EclipseLink -> JPA Tools -> Generate Entities from Tables (Postgres)(Generated EntityBeans with errors)
EclipseLink -> JPA Tools -> Generate Entities from Tables (Postgres) [message #828198] Sat, 24 March 2012 11:18 Go to next message
shalin lazar is currently offline shalin lazarFriend
Messages: 18
Registered: February 2012
Junior Member
Hi all,

I'm not sure where to ask this, so if I'm in the wrong place, apologies in advance.

I have built a large database in PostgreSQL 8.4, with quite a few Stored Functions, Triggers, etc. in order to increase the performance of my application and for functional requirements such as avoiding gaps in some sequences.

I've build Java EE applications before on NetBeans, but have chosen Eclipse for obvious reasons. I've been following the following tutorial:


... in order to get around some specifics, but I've run into a problem at the first hurdle which I cannot seem to figure out.

When generating entities from my database, the resulting Entity Beans are full of errors: some tables are not even generated even though I selected all tables in the wizard.

I think the main reason is that I do not have a fixed structure of tables in my database. For example, some tables have up to 4 columns as a collective primary key, while others have just a column and a row to store a count variable. The database indexing is fine as it is and can run without any problems on its own. I'm mostly planning on building the front end (Swing) and finishing off the smaller (quicker) business logic through Session and Message-Driven beans.

So that is a basic intro of the state I'm in. There are quite a few errors ... I'll list the ones I've noted as of now:

1) Some tables are not generated as entity beans.
2) Some associations generate naming errors: So far, I've only noted SOME @ManyToOne associations. I'll go into more detail here.

In the Table Associations frame of the Entity Generation wizard, I've noted a ManyToOne relation. The Table join section seems fine, as do the properties of both tables involved.

Eg: accountTransactCenter.currencyId =

However, has the following error:

//bi-directional many-to-one association to Currency
@ManyToOne --> error
private Currency currency;

Mouse-over the error: Join column "currency_id" cannot be resoved on table "accountTransactCenter"

Now, I made a few errors in my DB development. Mainly, name errors. I followed java method style, starting all DB identifiers with lowercase with an proceeding word beginning with an upper case. Postgres supports identifiers with uppercase characters by double-quoting them. As I was using a GUI client in pgadminIII, I only noticed this when I had done quite a bit of work.

Secondly, and I do not think this is an error, I name my foreign keys as such:


This could be the only reason I can think of as to why currency_id was raised as an error, as I had not entered any such name into a column or table name. Are my suspicions correct? So, for the example given, the foreign key in accountTransactCenter would be:

fki_accountTransactCenter_currency_id (fki is generated by Postgres).

Other than this, I haven't found anything else. I know I should have tried an easier example before building my whole database, but is there any way around these issues?

Thanks and best regards.
Re: EclipseLink -> JPA Tools -> Generate Entities from Tables (Postgres) [message #829378 is a reply to message #828198] Mon, 26 March 2012 07:59 Go to previous messageGo to next message
shalin lazar is currently offline shalin lazarFriend
Messages: 18
Registered: February 2012
Junior Member
Bump Smile

I should state that I'm using EclipseLink for JPA 2.0 on Indigo. I'm using Postgres' jdbc4 driver which is working well. Can't seem to figure out why I'm getting this error both on Windows and Linux (It was a long shot I know ... but should give you an idea of how much help I could use. I really have no clue how to solve this).

I will try using Hibernate as my persistence provider, then an older TopLink. Hopefully, something will come through.

I should also add that I'm running a glassfish 3.1.1 application server.

Any help/comments would be greatly appreciated.


[Updated on: Mon, 26 March 2012 08:06]

Report message to a moderator

Re: EclipseLink -> JPA Tools -> Generate Entities from Tables (Postgres) [message #829697 is a reply to message #829378] Mon, 26 March 2012 17:04 Go to previous message
David Wegener is currently offline David WegenerFriend
Messages: 1409
Registered: July 2009
Senior Member
Your asking your questions in the wrong forum. This forum is for the Java Development Tools. Your question seems to be about Java EE. You might get some help in the Web Tools forums.
Previous Topic:DeCompile Java Code
Next Topic:Unable to run Maven Commands from Eclipse IDE
Goto Forum:

Current Time: Wed Jun 20 06:02:23 GMT 2018

Powered by FUDForum. Page generated in 0.01790 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top