> I have deployed a stored proc that reads data from url and inserts rows for the data extracted from the URL
> When I run the proc from the SQL Scrap book (JBoss Studio) it insert correct number of rows.
> I then exposed this proc over ODATA
> when I hit the ODATA url which invokes the proc. it inserts double the records. the ODATA response shows correct number of records. but the database has duplicate records.
> I have 3 sources (postgres database, vertica database, restful webservice call) in my VDB and 1 view. But its not a multi-source VDB, as in the multi-source checkbox is not checked.
Seems like its invoking the PROC twice.
I would like to debug the stored proc invocation from teiid-odata component. how do i go about doing it? please help!
The first thing to check is the logs at a debug level - especially the command log which will explicitly show what user/source queries were executed. See Logging - Teiid 8.8 (draft) - Project Documentation Editor