Selecting Prepare for Deployment results in Error WQRY0036E in Rational Application Developer

Technote (troubleshooting)


Problem(Abstract)

Selecting Prepare for Deployment results in Error WQRY0036E in IBM Rational Application Developer for WebSphere Software.

Symptom

The following error is displayed.

Deployment from com.ibm.etools.ejbdeploy.EJBDeployer had errors:
...
...
Error=WQRY0036E: {0} {1} does not have a field {2}


Example of the error:

Deployment from com.ibm.etools.ejbdeploy.EJBDeployer had errors:
Error generating findStatusByEmployeeID(java.lang.String) query for bean EmployeeBean (Abstract schema name=EmployeeSchema).
Error=WQRY0036E: EmployeeBean o does not have a field employee Query='select object(o) from EmployeeBean o where o.employee.uUID = ?1 and o.active = true'

Cause

If the schema was originally generated using WebSphere Application Server Version 3.5 compatible switch or imported a WebSphere Application Server Version 3.5 JAR, the table names are appended with 'tbl' and will not be recognized.

Resolving the problem

The EJB/RDB "match by name" in meet in the middle mapping options will only handle exact matches of table names. Tables names that are appended with "tbl" will not be recognized.


WORKAROUND:
Create the mapping of the unmapped beans and tables.

See this link for the detailed information.


Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Application Developer for WebSphere Software
EJB Development

Software version:

7.0, 7.5, 7.5.1, 7.5.2, 7.5.3

Operating system(s):

Linux, Windows

Reference #:

1398382

Modified date:

2013-03-20

Translate my page

Machine Translation

Content navigation