ColdFusion Query to java.sql.ResultSet

Question

I've looked in the "undocumentation", and I can see how to create a coldfusion.sql.QueryTable from a ResultSet, but not the other way around. So, how can I extract the java.sql.ResultSet from a ColdFusion ( coldfusion.sql.QueryTable ) query object?

Answer 1

Turns out all I had to do was pass in my coldfusion.sql.QueryTable object...don't know why it works, unless ColdFusion is doing some sort of magic casting under the hood.

Answer 2

coldfusion.sql.QueryTable implements javax.sql.RowSet, which extends java.sql.ResultSet

Thus, as you discovered, you don't need to do anything. A ColdFusion query is already a Java ResultSet.