JDBC TO FILE

[Former Member]

hI,

i AM DOING A JDBC TO FILE SCENARIO.JDBC ADAPTER IS POLLING THE DATABASE AND IN COMM CHANNEL ITS SHOWING PROSESSING SUCCESFULLY.BUT IN SXMB_MONI ITS NOT SHOWING ANY MESSAGE

SO WHT I SHOULD DO?

[Former Member]

Hi Vikas,

what is your query statement ???

- Varun

[santhosh_sontha2]

Go to Runtime workbench in that go to adapter engine->Communication channel monitoring and give your Sender communication channel name(JDBC adapter). May be there you can track what the error is.

Regards,

Santhosh

[Former Member]

Hi Vikas,

JDBC comm channel may be polling successfully but is it polling any data successfully from the database?

-Pinkle

[Former Member]

hi,

no there is no data coming.wht can be the reason.wht i should do

[Former Member]

Hi,

In JDBC communication channel what Select query you have written.

Is there any data avaialble as per it and are you maintaining the proper update query also for it.

Mostly there will be somthing abrrupt about the Select query as per the avaialble data .

refer below link

Tips and Tutorial for Sender JDBC Adapter

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

Thanks

Swarup

Edited by: Swarup Sawant on Feb 13, 2008 10:52 AM

[Former Member]

Hi Vivek,

Check your select statement and see whether any data populating using that statement.

-Pinkle

[Former Member]

Hi everyone,

I have maintained proper configuration

My table is VIKAS and there are 4 columns in tht

NAME

ID

ADDRESS

FLAG

SQL QUERY I WROTE IS

SELECT * FROM VIKAS WHERE FLAG= ' TRUE'

AND

UPDATE QUERY IS

UPDATE VIKAS set FLAG = 'FALSE' WHERE FLAG = 'TRUE'

AND

ISOLATION LEVEL IS SERIALIZABLE

IN RUNTIME WORKBENCH IN COMM CHANEEL MONITORING ITS NOT GIVING ANY ERRORS.ITS SHOWING PROCESSING SUCCESFULLY

WHT SHOULD I DO?

ITZ URGENT

[Former Member]

-Check the Sender JDBC adapter is running and up.

-Check the SQL querry in the Select and Updage in the CC

-Check you have an authorization to read the tables

-Check SQL querry is correct and records should be available in the tables.

-Execute the same query in the Database and check it is working fine and selecting data for that or not.

Thanks

Farooq