Eclipse Community Forums: Web Tools Project (WTP) » Entity Bean Generation from Postgres 8.4 database

Help

Home

Home » Eclipse Projects » Web Tools Project (WTP) » Entity Bean Generation from Postgres 8.4 database

Show: Today's Messages :: Show Polls :: Message Navigator

Entity Bean Generation from Postgres 8.4 database [message #830187]

Tue, 27 March 2012 06:05

shalin lazar
Messages: 18
Registered: February 2012

Junior Member

Hi all,

I've posted elsewhere on the boards, and a kind individual has directed me here. I built a PostgreSQL 8.4 database, but am having problems generating the Entity Beans via JPA's generation tool. He informed me that this wasn't an issue with EclipseLink, so here I am.

Basically I have two problems:

1) Not all Entity Beans are generated (database has around 250 tables).
2) I'm getting various association 'naming' errors.

Basically, I didn't name my foreign key columns <foreignTableName>_<foreignTableColumnName>. Is there any way around this issue (not considering going through all the tables and renaming columns)? And if that is the only option, what would I do if I have two columns referencing the same column on the same table?

Eg. accountTransactCenter.accountId -> account.id and accountTransactCenter.contraAccountId -> account.id

I would really appreciate any help. If you need more information, please let me know.

Thanks and best regards.

[Updated on: Tue, 27 March 2012 06:06]

Report message to a moderator

Re: Entity Bean Generation from Postgres 8.4 database [message #830310 is a reply to message #830187]

Tue, 27 March 2012 09:12

Russell Bateman
Messages: 2915
Registered: July 2009
Location: Provo, Utah, USA

Senior Member

On 3/27/2012 4:05 AM, shalin lazar wrote:
> Hi all,
>
> I've posted elsewhere on the boards, and a kind individual has directed
> me here. I built a PostgreSQL 8.4 database, but am having problems
> generating the Entity Beans via JPA and EclipseLink. He informed me that
> this wasn't an issue with EclipseLink, so here I am.
>
> Basically I have two problems:
>
> 1) Not all Entity Beans are generated (database has around 250 tables).
> 2) I'm getting various association 'naming' errors.
>
> Basically, I didn't name my foreign key columns
> <foreignTableName>_<foreignTableColumnName>. Is there any way around
> this issue (not considering going through all the tables and renaming
> columns)? And if that is the only option, what would I do if I have two
> columns referencing the same column on the same table?
>
> Eg. accountTransactCenter.accountId -> account.id and
> accountTransactCenter.contraAccountId -> account.id
>
> I would really appreciate any help. If you need more information, please
> let me know.
>
> Thanks and best regards.

This is the Eclipse web tools platform forum.

Your question has little to nothing to do with web platform, it would be
more appropriate in the Eclipse data tools or Eclipse Links forums.
(That may be what you mean by "elsewhere on the boards".) For something
like this, I'd ask on stackoverflow.

Report message to a moderator

Re: Entity Bean Generation from Postgres 8.4 database [message #830329 is a reply to message #830310]

Tue, 27 March 2012 09:42

shalin lazar
Messages: 18
Registered: February 2012

Junior Member

Thanks and sorry Russel. I did land up on this forum from a link posted on Dali Java Persistence Tools page. Stackoverflow it is then.

[Updated on: Tue, 27 March 2012 09:43]

Report message to a moderator

Re: Entity Bean Generation from Postgres 8.4 database [message #830357 is a reply to message #830329]

Tue, 27 March 2012 10:24

Russell Bateman
Messages: 2915
Registered: July 2009
Location: Provo, Utah, USA

Senior Member

On 3/27/2012 7:42 AM, shalin lazar wrote:
> Thank and sorry Russel. I did land up on this forum from the link posted
> on Dali Java Persistence Tools page. Stackoverflow it is then.

--just saying. Sometimes a "between two worlds" problem is hard to
resolve. stackoverflow is particularly good at it.

Report message to a moderator

Re: Entity Bean Generation from Postgres 8.4 database [message #830359 is a reply to message #830329]

Tue, 27 March 2012 10:33

Karen Butzke
Messages: 220
Registered: July 2009

Senior Member

Actually, since Dali Java Persistence Tools Project (JPT) is a subproject of the Web Tools Project this is a perfectly fine place for these questions. An even better place would be the Dali forum http://www.eclipse.org/forums/index.php/f/113/ since the Entity Generation code is written in the JPT plugins.

It seems odd to me that Dali has generated @JoinColumns({}) when it sounds like we should have generated @JoinColumns(name="currencyId", referenceColumnName="id"). Given that and the fact that not all of the Entities are being generated I wonder if you have errors in the error log after the generation. If that is the case you could post the stack trace or log a bug against Web Tools -> Dali JPA Tools.

Thanks,
Karen

Report message to a moderator

Re: Entity Bean Generation from Postgres 8.4 database [message #830377 is a reply to message #830187]

Tue, 27 March 2012 10:53

Karen Butzke
Messages: 220
Registered: July 2009

Senior Member

I have also entered a bug against Dali to make our specific forum more prominent on our website. I think this is a result of being a subproject of WTP, we have the WTP banner at the top of our page instead of a more specific banner.

Report message to a moderator

Re: Entity Bean Generation from Postgres 8.4 database [message #831179 is a reply to message #830377]

Wed, 28 March 2012 11:18

shalin lazar
Messages: 18
Registered: February 2012

Junior Member

Well no responses from stackoverflow. In fact, the best responses I've got thus far have been from Karen.

By stack trace, do you mean any outputs on Indigo's console? where can I find a log of errors other than the 'Markers' view?

Its exactly as you say ... @JoinColumns({}) instead of JoinColumns(name="currencyId", referenceColumnName="id"). But, if I try editing the generated code as such (and I don't like editing generated code) a new error is raise stating that currencyId cannot be resolved on the table. So I really don't know what to do.

I'm think about trying helios and/or going back to NetBeans, cause this is taking up a lot of time, and I haven't got any responses or found a solution yet.

Report message to a moderator

Re: Entity Bean Generation from Postgres 8.4 database [message #831224 is a reply to message #831179]

Wed, 28 March 2012 12:32

Karen Butzke
Messages: 220
Registered: July 2009

Senior Member

Quote:

Well no responses from stackoverflow. In fact, the best responses I've got thus far have been from Karen.

I'm trying my best to help now, I didn't see you on EclipseLink or WTP forums until others had responded. I know it's tough for users to know which project is implementing which functionality.

Quote:

By stack trace, do you mean any outputs on Indigo's console? where can I find a log of errors other than the 'Markers' view?

There is a view called 'Error Log'. Use ctrl-3 and type in Error Log. This is for exceptions that happen while running eclipse. If there is an exception occuring while generating entities, that could explain why the empty JoinColumns() annotation is being generated.

On stack overflow I see you saying that not all the entity beans are generated. Why are you generating them 70 tables at a time? Was there a problem you hit trying to do all 250 tables? Dali will not generate the entities correctly if there are references between tables and you don't generate those at the same time.

Thanks,
Karen

Report message to a moderator

Re: Entity Bean Generation from Postgres 8.4 database [message #831238 is a reply to message #831224]

Wed, 28 March 2012 12:58

Karen Butzke
Messages: 220
Registered: July 2009

Senior Member

http://www.eclipse.org/forums/index.php/t/318389/ - further discussion on the Dali forum

Report message to a moderator

Previous Topic:	Programatically Creating Deployment Descriptor
Next Topic:	I want to contribute to eclipse sse line completion but the content assist framework is internal

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 19:55:52 EST 2013