Eash wari

Greenhorn
+ Follow
since Aug 02, 2011
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Eash wari

Thank you Jesper.

The type of the column is not required because all the column values will be processed as String variables only. I was going through some hibernate materials and I found that they access and update tables in DB. I am working with a view alone. will this create any issue while mapping? There is an ID tag in hbm.xml which should have the primary key.

In this view primary key is composite(four columns). How to have this in ID? Can I use generator for ID if I use view, not a table?
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.