Numbers in EJB-QL only support the range of a long, so BigDecimal is not supported. It is planed for EJB-QL, but I never got around to adding it. I suggest you post a feature request if you really want this feature.
I'm using jboss-ql and I thought that BigDecimal was supported in jboss-ql that you for the response to my first question.
I still having the same error in the jbosscmp-jdbc.xml file.
This is the error message
org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "o.bidItemNo <" at line 4, column 17.
My jbosscmp-jdbc.xml file is already posted so i won't post it again, does anyone have any suggestions to what the problem may be. This finder works in weblogic using ejb-ql.
thanks for any help