Problem in placing the EJB queries

[Former Member]

Hi all,

I am working on the migration of an application from J2EE to SAP WAS.

The original application contains some EJB queries present in the file sun-j2ee-ri.xml.

Entery for one of the query is given below:

<ejb20-cmp>

<sql-statement>

<operation>storeRow</operation>

<sql>UPDATE "UserEJBTable" SET "password" = ? WHERE "userName" = ? </sql>

</sql-statement>

<sql-statement>

<operation>findByPrimaryKey</operation>

<sql>SELECT "userName" FROM "UserEJBTable" WHERE "userName" = ? </sql>

</sql-statement>

</ejb20-cmp>

I cannot understand where(in which file) to make entry for this query.

Please help me out with this problem.

[kishorg]

Hi Neethu ..

can u create one more finderMethod in ur EJB?.

then that will be dislayed in the persistent.xml files.

u can select that findermethod from Query subtab , and write ur own queries there..

not sure , u can overwrite the standard finderMethod..

Regards

Kishor Gopinatha