EJB QL how to create the update Query in webdynpro ejb?

[Former Member]

Hi all

I 'm now prefer to create an Update query in the entity bean,

under the EJB Methode there are folders like this: Create Method / Finder Methode / Home Method / Select Method.

where can i create the Update query and how about the syntax

Like this: update <table-name> b set b.status = 'done' where b.ID like ?1 ???(this query is invalide)

Edited by: bo wang on Mar 13, 2008 3:57 AM

[Former Member · Accepted solution]

Hi,

U can create the update query in business methods.

steps:

Click on folder Business Methods.

Than click on add button below.

then specify any para meter or return type if required.

Click on save.

This method will be added in the implimentation tab.

go on the implementation tab and write update query between @@begin

@@end block of that method

[Former Member · Accepted solution]

Hi Pathan,

I followed your instruction:

Click on folder Business Methods.

Than click on add button below.

then specify any para meter or return type if required.

Click on save.

but after i Click on save, the project cann't save the update method any more, so when change to the implementation tab where i can not find the update method i created.

it seemed that it was unavilable to create an update method under the folder Business Methods

here is under the Entity Bean but not the Session Bean.

Thanks.

Edited by: bo wang on Mar 18, 2008 6:50 AM

[Former Member · Accepted solution]

Hey Friend actually i made a mistake.

Sorry for that.

Please click on Bean tab and not Implementation tab

there u will find that method

[Former Member · Accepted solution]

Hi Pathan

Sorry but it's still can not work:(

what's your MSN, could i add u as friend and talk about it? mine is <email address deleted by moderator>

[Former Member · Accepted solution]

Hello,

You can meet me on gmail.

My ID is <email address deleted by moderator>

I can not access hotmail.

I can be reached after 2:30 on gmail.

[Former Member · Accepted solution]

Hi Pathan,

Maybe i didn't get the right Gmail address from u, and there was no reply from u after i mailed, would u be convenince to add my Gmail: <email address deleted by moderator>

Thanks for your help