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