One more question... As i can see, my repository's configuration is ok.
I have this field <field-descriptor name="cod_tdestinoId" column="COD_TDESTINO" jdbc-type="VARCHAR" access="anonymous" /> and this reference-descriptor <reference-descriptor name="idDestino" class-ref="es.indra.aunabill.vo.Tdestinos" > <foreignkey field-ref="cod_tdestinoId"/> </reference-descriptor> But in the table's bean in java, i think i must have a property (with its getter and setter) which name must be "idDestino" Is that true?? Which kind of type must be this property?, String? int? Thanka a lot. ________________________________ De: Robert S. Sfeir [mailto:[EMAIL PROTECTED] Enviado el: mi� 03/11/2004 20:50 Para: OJB Users List Asunto: Re: references foreign key Wild guess... Is your idServicio an integer or a string? It seems like you might have it defined as a string when it should be an int. R On 11/3/04 2:42 PM, "David Morales de Frias" <[EMAIL PROTECTED]> wrote: > Hi � > > Please, can you help me? > > When i throw a queryByCriteria, querying an object that have foreign keys, > this sql spends a lot of time executing and suddenly it throws this error > > [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: > SQL:SELECT > A0.ID_PACKAGES,A0.NUM_TFNO_DESTINO,A0.COD_TLLAMADA,A0.NUM_RESUMEN,A0.SERVICIO_ > LLAMADA,A0.COD_MERCADO,A0.COD_TTARIFA,A0.FECHA,A0.COD_TSERVICIO,A0.CODIGO_AREA > ,A0.COD_TDESTINO,A0.CATEGORIA_LLAMADA,A0.COD_TPERIODO,A0.DURACION,A0.COSTE,A0. > TCATEGORIA,A0.MSISDN,A0.NUM_TFNO_ORIGEN,A0.CODIGO_PAIS,A0.MODELO_TARIFAS,A0.CO > D_FACTURA,A0.HORA_INICIO,A0.FECHA_FACTURA,A0.COSTE_IC FROM > AUNABILL_DES.TAFM_DETALLE_LLAMADAS A0 WHERE A0.COD_FACTURA = ? > > [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: > SQL:SELECT A0.DESCRIPCION2,A0.COD_TSERVICIO,A0.DESCRIPCION1,A0.DESCRIPCION3 > FROM AUNABILL_DES.TSERVICIOS A0 WHERE A0.COD_TSERVICIO = ? > > [PersistentField] ERROR: while set field: > > [try to set 'object value' in 'target object' > > target obj class: es.indra.aunabill.vo.Tafm_detalle_llamadasJOIN > > target field name: idServicio > > target field type: class java.lang.String > > object value class: es.indra.aunabill.vo.Tservicios > > object value: [COD_TSERVICIO] TEL [DESCRIPCION1] Telefon�a [DESCRIPCION2] > Telefon�a [DESCRIPCION3] Telefon�a > > ] > > org.apache.ojb.broker.metadata.MetadataException: IllegalAccess error setting > field:idServicio in object:es.indra.aunabill.vo.Tafm_detalle_llamadasJOIN > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
