• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

common utility class that use for database

 
Nakata kokuyo
Ranch Hand
Posts: 472
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi, i would like to turn my resultset record into list , what are the utility class that i should looking at ?

thank you
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You should look at an Object-to-Relational mapping tool. Hibernate is popular at the moment, Castor and Toplink have been popular before that. There are aothers to look at too.

These tools perform database operations for you and manage all database operations and automatically map them to Java objects, so you don't have to do anywhere as near as much work.
 
Nakata kokuyo
Ranch Hand
Posts: 472
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks for suggestion , david , however i'm working on existing system, which is still tie with jdbc ..

i was once seen thread here mentioned on apache common utility that can store resultSet to list , but i can't recall what utility been use ....
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Nakata kokuyo:
i was once seen thread here mentioned on apache common utility that can store resultSet to list , but i can't recall what utility been use ....


Never heard of any, or may be can't remind that.

We usually go with it using VO pattern. We fill out that particular bean using resultSet object and add that bean to a collection like, ArrayList, Vector or etc.
 
Manoj Kumkumath
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Nakata,

What about rowset?
Rowset

Some one, somewhere also mentioned about a open source FormattedDataSet which has a ResultSetConverter object that converts a ResultSet to an Object[][].

-Manoj
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Manoj Kumkumath:
What about rowset?
Rowset


We have used it in one of our previous project. I found it buggy. It needs lot of fixing and customization. I dont like the way it does the things. Its relatively better to go for some ORM tools like hibernate, JDO etc. or do with your own database access framework.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic