DataBase LookUp - Null pointer Exception ?

[former_member189387]

Hi Friends ,

I have gone through the Siva's Blog

/people/bhavesh.kantilal/blog/2006/11/20/webservice-calls-from-a-user-defined-function . for Lookup to data base .

I have done the desing and configuration .In Configuration part I have configured the JDBC Receiver Adapter under BusinessService <b>BS_JDBC_LOOKUP</b> . Communication Channel name is JDBC_RECEIVER_LOOKUP .

In lookup code i have used as

<b> channel = LookupService.getChannel("BS_JDBC_LOOKUP","JDBC_RECEIVER_LOOKUP");</b>

While i was testing in Message Mapping .I am getting value as null .

the error is <b>number of registered services: 0</b> .

Can you please tell me how to rectify this problem ? all the database configurations as done properly .

Regards .,

V.Rangarajan

[prabhu_s2 · Accepted solution]

maybe in the blog DB-SYSTEM-NAME and DB-CHANNEL-NAME refers to the prperty of getChannel. did u check by having the def set as in the blog?

[Former Member]

Hi

Try this

/people/prasad.illapani/blog/2006/10/25/how-to-check-jdbc-sql-query-syntax-and-verify-the-query-results-inside-a-user-defined-function-of-the-lookup-api

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/9aedca11-0d01-0010-3b90-9ea...

Thanks