JDBC Sender -Not selecting records

[Former Member]

Hi all

I have set up a JDBC sender. The communication channel monitor shows that "Polling interval started" but It is not retrieving data from the JDBC table using a select statement.

This is a sql select statement.

SELECT * FROM table

there is also a corresponding update statement.

clearly ,XI is unable to pick up data from the table.

if i change the name of the table , it does throw an SQL exception that the object doesnt exist. I have also checked with other tables and it is fetching data correctly. The table under problem does contain a row of data in ORacle side.

Why doesnt XI select the records of the table?

Any help will be highly appreciated

thanks

krishna

[prateek · Accepted solution]

Are u sure the table has data? Just a check.

Make sure polling interval is not very large.

Also could u provide ur other JDBC params

Regards,

Prateek

[Former Member · Accepted solution]

Hi

yes, the table does contain data

and the sql stmnt is actually

select * from table where flag= 'true' ( i also tried it without the where condition)

here are the other parameters

QOS : Exactly Once

Poll interval: 6

Document name: Resultset

Update sql stmnt : UPDATE TBL SET FLAG = 'FALSE' WHERE FLAG = 'TRUE'

hope this helps

regards

krishna

[bhavesh_kantilal · Accepted solution]

Do you see anything speacial int he polling interval in the Log in Comm Channel Monitoring?

Is it still 6 seconds or does it become 12 seconds?

Regards

Bhavesh

[Former Member · Accepted solution]

Hi bhavesh

In the CC monitoring , it is always 6 seconds polling interval

also, We initially solved the problem by deleting, recreating and reloading the data.

and it picked up. but again we are facing the same issue. It is not reading the data into the pipeline

any help?

regards

krishna

[bhavesh_kantilal · Accepted solution]

Try using option Disconnect From Database after each messahge processing in the sender JDBC adapter and give this a shot.

Must be some security restiction on the database that it does not allow a Active connection.

regards

Bhavesh

[Former Member · Accepted solution]

Thanks Bhavesh

Will give a shot at it and update you

thanks

krishna

[Former Member]

.

[former_member431549]

Does this work for a while and then stop, or just not work at all ?

Look for any AE errors in message monitoring also. Occasionally, a sender comm channel will encoutner an error and jsut stop polling, but show green.

[Former Member]

Have you specified the correct message type in the CC.

Is you adapter active??

Mudit

[Former Member]

Mudit

Yes, they are all fine

regards

krishna