File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes SQL operation against a cached result set Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL operation against a cached result set" Watch "SQL operation against a cached result set" New topic

SQL operation against a cached result set

Zenikko Sugiarto
Ranch Hand

Joined: Jan 09, 2005
Posts: 58
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
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3703

Have you looked at ibatis?

My Blog: Down Home Country Coding with Scott Selikoff
I agree. Here's the link:
subject: SQL operation against a cached result set
Similar Threads
distinct column records
How to count duplicate entries in one column
how Can I fix this problem
Groupby Question