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 07:18 Go to next message
shalin lazar is currently offline shalin lazar
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:

programming[dot]manessinger[dot]com[slash]tutorials[slash]an-eclipse-glassfish-java-ee-6-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 = currency.id

However, AccountTransactCenter.java has the following error:

//bi-directional many-to-one association to Currency
@ManyToOne --> error
@JoinColumns({})
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:

localTable_foreignTable_foreignTableColumnName.

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 03:59 Go to previous messageGo to next message
shalin lazar is currently offline shalin lazar
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.

Thanks.

[Updated on: Mon, 26 March 2012 04: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 13:04 Go to previous message
David Wegener is currently offline David Wegener
Messages: 1336
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 Aug 20 04:52:02 EDT 2014

Powered by FUDForum. Page generated in 0.01800 seconds