private static final String[][] DB_MAPPING = new String[][]{ {"ACCOUNT_ID", "AccountID"}, {"CUSTOMER_ID", "CustomerID"}, {"BOND_TYPE", "BondType"}, {"DIVIDEND", "Dividend"}, {"AccountFull/CIM_CUSTOMER", "AccountFull/Customer"), {"NAME", "Name"}, {"ADDRESS", "Address"} }; public static AccountFull getAccountFullObject(long accountID) { String queryText = "select * from \"CIM_BANKACCOUNT\" "+ "where \"CIM_BANKACCOUNT\".\"ACCOUNT_ID\" = :AccountID "; QueryObject query = new QueryObject(queryText); query.addParameter("AccountID", "CIM_BANKACCOUNT.ACCOUNT_ID", QueryObject.PARAM_INT, new Long(OrderID)); String associationQueryText = "select * from \"CIM_CUSTOMER\" where \"CIM_CUSTOMER\".\"CUSTOMER_ID\" = :CustomerID "; AssociationQueryObject associationQuery = new AssociationQueryObject(associationQueryText, "CIM_BANKACCOUNT", "CIM_CUSTOMER"); associationQuery.addParameter("CustomerID", "CIM_BANKACCOUNT.CUSTOMER_ID", QueryObject.PARAM_INT, null);//NOPMD query.addAssociationQuery(associationQuery); query.setResultClass(AccountFull.class); query.setResultMapping(QueryObject.MAP_SPECIFIED, DB_MAPPING); return (AccountFull)query.getObject(); }