Skip to Content

Can we use Views JDBC Sender adapter

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • 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.

    Add comment
    10|10000 characters needed characters exceeded