I am having a tough time implementing the auditing feature in Spring framework using JPA and Hibernate. Earlier the application was in simple JDBC and servlets and we are moving in with Spring and all that latest technology.
Here is the sample problem.
Consider there is a big table called Transactions which store the transaction of a particular Employee. I am having a bean for Transactiion like
And I have an Audit table to store the auditing details.The Audit table has one column IMAGE(BLOB type) in which I am storing the entire object of Transaction.
So the entire detail of a transaction(CRUD) is captured here.
The problem is that this TRANSACTION is a very big table(say having 50 columns) and the user wants to see 5 columns plus it should be also configurable.
Eg: One user can configure to see 5 columns today and 10 columns tomorrow. Earlier we were maintaining a separate table(AUD_CONFIG) to store the column names , a user want to see. Everything was fine till we were using the traditional JDBC but now the project needs to be upgraded to Spring with Hibernate using JPA. Now, I have the entire data in AUDIT table and an object of transaction which has 50 columns but the question is how to display it in a single screen?
somehow ,the user should be able to configure the fields he needs to see in the screen.
So please provide me any help to achieve this solution