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?
Thank a lot.
-----Mensaje original-----
De: Robert S. Sfeir [mailto:[EMAIL PROTECTED]
Enviado el: mi�rcoles, 03 de noviembre de 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]
