it works with 1 with the code:

private void loadBusinessObjects() {
String eavQuery = "from Eav";

numberOfEaven = DataAccessObject.receiveHQL(eavQuery).size();
eaven = new Eav[numberOfEaven];

DataAccessObject.receiveHQL(eavQuery).toArray(eaven);


numberOfPatienten = DataAccessObject.receiveHQL(eavQuery).size();
patienten = new Patient[numberOfPatientn];

DataAccessObject.receiveHQL(patientQuery).toArray(patienten);
}

public String[][] getRowData() {

// maak rowdata met de lengte van de hoeveelheid BO en het aantal attributen = 4
String rowData[][] = new String[numberOfAfdelingen][2];

for (int i = 0; i < afdelingen.length; i++) {
rowData[i][0] = eaven[i].getEavId();
rowData[i][1] = eaven[i].getPatient().getPatientId();
}
return rowData;
}


I`ve tried a lot but it doesn`t work....

String eavQuery = "from Eav, Patient"; <-- i Think this sql statement is correct and that problem is here:

numberOfEaven = DataAccessObject.receiveHQL(eavQuery).size();
eaven = new Eav[numberOfEaven];

from Eav, Patient
wil return a list of array of objects
object[0] has type eav and object[1] has type patient.

Have a look at scalar queries in the reference..

Regards Sebastian

for (int i = 0; i < eaven.length; i++) {
rowData[i][0] = eaven[i].getEavId();
rowData[i][1] = eaven[i].getAfdeling();
rowData[i][2] = patient[i].getpatient().getPatientId();
}
return rowData;
}

it gives error if I put this...

You should post the exception you run into.
I assume that the method is not found, so you must cast your object.
((Patient)eaven[1]).getId

If this is not true, post your exception and your code. Please use the code tag.

Sebastian