I'm creating my first EJB component and deployd it succesfully, with JBOSS 3.2.2 using Hypersonic as a default database. When running client test code, the creation of an EJB goes fine but when I try to fetch the data with getLimit() method ( limit as a one field in ejb-component ) I always get the following Exception
2003-11-24 10:41:45,790 ERROR [org.jboss.ejb.plugins.LogInterceptor] EJBException, causedBy:
java.sql.SQLException: Wrong data type: LIMIT n m in statement [SELECT limit FROM CREDITPOLICYENTITYEJB WHERE (customerId='1')]
I cannot understand what is wrong?
Is limit a reserved name in hypersonic?