I use the new cayenne 1.2M3, and I need run this query:
SELECT * FROM DBAORA.TT10COTIZACION, DBAORA.TT20MODELO
WHERE TT10NROCOT = 1
AND TT10NROCOT = TT20NROCOT
DataContext ctxt = BasicServletConfiguration.getDefaultContext(request.getSession());
String sql = "SELECT * FROM DBAORA.TT10COTIZACION, DBAORA.TT20MODELO " + " WHERE TT10NROCOT = 1 AND TT10NROCOT = TT20NROCOT";
SQLTemplate query = new SQLTemplate(Vtvh010Clientes.class,sql,true);
List data = null;
try{
data = ctxt.performQuery(query);
}catch(org.objectstyle.cayenne.CayenneRuntimeException e){
but don't return any rows, why???
the Vtvh010Clientes.class not corresponding with 2 tables for this query DBAORA.TT10COTIZACION, DBAORA.TT20MODELO, it is the problem??? how to resolve this problem, beucase i need all colunm the query.
In general, my problem is, How i can perform a generic query in the DataContext (SqlSelectQuery is deprecated) without any ObjEntity and DbEntity
Any help would be much apreciatted. Thanks
Diego