Skip to Content
0
Former Member
Jun 07, 2011 at 01:18 PM

SQL query for JDBC adapter

57 Views

Hello Everyone,

I am using a simple SELECT to fetch data from sql DB. The only SELECT it seems to fetch data is when it is getting data from sys tables. It does not work for fetching data from application tables created in the sql DB. Could this be a authorization issue? Listed below are the different SELECT statements used in PI and that works in SQL too.

1. SELECT Query : SELECT * from sys.tables

UPDATE : <TEST>

The above SELECT works and I can see all the xml messages in SXMB_MONI.

2. SELECT Query : SELECT * from sql_ztable

UPDATE : <TEST>

The above SELECT does not show any xml messages. There are records in the sql_ztable. When checking the CC monitoring I get the following message below.

Polling interval started. Length: 60.0 seconds

Processing finished successfully

Any suggestions?

Thanks,

Teresa