Generation of code based on the table meta data..

Question

Is there any free tool which can generate data entry and listing screen for a database table(Oracle) based on the metadata. Desired features:

• Drop downs for reference data
• Abilty to customise the label name, showing/hiding specific column of the table, ordering of columns etc..
• Operation on listing screen (modify,delete,activate,deactivate etc.)
• import the data from CSV file.
• Ability to add custom validation before save/modify the data in DB.

• Pre Delete Validations.

• Option to choose technology stack e,g, (Struts 2, Spring, Hibernate) or (Struts 1, EJB,DAO pattern) etc.

Answer 1

For Oracle database there is a tool called APEX that can generate views and edit pages starting from db structure.

This is the pointer: http://www.oracle.com/technetwork/developer-tools/apex/overview/index.html

But APEX has its own technology stack and it does not generate code, it's a Access-like framework to handle Oracle db data.

Answer 2

As you are interested in Java technology I urge you to check out JDeveloper. It gets over-looked by Java people because it's not Eclipse but it has lots of cool features. In particular its ADF BC wizards can generate quite sophisticated data-driven components. Find out more.

Oh, and the tool is free as in free beer, although there are licences payable to deploy ADF and TopLink components. Thanks to carpenteri for pointing out the relevant documentation.

Answer 3

these exist (www.enterprise-elements.com) but are certainly not free.