Hi All,
I am new to Java and writing some code to retreive data from a DB view.
1. The code can access a view alone in the DB, so only data retreival using 'select where' query. (no update, delete, create queries )
2. The view contains 18,000 rows with 150 coulmns.
3. Number of columns may decrease/increase often.
As of now I am storing the JDBC result set in List<Map<String,String>>
Most of the times the query sent is "select * from table_name". I need all the columns for my processing and i do not need to take care of what is the column type(timestamp,varchar,etc all will be treated as string values).
Is this a right approach? Should I use a ORM for this? I was told ORM will be helpful if i have to persist the data in object . In my case i need the column name and its value for each row. so I'll end up having List of customObjects instead of Maps if I use hibernate. Please guide me on finding an efficient approach.