MyEclipse :: View topic - How to include Database Views in Scaffold Spring CRUD App?

MyEclipse: How to include Database Views in Scaffold Spring CRUD App?

tilo2k2 - Sep 18, 2011 - 02:45 AM
Post subject: How to include Database Views in Scaffold Spring CRUD App?

Using Scaffold Spring CRUD Application, I can only allow to select database tables. Is there any ways that I can select database views?

If there is no way that I can select database views during Scaffold Spring CRUD Application, please advice how can I have MyEclipse for Spring to generate code for database views with an existing generated code by using Scaffold Spring CRUD Application?

jkennedy - Sep 26, 2011 - 12:47 PM
Post subject:

I'm sorry we do not support scaffolding from views at this time.

Thanks,
Jack

jkennedy - Sep 26, 2011 - 12:50 PM
Post subject:

Sorry, for a bit more detail, the issue has generally been that you can't use JPA to both search and update to views consistently across different DB vendors.

If you only need to show data and not edit it you could likely scaffold from a table that matches your view and then drop the table and make sure the entity Table is mapped to your view name. This would give you read, but likely not write access to the view.

Thanks,
Jack

Smitht19 - Jan 09, 2012 - 08:01 PM
Post subject: Weak Answer to not supporting scaffolding of views

JBOSS tools will support scaffolding of views. I use jboss tools to create the Domain and DAO for views and copy the generate code back in to my Myeclipse for spring project. It is a pain the Myeclipse people just need to add this simple thing for us developers.