Skip to Content

Can we use Views JDBC Sender adapter

Nov 07, 2016 at 11:01 PM


avatar image

Hello Expert

I am creation the JDBC to SOAP scenario . My DBA provided me the views name instead of SQL statement . i have few question .

Q1. Can we use Views instead of Sql statement ?

Q2. what is source structure ?

Q3: Please share some link for this process.

Thanks & Regards

Pankaj Singh

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Evgeniy Kolmakov Nov 08, 2016 at 01:43 AM

Hi Pankaj!

A1. Since the View object in database actualy is a pre-defined SQL statement (with additional parameters or without) it's no difference between selecting from DB table or View object. When you select from View, SQL statement defined for that View is performed first and than you perform select from result table.

For example: We have a View object named "Customers_View" in DB defined as:

SELECT TOP (100) PERCENT CustomerID AS CustID FROM dbo.Customers ORDER BY CustID

To query this View in sender JDBC adapter we use SQL statement:

SELECT CustID FROM Customers_View

A2. Your DBA should provide the View result table structure definition.

One thing: while querying the View, you should provide the way for updating source table(s) after receiving data in order to avoid repeatable reading of the same data from View object.

Regards, Evgeniy.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Evgeniy Kolmakov for quick response and helpfull answer.