Hi,
I'm not sure what the problem is, since I am using a non-partial query to
rteturn all 3 attributes of the bean. Is there a requirement that they be
named the same ?
This is the error I'm getting from the server:
Auto-deploying kona-ejb.jar (Classes were updated)... Error compiling
C:\orion\applications\kona-app/kona-ejb.jar: Field
used in finder query not found in bean, valid fields are: permName,
permDesc at column 388 in query 'select stpermissions.PERMISSION_ID,
stpermissions.PERMISSION_NAME , stpermissions.PERMISSION_DESCRIPTION from
stgroupperm, stgroup, stuser, stpermissions where stuser.USER_GROUP =
stgroup.GROUP_ID and stgroupperm.GROUP_ID = stgroup.GROUP_ID and
stpermissions.PERMISSION_ID = stgroupperm.GROUP_PERM_ID and
stgroupperm.GROUP_PERM_ALLOWED = 'Y' and stuser.USER_ID = ?'
Yet my orion-ejb.jar has this section for the bean:
<entity-deployment name="UserPermissions"
location="UserPermissions" wrapper="UserPermissionsHome_EntityHomeWrapper51"
max-tx-retries="3" table="STPERMISSIONS" data-source="java:jdbc/ejbDS">
<primkey-mapping>
<cmp-field-mapping>
<fields>
<cmp-field-mapping
name="permID" persistence-name="PERMISSION_ID" />
</fields>
</cmp-field-mapping>
</primkey-mapping>
<cmp-field-mapping name="permName"
persistence-name="PERMISSION_NAME" />
<cmp-field-mapping name="permDesc"
persistence-name="PERMISSION_DESCRIPTION" />
<finder-method partial ="false" query="select
stpermissions.PERMISSION_ID, stpermissions.PERMISSION_NAME,
stpermissions.PERMISSION_DESCRIPTION from stgroupperm, stgroup, stuser,
stpermissions where stuser.USER_GROUP = stgroup.GROUP_ID and
stgroupperm.GROUP_ID = stgroup.GROUP_ID and stpermissions.PERMISSION_ID =
stgroupperm.GROUP_PERM_ID and stgroupperm.GROUP_PERM_ALLOWED = 'Y' and
stuser.USER_ID = ?">
<method>
<ejb-name>UserPermissions</ejb-name>
<method-name>findByUser</method-name>
<method-params>
<method-param>java.lang.String</method-param>
</method-params>
</method>
</finder-method>
</entity-deployment>
