JDBC LOOK UP

[Former Member]

Hi

I am getting following error while doing JDBC LOOK UP

IN MESSAGE MAPPING

Exception during processing the payload.problem when calling adapter by using communication channel

JDBC_LOOKUP_CC(Party,Service: BS_jdbc, Object ID: 4718bcd4bd663c95bce7260857e37794)

can any one please give me suggestion how to solve this

thanks&regards

venkat

[Former Member]

Hi,

Check your JDBC Communication Channel in the ID.

Also first go to RWB-COmponenet Monitoring>Adapter Engine>COmmunication Channel Monitroing and check the status of the JDBC adapter =JDBC_LOOKUP_CC

It should not be in Error state, if it is then you will get Error duing testing Lookup in Message Mapping.

So first fix the adapter...Following are the cause of JDBC adapter Error :

- Connection String

-JDBC Driver is not proper

-Authentication (username and password)

- Status should be Active.

Thanks

Farooq.

*Rewards Points if you find it useful*

[park_saeiam]

Hi Venkat,

In case you need to do jdbc lookup from MM. You need to make sure your CC should to be receiver and please check your BS and CC in java code that is correct or not.

String Query = " ";

String tmp="";

Channel channel = null;

DataBaseAccessor accessor = null;

DataBaseResult resultSet = null;

Query = "SQL QUERY";

try{

//Determine a channel, as created in the Configuration

channel = LookupService.getChannel("BUSINESS SERVICE","Communication Channel");

//Get a system accessor for the channel. As the call is being made to an DB, an DatabaseAccessor is obtained.

accessor = LookupService.getDataBaseAccessor(channel);

//Execute Query and get the values in resultset

resultSet = accessor.execute(Query);

for(Iterator rows = resultSet.getRows();rows.hasNext();)

{

Map rowMap = (Map)rows.next();

tmp = String.valueOf(rowMap.get("FieldName"));

result.addValue(tmp);

}

}

catch(Exception ex){

result.addValue(ex.getMessage());

}

finally{

try{

if (accessor!=null) accessor.close();

}

catch(Exception e){

result.addValue(e.getMessage());

}

}

[aashish_sinha]

Hi,

Can you please check your sender communication channel for JDBC Adapter and the check out the payload format and also check that in what format u quering to DB.

Regards

Aashish Sinha

PS: Reward points if helpful