Bind Variables and MySQL - need ordinal index array?
490060Mar 7 2006 — edited Mar 9 2006I'm trying to create a search form using a View Object with parameters - similar to example #3 in Steve Muench video examples (http://radio.weblogs.com/0118231/2006/02/13.html#a658).
My question is how to define the bind variables and where clause for MySQL versus Oracle?
When replicating the example above, I set the bind variable in the view object to "lastname1" and the where clause to "where lastname like :lastname1"
When I deploy / execute from Tomcat 5.5.9 I receive the following error:
org.apache.jasper.JasperException: javax.faces.el.EvaluationException: Error getting property 'selectedRow' from bean of type oracle.adfinternal.view.faces.model.binding.FacesCtrlRangeBinding$FacesModel: oracle.jbo.InvalidOperException: JBO-25070: Where-clause param variable lastname1 needs ordinal index array
Note I've read the article, "How To Use ADF Business Components with MySQL" - but it does not go into detail about how to specify the bind variables and setting up the where clause for MySQL. That is, unless there is nothing different I need to do for MySQL and I'm just doing something else wrong..