ColdFusion request on java.sql.ResultSet

Question

I looked through the "undocumentation" and I see how to create coldfusion.sql.QueryTable from a ResultSet , but not vice versa. So how can I extract java.sql.ResultSet from a ColdFusion query object ( coldfusion.sql.QueryTable )?

Answer 1

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

Thus, as you have discovered, you do not need to do anything. The ColdFusion request is already a Java ResultSet.

Answer 2

It turns out that all I needed to do was pass my coldfusion.sql.QueryTable ... I don’t know why it works, unless ColdFusion does magic casting under the hood.