I think it would be a lot easier to write a webservice with cfml and call it with java. By the way, this calling application that needs a cfquery object, is it cold fusion?
I appologize. I wasn't very clear with my original question.
I'm creating an instance of my Java class from within CF using createObject("java", "com.example.MyClass"). So based on the sample code in my original post on the CF side I'd like to do something like this:
myObj = createObject("java", "com.example.MyClass");
myCFQuery = myObj.getQuery(); // Return a CF query from my java class
... then do stuff like ...
<cfquery name="mySortedQuery" dbtype="query">
order by color
I appriciate your suggestions so far. I have other solutions working already but they are not ideal. I was just hoping someone had a clean and as-hack-free-as-possible way of creating a ColdFusion query result set in Java and passing it back to CF.
I do not think there is a documented api, other than the one for cfx tags. Though I would love to see one myself ..