Looks like the find is returning a array
Am I doing something wrong?

Hibernate version: 2.1.6

Mapping documents:

Code between sessionFactory.openSession() and session.close():
colDoc = session.find("select doc from Documento doc " +
"left join fetch doc.docPK.codCli cliente " +
"left join fetch doc.codCli.codOrg org");

Full stack trace of any exception that occurs:
14:22:39,844 INFO [STDOUT] Hibernate: select documento0_.COD_CLI as COD_CLI0_, documento0
_.INX_DOC as INX_DOC0_, organizaca2_.COD_ORG as COD_ORG1_, documento0_.COD_CLI as COD_CLI2
_, documento0_.INX_DOC as INX_DOC2_, documento0_.COD_CLI as COD_CLI0_, documento0_.COD_INS
TALACAO as COD_INST3_0_, documento0_.COD_LIVRO_LEITURA as COD_LIVR4_0_, documento0_.COD_LO
CALIDADE as COD_LOCA5_0_, documento0_.COD_LOTE_FATURAMENTO as COD_LOTE6_0_, documento0_.CO
D_MOTIVO_EXC as COD_MOTI7_0_, documento0_.COD_TIPO_DOC as COD_TIPO8_0_, documento0_.COD_UN
ID_OPER as COD_UNID9_0_, documento0_.DAT_CRIACAO_FATURA as DAT_CRI10_0_, documento0_.DAT_E
MISSAO_FATURA as DAT_EMI11_0_, documento0_.DAT_EXC as DAT_EXC0_, documento0_.DAT_FIM_COB a
s DAT_FIM13_0_, documento0_.DAT_INCLUSAO_REG as DAT_INC14_0_, documento0_.DAT_INI_COB as D
AT_INI15_0_, documento0_.DAT_PREV_CORTE as DAT_PRE16_0_, documento0_.DAT_PROC_ARQ_ORG as D
AT_PRO17_0_, documento0_.DAT_VENCTO_FATURA as DAT_VEN18_0_, documento0_.FLG_DEB_AUT as FLG
_DEB19_0_, documento0_.IND_CONTENCIOSO as IND_CON20_0_, documento0_.MES_REF_FATURA as MES_
REF21_0_, documento0_.NUM_FATURA as NUM_FATURA0_, documento0_.QTD_TENTATIVA as QTD_TEN23_0
_, documento0_.TOT_FATURA_AVISO_DEB as TOT_FAT24_0_, documento0_.VLR_FATURA as VLR_FATURA0
_, organizaca2_.NOM_ORG as NOM_ORG1_, organizaca2_.COD_ORG_EXT as COD_ORG_3_1_, organizaca
2_.FLG_ATIVO as FLG_ATIVO1_, organizaca2_.DSC_CAMINHO_LOGO as DSC_CAMI5_1_, documento0_.CO
D_CLI as COD_CLI2_, documento0_.COD_INSTALACAO as COD_INST3_2_, documento0_.COD_LIVRO_LEIT
URA as COD_LIVR4_2_, documento0_.COD_LOCALIDADE as COD_LOCA5_2_, documento0_.COD_LOTE_FATU
RAMENTO as COD_LOTE6_2_, documento0_.COD_MOTIVO_EXC as COD_MOTI7_2_, documento0_.COD_TIPO_
DOC as COD_TIPO8_2_, documento0_.COD_UNID_OPER as COD_UNID9_2_, documento0_.DAT_CRIACAO_FA
TURA as DAT_CRI10_2_, documento0_.DAT_EMISSAO_FATURA as DAT_EMI11_2_, documento0_.DAT_EXC
as DAT_EXC2_, documento0_.DAT_FIM_COB as DAT_FIM13_2_, documento0_.DAT_INCLUSAO_REG as DAT
_INC14_2_, documento0_.DAT_INI_COB as DAT_INI15_2_, documento0_.DAT_PREV_CORTE as DAT_PRE1
6_2_, documento0_.DAT_PROC_ARQ_ORG as DAT_PRO17_2_, documento0_.DAT_VENCTO_FATURA as DAT_V
EN18_2_, documento0_.FLG_DEB_AUT as FLG_DEB19_2_, documento0_.IND_CONTENCIOSO as IND_CON20
_2_, documento0_.MES_REF_FATURA as MES_REF21_2_, documento0_.NUM_FATURA as NUM_FATURA2_, d
ocumento0_.QTD_TENTATIVA as QTD_TEN23_2_, documento0_.TOT_FATURA_AVISO_DEB as TOT_FAT24_2_
, documento0_.VLR_FATURA as VLR_FATURA2_ from SSC_documento documento0_, SSC_CLIENTE clien
te1_, SSC_org organizaca2_ where documento0_.COD_CLI=cliente1_.COD_CLI(+) and cliente1_.CO
D_ORG=organizaca2_.COD_ORG(+)

14:23:12,622 INFO [STDOUT] class [Ljava.lang.Object;


Name and version of the database you are using: oracle 8i

I don't believe you.

I found the problem
it was something related with the PK.

I executed :

colDoc = session.find("select doc from Documento doc " +
"left join fetch doc.codCli cliente " +
"left join fetch doc.codCli.codOrg org");

and it runs fine