JDBC Sender Adapter to Oracle Server

[Former Member]

Hi Friends,

Iam using JDBC Sender Adapter to connect to Oracle Server. I have mentioned all the parameters in the Configuration(sender communication channel) correctly.My Adapter Monitoring in RWB shows a message that "Processing finished successfully"...But I cannot see the data in SXMB_MONI. I mean the data is not getting picked from the Database..I have worked on the similar scenario previously and it was working fine...

I have specified the datatype structure correctly.

resultset

>row

>>field1

>>field2

wat is the problem.

regards,

raju...

[bhavesh_kantilal]

Hi,

Can you check the following,

1. Check the SELECT query in your Sender JDBC adapter. Does it actually return any rows?

2. The values enterd for Documentname and DocumentNamespace in your Sender JDBC adapter. You have to enter the name of the Datatype and the namespace in these fields.

3.Have you enterd these details while doing the adapter configuration,

<b>jdbc:oracle:thin:@<IP adress>:<listener port>:<instance name (database name)>

Driver oracle.jdbc.driver.OracleDriver</b>

Regards,

Bhavesh

[bhavesh_kantilal]

Hi,

Another thing that is to be checked is, if the table strucutre has changed in the database, if yes, deactiavte and activate the Sender Adapter once again and it should work.

Regards,

Bhavesh