@Query returning Object instead of entity
Ok It seems that you are using a projection over the entity CreditCenter
@Query("SELECT CC.id, CC.loanId, CC.clientId FROM CreditCenter CC")
My first thought is : Why you dont use something like this.
@Query("SELECT CC FROM CreditCenter CC")
that will return the list of the entities, however probably you dont want to return all the fields so my second advice is use this query.
@Query("SELECT new package.to.CreditCenter(CC.id, CC.loanId, CC.clientId) FROM CreditCenter CC")
and add a constructor in Creditcenter that support the order and type of parameters. That will work using JPQL and as jpa repos use that it should work.
public class CreditCenter {
//Member vars
public CreditCenter (int id, int loadid, int clientid){...}
}