Select *, perform generic query

From: Diego Maximiliano Iņig (diego_inig..otmail.com)
Date: Mon Apr 25 2005 - 14:13:43 EDT

  • Next message: Filip Balas: "Re: Hierarchical relationship problems"

    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
      
     
     
     



    This archive was generated by hypermail 2.0.0 : Mon Apr 25 2005 - 14:13:45 EDT