When we create a domain, we get all tables from datasource, with their columns, types, etc.
It's all good.
But in our database, we have a "description" metadata column in all our fields.
For exemple a table "USER" :
USER :
_________________________________________________________
name type description
_________________________________________________________
id bigint "the id of user"
name varchar "the name of user"
birthdate date "the birthdate of the user"
etc...
In domain, we get the fields name, and the field type, but we don't get the field "description".
There is a "description" column in domain for each field but is empty.
Can we make jasper get automatically the column description from database and fill the description in the domain with this ?
It's possible with jdbc to get this database metadata information easily. I did it with a java project and a jdbc driver and it works.
A website that explain how to get the description.
The functionnality i need is jasper get this description and fill the description in the domain.
https://www.baeldung.com/jdbc-database-metadata
Components | Domains |
Here database screen of description column and domain screen of description column