I have a straight SQL pass-through that runs just fine but the results in the IDfCollection is only 1.
There should actually be a lot more but I'm wondering how to get the data out of a sql pass-through on a READ query.
public static final String SQL="select " +
"all nike_asset.r_object_id," +
"nike_asset.object_name," +
"nike_asset.title," +
"nike_asset.subject," +
"nike_asset.resolution_label," +
"nike_asset.owner_name," +
"nike_asset.owner_permit," +
"nike_asset.group_name," +
"nike_asset.group_permit," +
"nike_asset.world_permit," +
"nike_asset.log_entry," +
"nike_asset.acl_domain," +
"nike_asset.acl_name," +
"nike_asset.language_code," +
"nike_asset.asset_comments," +
"nike_asset.asset_image_photographer," +
"nike_asset.asset_type," +
"nike_asset.asset_content_type," +
"nike_asset.r_object_type," +
"nike_asset.r_creation_date," +
"nike_asset.r_modify_date," +
"nike_asset.a_content_type " +
"from nike_asset_sp nike_asset " ;
@Test(groups = "session")
public void testSQL() throws Exception {
ISession session = sessionManager.getSession();
IDfQuery query = new DfQuery();
String queryString = "EXECUTE exec_sql with query ='"+SQL+"'";
query.setDQL(queryString);
IDfCollection coll = query.execute(session.getIDfSession(), IDfQuery.QUERY);
while (coll.next()) {
coll.getString("nike_asset.r_object_id");
}
coll.close();
}
