I would appreciate if someone will be able to assist us in solving this issue.
The issue is that I have 2 ejb projects say ejbA and ejbB. Let us assume that project ejbA has 2 CMP�s CMP1 and CMP2. Project ejbB has CMP�s CMP1 and CMP2 as well. The Abstract Schema names are not unique in the server scope.
When I had to execute the query select ejb.* from CMP1 ejb , since there is an ambiguity in the ASN names, it requires the queryDomain parameter. And as mentioned in the docs. I tried the ASN, EJB Home object reference pair.
parameterVars - The values to be substituted for any query parameters in the query statement.
queryDomain - Normally a null value. This parameter is null in the cases where the Abstract Schema Names (ASN) used in the query statement are unique in the server scope. If ASN names are not unique across applications in the server, then the ASN name must be qualified by its EJB Home reference. This takes the form of name/value pairs (ASN name, EJB Home object reference). An EJB Home reference can be obtained from a name service lookup call.
skipRows - Number of tuples in the final result set to skip.
maxRows - Maximum number of tuples to return in result set.
QueryException - Indicates an invalid query plan, a server or database error occurred, or the query invoked an application method which threw an exception.