How do you configure Dynamic SQL Finders?
FireStorm/DAO™ generates special finder methods for each table and view. This finder, known as the "Dynamic SQL Finder", has the following signature:
findByDynamicSql(String sqlWhereClause, Object sqlParams[]);
Sample usage would be:
CustomerDao dao = CustomerDaoFactory.create();
Customer cust[] = ((CustomerDaoImpl)dao).findByDynamicSql(
"last_name = ?",
new Object[] { "Grove" }
);
Please note that you need to cast the DAO interface to the concrete JDBC DAO implementation class since this finder is not portable to other platforms (JDO, EJB) supported by FireStorm.