Testing the JDBC adapter communication channel

[former_member271795]

Hi

I've created an interface which gets the sender payload using a JDBC adapter.

Basis have installed the JDBC driver for the database where the data resides

I've configured the communication channel to poll every 10 minutes

So far nothing appears to be happening

Can I test the communication channel independantly?

Is there a procedure to make the communication channel active?

Is there an admin area where I can see if there is an issue with the communication channel.

I've checked SMQ1, SMQ2 and SXMB_MONI and there are no messages

I've also checked runtime workbench => adapter monitoring => communication channels but I get an empty list

all help will be very much appreciated

[Former Member]

Hi,

what do you see in runtime workbench => adapter monitoring => communication channels ?

Is your communication channel doing polling? or not?

Do you see some message id, but without payload? Maybe you doesn't select correctly your source data....

Regards,

Carme

[former_member271795]

Thanks

I went to the adapter monitoring and got a JSP error

There is an error in the java layer

and I think the JDBC driver isn't working correctly

thanks for all you help

[Former Member]

Hi Geoff,

It is not possible to check only the communication channel but we can check the complete scenario confogured in Integration Directory.

1. Open ID.

2. Goto Tools.

3. Provide the sender and the receiver parameters.

4. Also provide the payload in the Payload section.

5. Now, goto Test Configuration

6. Select Run.

This shows you, if there are any issues in the configuration.

Thanks,

[former_member271795]

Hi

I've tried this and the configuration seems to be fine

but it doesn't seem to test the communication channels

as you have to define the payload

It tests the receiver determinaton, message mapping. etc

What I need to establish is that the data is coming into the interface.

thanks for your help

Geoff

[Former Member]

I understood that you are not able to pick the data from the Database.

If so, there might be an issues with the drivers or with the connection. As in the communication channel you are not able to see anything then the data is not been picked up. Check the adapter configuration once again and also check with the BASIS team regarding the drivers and connection.

Thanks,