I'm developing an application that uses a Relational Database and I would like an opinion on a possible framework to use. There are two types of tables in the DB: 1. Catalog tables (fixed structure - eg, Document Type, Attribute, Attribute Type, User ...) 2. Data Tables (variable tables structure, variable column’s number, constructed automatically from the data entered in the catalog tables)
For example I have, among other, the two catalog tables
Document Type (IDDocType, DESCR)
Attribute (IDDocType, ID, DESCR, AttibType)
When I insert a new record in the catalog table "Document Type"
(IDDocType = 1, DESCR = 'INVOICES')
creates a new data table "TAB01_'INVOICES'," and when I insert a new record in the "Attribute"
creates a new column in the table "TAB01_'INVOICES'"
This way I can build an administrative application with which to define all the metadata and structure of "data tables" and then populate the data tables and display them in a graphical component table on which to search, set filters, etc. ...
1) Is there a framework (Java) to facilitate the development of this type of application metadata / catalog vs. data? Examples that may say what the catalog tables, which should be the relationship between them and how to create tables dti from these?
2) For browsing and searching / inserting the data tables I thought to use a component such as the JSF datatable. I wish, however, that this graphical component allows to use a table that is not mapped with an ORM (Hibernate, JPA ...) and then having the following features:
Display in tabular format
Sorting of columns
Settings filters directly on the columns
Automatically create a search/inserts/update form
Is there a component with these characteristics, for which you can specify at runtime on which the DB table you want to work?
I posted this question in other forums but I haven't received a response yet.
Next time please note that you've posted to another forum(s). It's ok if you haven't received an answer yet there, but you should be forthright about it. Otherwise, other Ranchers might think you're wasting their time.
Good luck with getting an answer!
The quieter you are, the more you are able to hear.