Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Web Tools Project (WTP) » generate JPA entities from tables(problem with database)
generate JPA entities from tables [message #1022059] Thu, 21 March 2013 04:04 Go to next message
Marco Westermann is currently offline Marco Westermann
Messages: 4
Registered: March 2013
Junior Member
Hi,

When I try to generate classes from my database tables through "JPA tools -> generate entities from tables" I do not get any schemas from my database. I use a Gupta SQLBase DB which not properly work with schemas. Is it somehow possible to see all tables from all schemas, so I can generate the classes?

regards, Marco

Report message to a moderator

Re: generate JPA entities from tables [message #1022305 is a reply to message #1022059] Thu, 21 March 2013 12:37 Go to previous messageGo to next message
Brian Vosburgh is currently offline Brian Vosburgh
Messages: 126
Registered: July 2009
Senior Member
That depends on what DTP driver you are using to connect to your database. Dali (the component of WTP that provides the JPA functionality) uses DTP to retrieve metadata from the database and uses that metadata to generate entities. The easiest way to determine how well DTP interacts with your database is to to open a Data Source Explorer view, connect to your database, and expand the elements in the tree. If you can see your tables listed in that tree, Dali should be able to find those tables and present them to you.

Report message to a moderator

Re: generate JPA entities from tables [message #1022615 is a reply to message #1022305] Fri, 22 March 2013 04:47 Go to previous messageGo to next message
Marco Westermann is currently offline Marco Westermann
Messages: 4
Registered: March 2013
Junior Member
Hi Brian,

thank you for your response. I tested what you said. but the data source explorer doesnt show any tables. It also doesnt show any schemas. Do you know how Dali tries to discover the schemas from the database? I tried the DatabaseMetaData.getSchemas method of my jdbc driver and it returns two schemas. the getCatalogs() method therefor doesnt return valid schemas.

Any further ideas?

regards Marco

Report message to a moderator

Re: generate JPA entities from tables [message #1022723 is a reply to message #1022615] Fri, 22 March 2013 08:26 Go to previous messageGo to next message
Marco Westermann is currently offline Marco Westermann
Messages: 4
Registered: March 2013
Junior Member
I ust figured out that dali uses the getCatalogs method to get the schemas. The jdbc driver returns an empty result set on this method. Is it possible to let dali use the getSchemas method instead?

regards, Marco

Report message to a moderator

Re: generate JPA entities from tables [message #1022765 is a reply to message #1022723] Fri, 22 March 2013 09:32 Go to previous message
Marco Westermann is currently offline Marco Westermann
Messages: 4
Registered: March 2013
Junior Member
I got it to work. I reimplemented the getCatalogs and getSchemas method in the jdbc (by proxying it) and now everything works fine.

regards, Marco

Report message to a moderator

Previous Topic:JavaScript Inferrer and TypeBinding
Next Topic:Apache Derby UI installation exception
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 21 13:25:05 EDT 2013

Powered by FUDForum. Page generated in 0.02807 seconds