cancel
Showing results for 
Search instead for 
Did you mean: 

Sender JDBC Adapter

Former Member
0 Kudos

Hi Guys,

Am configuring Sender JDBC Adapter

1) Deployed required drivers

2) Made config

in RWB CC monitoring i can see the adapter is with greem led and says always process started that's it no other message.

but when i execute the sql statement presnt in Adapter in SQL PLUS it executes but not happening with the adapter.

No errors shown..

any way to find out any check to be done

rgds

srini

Accepted Solutions (0)

Answers (3)

Answers (3)

prateek
Active Contributor
0 Kudos

Either ur sender channel is not activate, or the sql statement is not working due to improper connection or improper statement.

Regards,

Prateek

Former Member
0 Kudos

hello venkat ,

if you continously showing processing started in Audit Log then adapter might have got locked.

Check in the Visual Admin >Cluster> "LOCKING ADAPTER"

we get a option of Display Locks .Check for an entry with

NAME : $XIDBAD.JDBC2XI

reset the locks and restart the CC ,now it works fine.

Note 1083488 - XI FTP/JDBC sender channel stop polling indefinitely(04/04S)

regards

Ganga

Former Member
0 Kudos

Hi Ganaga,

Wat u said was abosutely correct

i have unlocked the Adapter but it's geting locked so frequently again ,

Do i need to do anything ??

rgds

srini

Former Member
0 Kudos

Stop and Start the CC thats enough

Venkat even after reset the Lock if you are facing the problem.

Then delete the Lock Entry.

Edited by: gangaprasad chintala on Aug 12, 2008 2:17 PM

Former Member
0 Kudos

Hi

Stoped and started again but still it get's locked

any inputs

rgds

srini

Former Member
0 Kudos

have u deleted the lock entry?

Even after deleting lock entry if you are facing the problem then Try the following :

1) Give the Wrong Connection Parameters in you JDBC Sender Adapter

2) Check the Adapter Audit Log ,You will get some connection errors

3)After finding the connection errors, Now give the correct details in the JDBC Sender Adapter.

This to jst ensure that the JDBC adapter gets disconnected from the DB once and reconnect.

regards

Gangaprasad

Former Member
0 Kudos

Hi,

What could be the problem if i put wrong sql statement it show error , but when it is correct it say only process started no message id there in .

and it gets locked immmediately

rgds

srini

Former Member
0 Kudos

Hi

Did as said but when given wrong para it throws error but when given correct it says started processing and get's locked

rgds

srini

Former Member
0 Kudos

THX

Former Member
0 Kudos

Dear Srinivas,

I hope you can get some idea with the communication channel Monitoring in RWD for the sender JDBC Adapter.

Check the log for the same and see whether table data is sent by JDBC adapter to XI server.

Best Regards

Praveen