title: How does one convert from a Java resultset to ColdFusion query in Railo?
body: <p>The following works fine in CFMX 7 and CF8, and I'd assume CF9 as well:</p>
  
  <pre><code>&lt;!--- 'conn' is a JDBC connection ---&gt;
  &lt;cfset stat = conn.createStatement() /&gt;
  &lt;cfset rs = stat.executeQuery(trim(arguments.sql)) /&gt;
  
  &lt;!--- convert this Java resultset to a CF query recordset ---&gt;
  &lt;cfset queryTable = CreateObject("java", "coldfusion.sql.QueryTable")&gt;
  &lt;cfset queryTable.init(rs) &gt;
  &lt;cfset query = queryTable.FirstTable() /&gt;
  </code></pre>
  
  <p>This creates a statement using a JDBC driver, executes a query against it, putting it into a java resultset, and then coldfusion.sql.QueryTable is instantiated, passed the Java resulset object, and then queryTable.FirstTable() is called, which returns an actual coldfusion resultset (for cfloop and the like).</p>
  
  <p>The problem comes with a difference in Railo's implementation.  Running this code in Railo returns the following error: No matching Constructor for coldfusion.sql.QueryTable(org.sqlite.RS) found.</p>
  
  <p>I've dumped the Railo java object, and don't see init() among the methods.  Am I missing something simple?  I'd love to get this working in Railo as well.</p>
  
  <p>Please note: I am doing a DSN-less connection to a SQLite db.  I understand how to set up a CF datasource.  My only hiccup at this point is doing the translation from a Java result set to a Railo query.</p>