iam getting error while insert .

[Former Member]

HI every one , i getting error while doing insert data into backend table.the error is like this , could you clarify is it possible to change the lookup of sappd1db to other.

Object not found in lookup of SAPPD1DB.

[Former Member · Accepted solution]

Hi Eswar,

go to J2EE perspective..expend ur Ejb project n now double click on persistent.xml file

now in right pane first deselect switch off verification ,if its selectd..

then select No automatic locking..

now in datasource name input field u can write ur new datasource sys ID..

secondly..go to entity bean tab after doin this in same pane

n expend entity bean

nw check for ejb field's mapping for corressponding fields ..

id it shows table is varified by d dictionary thn its fine else u map it wid correct fields..

now save the changes..n delete ue old .jar file of ejb project n create new..now create new .ear file for application project aftr deleting old one...n deploy new1....

hpe it hlps u...

Regards,

Khushboo

[Former Member · Accepted solution]

HI Khushboo Singhal,

Thanks ur's relpy but iam using only session bean ,that to stateless session bean.

it is not possible for the datasource of dictionary project also.

[Former Member · Accepted solution]

Hi,

evn i'm talking abot stateless session bean..it will contain business logic only..

bt u mst have entity beans also for data transfer to database..

wn u'll map fields persistenet.xml as i hav told u..it will map fields wid ur datadictionary project...

As u r making changes in persistent.xml for datasiurce..so these changes will automatically reflectd to dictionary project also..dictionary proj will refer to ejb projct...

Regards,

Khushboo

[Former Member]

Hi Eswar,

your error is showing that SAPPD1DB is not system id of ur database...

so u need to give system ID of database in place of SAPPD1DB.

which u can get from portal administrator..

for lookup operation u must b giving code like this into session bean..

	Entity_MTLocalHome MTlcl;

			MTlcl =
				(Entity_MTLocalHome) ctx1.lookup(
					"java:comp/env/PPm_Kejb/Entity_MTBean");

hope it hlps..

Regards,

Khushboo

[Former Member]

Hi Khushboo Singhal,

Thanks for giving reply.

i getting same error in dictionary project also.

in Dictionary prospective i created a table and deployed .its created .sda file also.

And in testing table i written Query like select * from table tablename.

then it showing error Object not found in lookup of SAPPD1DB.

In this where we can change the data source.if the admin say that the datasource is sapcdipb .Then we need to DO.

plz help me .