Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL operation against a cached result set

 
Z Sugiarto
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I would illustrate what I am trying to do with an informal pseudo-code




In other words: is there such a class that does what FooStructure is doing? holding the content of a ResultSet in a structure that we can apply normal SQL operations against?

I know that some people would say, well why don't you put the select distinct column1 in the initial query in the first place. THIS IS NOT THE POINT (pardon the caps). The point is, I am looking for a SQL-aware data structure that is ResultSet-friendly... (before I go and reinvent one..)

... anyone?
 
Scott Selikoff
author
Saloon Keeper
Posts: 4020
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you looked at ibatis?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic