Hello,
Is there a way to query a resultset in
java. Yes what I mean is after obtaining one resultset, again query on that resultset like we do to a table in the DB.
Here is my problem in detail and any help doing the same in Java will be most appreciated :-)
I am working on a peculiar problem where we are moving our application from cold fusion to Java. Cold fusion being very powerful for database oriented applications my project was initially developed using CF and uses a lot of advanced features of CF. However the need to move to java was soon realised due to various reasons. Now one of the main problems we are facing is the CFQUERY tag in cold fusion.
This tag lets you create a resultset by
<cfquery name="aaa" datasource="blah-blah">
QUERY COMES HERE
</cfquery>
The best part is.... you can also query the above resultset obtained as follows:
<cfquery name="bbb" dbtype="query">
SELECT * from aaa where ***************
</cfquery>
We have used it so often in CF since it significantly reduces the query throughput times. Now we would love to find a way to do the same in Java.
Any ideas
Thanks
Karen